We provide IT Staff Augmentation Services!

Oracle Sql/plsql Developer Resume

4.00 Rating

Charlotte, NC

SUMMARY

  • Almost 8 Years of experience in analysis, design, development and implementation as SQL/PLSQL Developer working on Oracle 9i/10g/11g platforms.
  • Excellent hands - on experience in Software Development Life Cycle (SDLC) that includes requirements gathering, functional and technical specifications, design, development, testing and production deployment.
  • Experience in developing PL/SQL Stored Procedures, Functions, Packages, Database Triggers using features like Cursors, Collections, Exception Handling and good in Oracle Forms and Reports.
  • Strong experience in developing Oracle PL/SQL packages in application development.
  • Experience on working with TOAD, SQL*Plus, SQL developer and PL/SQL Developer tools.
  • Hands on experience in supporting ETL tools Data Stage.
  • Strong skills in optimization and performance tuning of SQL Queries using different utilities like STATSPACK, EXPLAIN PLAN, SQL TRACE and TKPROF.
  • Excellent knowledge in troubleshooting the SQL performance issues by analyzing Automated Workload Repository (AWR) Reports.
  • Working experience in using Export, import and data pump utilities to export/import the tables in schema.
  • Working experience in developing JIL files to schedule jobs in AUTOSYS.
  • Hands on experience working on UNIX platforms in developing shell scripts to schedule the jobs in cron tab.
  • Worked on data migration from text, csv files to oracle database tables using sql loader.
  • Well experienced in developing the Data mart in Star Schema and Snowflake Schema, Flat files and building the Data warehouse.
  • Working experience in developing Data model, ER Diagrams and organizing the data as per the functional requirements.
  • Excellent communication skills and ability to work individually and as a member of a team.
  • 24X7 on-call support for production environment.

TECHNICAL SKILLS

Databases: Oracle 11g/10g/9i

Operating Systems: Red Hat Linux, Aix, Solaris, Windows 98/2000/2003/2005/ NT/XP

Language: Shell Scripting, C, C++, SQL, PL/SQL

Tools: Import/Export manager, Datapump Utilities, TOAD, SQL*Loader, SQL Developer

Data Modeling: Sybase Power Designer, Erwin

ETL Tools: IBM Information server 8.0/8.1

Job Scheduler: AUTOSYS

PROFESSIONAL EXPERIENCE

Confidential, Charlotte NC

Oracle SQL/PLSQL Developer

Responsibilities:

  • Requirements gathering from business users, analysis and system design.
  • Data modeling using Sybase power designer to design the data model and creating entities and relationships.
  • Created database objects Tables, Views, Indexes, Sequences, and Synonyms, procedures, packages.
  • Created the PL/SQL packages, procedures and functions.
  • Migrating application code from Development to Testing environments.
  • Performance tuning of the PL/SQL code and SQL queries using optimizer hints.
  • Created partitioned tables and indexes to resolve performance issues.
  • Migrating database objects and data between databases using data pump utilities (expdp/impdp)
  • Exporting and importing data from text and CSV files using SQLLOADER.

Environment: Oracle 11g, SQL Developer, TOAD, RTC (Rational Team Concert), Sybase Power Designer, UNIX and Windows NT.

Confidential, Charlotte NC

Oracle SQL/PLSQL Developer

Responsibilities:

  • Involved in gathering requirements from business users, analysis and system design
  • Created and managed data base objects such as Tables, Views, Indexes, Sequences, and Synonyms, procedures, packages
  • Created the PL/SQL packages, procedures, functions applying the business logic to load the data to relevant tables
  • Deployment and migration of DB Scripts in Production after testing in SDLC including Development and testing environments
  • Prepared the ETL Technical design and mapping documents.
  • Developed Datastage parallel jobs, by using database stages, file and processing stages.
  • Worked on different stages to develop parallel jobs like Join, Merge, Lookup, Filter, Modify, Pivot Enterprise, Copy, Filter, and Aggregator.
  • Analyzed data to check for Data Integrity and Referential Integrity when loaded to source-staging tables
  • Involved in Logical Data Modeling (LDM) and Physical Data Modeling (PDM) in accordance with the business requirements
  • Developed the SQL*Loader scripts to load data into the staging tables from the flat files.
  • Worked on data migration from text, csv files to oracle database tables using sql loader
  • Extensively worked in tuning the queries and applying hints for faster and better performance of the SQL queries
  • Worked in preparing functional document, user document, process flow diagram and flow chart
  • Developed views to facilitate easy interface implementation and enforce security on critical customer information.
  • Created and manipulated stored procedures, functions, packages and triggers using TOAD and SQL Developer.
  • Identifying and tuning the long running queries by analyzing the AWR reports.
  • Worked on DBMS STATS to gather the table, index and schema level statistics.
  • Used TKPROF to get the explain plan for the long running SQL’s.
  • Worked on Oracle packages like UTL FILE to open, read and write files to OS directories
  • Involved in preparing test plans, unit testing, System integration testing, implementation and maintenance
  • Designed and Created Database objects and Written PL/SQL PROGRAMMING for ETL jobs.
  • Created UNIX shell scripts to run Data stage batch jobs through Autosys

