LiveCareer
LiveCareer
  • Dashboard
  • Jobs
  • Resumes
  • Cover Letters
  • Resumes
    • Resumes
    • Resume Builder
    • Resume Examples
      • Resume Examples
      • Nursing
      • Education
      • Administrative
      • Medical
      • Human Resources
      • View All
    • Resume Search
    • Resume Templates
      • Resume Templates
      • Nursing
      • Education
      • Medical
      • Human Resources
      • Customer Service
      • View All
    • Resume Services
    • Resume Formats
    • Resume Review
    • How to Write a Resume
    • CV Examples
    • CV Formats
    • CV Templates
    • Resume Objectives
  • Cover Letters
    • Cover Letters
    • Cover Letter Builder
    • Cover Letter Examples
      • Cover Letter Examples
      • Education
      • Medical
      • Human Resources
      • Customer Service
      • Business Operations
      • View All
    • Cover Letter Services
    • Cover Letter Templates
    • Cover Letter Formats
    • How to Write a Cover Letter
  • Jobs
    • Mobile App
    • Job Search
    • Job Apply Tool
    • Salary Calculator
    • Business Letters
    • Job Descriptions
  • Questions
  • Resources
  • About
  • Contact
  • 0Notifications
    • Notifications

      0 New
  • jane
    • Settings
    • Help & Support
    • Sign Out
  • Sign In
Member Login
  • LiveCareer
  • Resume Search
  • Oracle PL/SQL Developer
Please provide a type of job or location to search!
SEARCH

Oracle PL/SQL Developer Resume Example

Resume Score: 80%

Love this resume?Build Your Own Now
ORACLE PL/SQL DEVELOPER
Professional Summary
Over 5 years of experience in designing, developing, implementing and testing database applications and solutions as Oracle PL/SQL Developer.
Skills
  • Oracle PL/SQL specialist
  • Experience in using SQL Navigator, TOAD for Oracle, SQL Developer, and Eclipse developing tools
  • Experience with working on Harvest (CA Software Change Manager), PVCS VM, and Git Version Controls
  • Advanced knowledge of various databases such as Oracle, MS Access, and Teradata
  • Working knowledge with DB Tools/Utilities like OM, SQL*ELoader, Explain Plan, TKPROF, Import/Export, and EXPDP/IMPDP
  • Advanced knowledge of Linux Shell Scripting
  • Data Warehouse ETL design knowledge
  • Knowledge of Java core, C, and C++
  • Advanced problem solving skills
  • Troubleshooting and debugging
  • Performance and scalability optimization
  • Knowledge of using Data Modeling Tools such as Erwin and Visio
Work History
Oracle PL/SQL Developer, 06/2012 to Current
Highmark Inc. – Pittsburgh, PA
  • Involved in understanding the technical direction of the programming staff from a back end database design and development perspective.
  • Developed Linux Shell/SQL Scripts for data extraction, transformation and to load on staging tables.
  • Developed PL/SQL Procedures/Functions/Packages to load data into Dimension and Fact tables.
  • Improved data warehouse's performance by implementing advanced Oracle Data Warehousing features: Materialized Views, Partitioning, External Tables, Dimensions, Parallel Execution.
  • Worked with Production Support team to immediately resolve failures in production data processing. Collaborated with business users on
    resolving data inconsistency and reporting issues.
  • Used SQL*Loader and created the External Tables in order to load data from flat files into oracle tables.
  • Extensively used Bulk Collect and FORALL statements for manipulating the large amount of data and enhance performance.
  • Wrote complex SQL queries using joins and sub queries to retrieve data from the database. Also made use of set operators like Union, Union all, Intersect and minus.
  • Responsible for performance tuning using Explain plan, TKPROF and oracle Hints. Used Table Partitioning in huge Table to increase database performance.
  • Responsible for Import and Export of database objects as per requirement. Also used DB LINKS for accessing data across different databases.
  • Used 'SQL Navigator' IDE for developing and managing Pl/SQL
    scripts.
  • Used Bitmap, B-Tree Index and functional based Index to enhance
    performance to retrieval Data from database table.
  • Handled errors using system defined exceptions and user defined exceptions.
  • Optimized and enhanced the existing procedures and SQL statements for the better performance.
  • Attended walk through, Code review and Status meeting to discuss the status of the project.
