We provide IT Staff Augmentation Services!

Oracle Pl/sql Consultant Resume

Monroeville, PA

SUMMARY

  • Developed database design (logical and physical models) by understanding relational database concepts such as indexes, primary and foreign keys and constraints.
  • Solid experience of creating PL/SQL Packages, Procedures, Functions, Triggers and Views to retrieve, manipulate and migrate complex data sets in Oracle Databases.
  • Ability to develop UNIX shell scripts in applications that schedule, validate flat file data, Execute SQL, achieve files or FTP files.
  • Experience in Performance Tuning & Optimization of SQL statements using various types of Hints, Indexes, Explain plan, Table Partitioning, Trace utility, TKProf, DBMS PROFILER & DBMS STATS.
  • Experience in creating SQL* loader scripts to load data from flat files into the database and also creating External Tables to manage data which is store at the OS level.
  • Effectively made use ofIndexes, Table Partitioning, Collections, Analytical functions, Materialized Views.
  • Worked on Forms and reports using Oracle Forms/Reports Builder 11g.
  • Implemented features including Materialized views, Autonomous Transactions, Coding Dynamic SQL Statements.
  • Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
  • Experience in using Automation Scheduling tools like Autosys, CA7, OPC/TWS and Control - M.
  • Involved in various phases of Agile as methodology in which we used Scrum as architecture design and development.
  • Monitor and execute Mainframe batch cycles and maintain priorities on local and remote systems to ensure successful completions.
  • Performed various roles during my career in Mainframes as a specialist in most of the Mainframe server system performances (Z/OS Upgradation, Disaster Recovery and Service Delivery) and also in Maintenance & resolving production fixes.
  • Ability to work individually as well as in a team wif excellent problem solving and troubleshooting capabilities.

TECHNICAL SKILLS

  • SQL
  • PL/SQL
  • Oracle 10g/11g/12c
  • DB2
  • UNIX
  • Shell Scripting
  • Performance Tuning
  • Core Java
  • .NET
  • SOAP UI
  • TOAD
  • ETL Concepts
  • Erwin
  • JIRA
  • ALM
  • Sub Version winCVS
  • Splunk
  • IBM Cognos programming
  • SQL*Loader
  • JCL
  • CICS
  • IDMS
  • IMS
  • Netview
  • Omegamon
  • COBOL
  • FileZilla
  • WinSCP
  • OS/390 z/OS
  • MS Windows NT 4.0/XP/ Win 7
  • Linux
  • OpenVMS
  • Unix
  • Solaris.

PROFESSIONAL EXPERIENCE

Confidential, Monroeville, PA

Oracle Pl/Sql Consultant

Responsibilities:

  • Preparing project-phase plans and implementation schedule, plan and conduct meeting and workshops relative to the project plans, and communicate day to day project status to all levels of management
  • Created Stored Procedures for Batch Processing and also involved in moving large data using Bulk Insert forall methods.
  • Analyzed data integrity problems and provided assistance in giving solutions.
  • Responsible for troubleshooting, debugging, problem solving and tuning for improving performance of the backend application programs
  • Experienced in PL/SQL Performance Tuning using Bulk Collections and other optimization techniques,
  • Involved in coordinating onsite and offshore communication / meetings.
  • Designed and Developed scripts for uploading data from flat files and XML files into database, performing business validations on the data usingPL/SQLProcedures.
  • Developed unix shell scripts to load data into database and also automate backend jobs.
  • Debugging the scripts and jobs in Production environment written in Shell.

Confidential, Boston, MA

Oracle Developer

Responsibilities:

  • Involving in the estimations for the project, perform analysis on the business requirements and prepare High Level Design and Low Level Design
  • Create the technical design document and convert them into technical specifications.
  • Configured and designed Entity Relationship Diagram (ERD) wif Data Design team to illustrate the logical structure of the database.
  • Involved in performance tuning - analyzing query plans and query tuning.
  • Designed and modified database tables, keys, indexes, views, type objects, grants, triggers, Exception handling methods, Packages, Functions and Procedures etc.
  • Partitioned tables using Range partitioning, List partitioning and created local indexes to increase the performance and to make the database objects more manageable.

Confidential

Senior System Engineer

Responsibilities:

  • Designed and developed several complex database procedures, packages. Extensively used features like Cursors, autonomous transactions, distributed transactions, exception handling, Dynamic,pl/sqltables, bulk load methods, optimizer Hints, Cursor variables and returning of multi record set from procedures and functions
  • Created various SQL and PL/SQL scripts for verification of different functionalities.
  • PerformedSQLandPL/SQLtuning to improve the performance wif the help ofSQLTrace, Explain Plan, Indexing and Hints Created TRIGGERS to Audit the changes to data in main Tables.
  • Involve wif Business Analysts and Front-End (JAVA) users to develop the Application and fix the bugs.
  • Replaced time-consuming manual processes wif neat automated solutions.

Confidential

System Engineer

Responsibilities:

  • Responsible for Analysis, Design, Coding, Debugging and Deployment.
  • Experienced in troubleshooting traditional export/import and data pump export/import.
  • Worked on minimizing CPU overhead by TuningSQLStatements, Tuning Subprogram Invocation and Tuning computation-intensivePL/SQLCode
  • Involved in writing complexSQLQueries to implement the business requirements
  • Created UNIX shell scripts to automate manual processes.
  • Involved in writing complexSQLQueries to implement the business requirements
  • Worked on SQL*loader to load data into database.
  • Performed SQL and PL/SQL tuning and Application tuning.
  • Provided timely technical resolutions for defects for production environment.

Confidential, Greensboro, NC

System Engineer

Responsibilities:

  • Handling Mainframe Batch job abends and identtify delays in critical batch.
  • Perform analysis and investigation of logs, trends, alerts, notifications.
  • Well experienced in performing HMC activities such as activating/deactivating Lpar, TIME change, Standalone dumps, handling hardware messages.
  • Perform scheduled/unscheduled IPLs using HMC(Hardware management console).
  • Mainframe system maintenance activities.

Hire Now