Environment: Oracle 11g (OLTP, OLAP), Oracle 10g, Data Stage 8.1.2/8.0.1 , XML files, CSV files, flat files, SQL server 2005, SQL Developer, TOAD, UNIX, and Windows NT.

Confidential, Charlotte NC

Oracle SQL/PLSQL Developer

Responsibilities:

  • Requirements gathering, analysis and design.
  • Involved in creating specification documents, mapping documents, data flow diagrams, ER diagrams, dependency documents.
  • Participated in system analysis, data modeling and database designing which included creating tables, views, indexes, synonyms, triggers, functions, procedures, cursors and packages.
  • Worked extensively in PL/SQL and developed complex packages, procedures and functions using SQL Developer as well as SQL PLUS.
  • Extensively worked on Cursors, ref Cursors, Nested Conditional Statements, Co-Related sub-queries, DB Links.
  • Closely working with testing teams to resolve the code defects.
  • Excellent experience in resolving SQL performance issues by analyzing the EXPLAIN plan.
  • Tuning the PL/SQL procedures and packages and modified code accordingly to improve performance
  • Created indexes and partitions on various tables in order to enhance performance.
  • Involved in Logical and Physical Database design and Star Schema design. Identified Fact tables, Transaction tables.
  • Actively involved in Production Support by Performing Tests, Trouble Shooting and Bug Fixing.
  • Enhanced database performance and PL/SQL context switching by implementing PL/SQL Bulk Collect features

Environment: Oracle 11g/10g, SQLPLUS, SQL Developer, TOAD, RHEL 5

Confidential

Oracle SQL/PLSQL Developer

Responsibilities:

  • Analysis of new business requirements gathering by talking to the business, worked on analysis and design.
  • Worked thoroughly on coding, enhancing and debugging of procedures, packages and other Oracle objects.
  • Worked on Oracle utilities, which were used for generating/loading flat files and exporting/Importing flat file.
  • Supported backend of client order processing application which handles orders placed by client.
  • Product’s Backend release management.
  • Worked on change request when there was any support issue that involved code changes, data maintenance and bug corrections. Change requests involved enhancement to system components.
  • Tuning of SQL statements using EXPLAIN PLAN to improve the performance.
  • Worked on Integration Testing, which was used to determine if software modules function together correctly.
  • Performed tuning for PL/SQL procedures and packages and modified code accordingly to improve performance
  • Created indexes and partitions on various tables in order to enhance performance.
  • Provided support and played a major role in debugging production issue.
  • Performed code reviews on PL/SQL.
  • Created database objects like tables, views, synonyms, indexes, and sequences.

Environment: Oracle 10g, SQLPLUS, SQL server 2005, SQL Developer, TOAD, UNIX.

Confidential

Oracle SQL/PLSQL Developer

Responsibilities:

  • Involved in creating specification documents, mapping documents, data flow diagrams, ER diagrams, dependency documents.
  • Developed UNIX shell scripts.
  • Worked on table partitioning (Range) and deploying various methods of indexing like local indexes on partitioned tables.
  • Participated in system analysis, data modeling and database designing which included creating tables, views, indexes, synonyms, triggers, functions, procedures, cursors and packages.
  • Created Pl/SQL Tables, Record Types, Indexes on tables to improve performance.
  • Extensively worked on Cursors, ref Cursors, Nested Conditional Statements, Co-Related sub-queries, DB Links.
  • Worked extensively in PL/SQL and developed complex packages, procedures and functions using SQL Developer as well as SQL PLUS.
  • Performed Database Tuning - SQL Tuning using Oracle’s regular performance tuning methods like Explain Plan, SQL*Trace, TKPROF, ADDM and AWR.
  • Migrated the data from Excel sheets, text files into the respective Oracle Database tables using SQL *Loader scripts.
  • Identified potential inefficient queries using Explain Plan and worked on Performance Tuning using hints.
  • Involved in intensive Unit Testing and in writing Test plan document for QA.
  • Written DDL scripts to create and update objects like tables, views, indexes, triggers, synonyms and sequences.
  • Used SQL*Loader scripts to load legacy data into test environment.
  • Written Stored Procedures and Functions
  • Written procedures to populate missing interval data for multiple data sets with default data.
  • Responsible for the development and maintenance of end-user documentation.

Environment: Oracle 9i, TOAD, UNIX, Erwin, SQL Loader, UNIX scripting.

We'd love your feedback!