Oracle PL/SQL Developer, 10/2010 to 03/2012
US Census Bureau – Suitland, MD
  • Involved in understanding the technical direction of the programming staff from a back end database design and development perspective.
  • Developed procedures, functions and packages to implements the business Requirement using PL/SQL.
  • Created Dynamic SQL script in PL/SQL to build SQL statements dynamically at runtime.
  • Used SQL*Loader and created the External Tables in order to load data from flat files into oracle tables.
  • Extensively used Bulk Binding and Collections for manipulating the large amount of data and enhance performance.
  • Wrote complex SQL queries using joins and sub queries to retrieve data from the database. Also made use of set operators like Union, Union all, Intersect and minus.
Oracle DBA/PL/SQL Developer, 10/2005 to 11/2007
IONNOR Solutions – Mohali, Punjab, India ‎
  • Analyzed the business requirements of the project by studying the Business Requirement Specification document.
  • Installed and upgraded oracle database server.
  • Migrated database from DB2 and MS Access to Oracle Database.
  • Created/Modified tables, views, queries for new enhancement in the application using TOAD.
  • Created/Modified database objects like packages, procedures, functions, and triggers and handled errors using Exceptions.
  • Extracted data from Flat files and transformed it in accordance with the Business logic mentioned by the client.
  • Created indexes on the tables for faster retrieval of the data to enhance database performance.
  • Extensively involved in using hints to direct the optimizer to choose an optimum query execution plan.
  • Created custom PL/SQL procedures to read data from flat files to dump to Oracle database using SQL*Loader.
  • Used PL/SQL Wrap Utility to encrypt PL/SQL source code and to make the code portable to any platform.
  • Wrote complex SQL queries including inline queries and sub queries for faster data retrieval from multiple tables.
  • Created and modified several UNIX shell scripts/ Dos Batch files according to the changing needs of the project and client requirements.
Education
Master of Science: Computer Engineering, 2010
University of Bridgeport - Bridgeport, CT (USA)
Post Graduate Diploma in Computer Application: Computer Application, 2005
Guru Nanak Dev University - Punjab, India
Bachelor of Science: Computer Application, 2004
Guru Nanak Dev University - Punjab, India
Certifications
  • Oracle Advanced PL/SQL Developer Certified Professional
    (1Z0-051,1Z0-147,1Z0-146)
  • Oracle Certified Associate, Oracle Solaris 10 Operating System (1Z0-876)
Build Your Own Now

DISCLAIMER

Resumes, and other information uploaded or provided by the user, are considered User Content governed by our Terms & Conditions. As such, it is not owned by us, and it is the user who retains ownership over such content.

Resume Overview

Companies Worked For:

  • Highmark Inc.
  • US Census Bureau
  • IONNOR Solutions

School Attended

  • University of Bridgeport
  • Guru Nanak Dev University

Job Titles Held:

  • Oracle PL/SQL Developer
  • Oracle DBA/PL/SQL Developer

Degrees

  • Master of Science : Computer Engineering , 2010
    Post Graduate Diploma in Computer Application : Computer Application , 2005
    Bachelor of Science : Computer Application , 2004

Create a job alert for [job role title] at [location].

×

Advertisement

Similar Resumes

View All
Senior-Oracle-/-MS-SQL-Database-Administrator-resume-sample

Senior Oracle / MS SQL Database Administrator

Manchester, Ohio

SQL-Developer-resume-sample

SQL Developer

ABC Technology

Irving, Texas

SQL-DBA-Developer-.NET-Developer-resume-sample

SQL DBA Developer .NET Developer

IAC

Belvidere, Illinois

About
  • About Us
  • Privacy Policy
  • Terms of Use
  • Sitemap
Help & Support
  • Work Here
  • Contact Us
  • FAQs
Languages
  • EN
  • UK
  • ES
  • FR
  • IT
  • DE
  • NL
  • PT
  • PL
Customer Service
customerservice@livecareer.com
800-652-8430 Mon- Fri 8am - 8pm CST
Sat 8am - 5pm CST, Sun 10am - 6pm CST
  • Stay in touch with us
Site jabber winner award

© 2021, Bold Limited. All rights reserved.