SUMMARY

• Experienced IT professional with abundant experience in Oracle database products, Oracle PL/SQL, Unix Shell Scripting, Proc*C, administration, and ETL operations .
• Over 13 years of IT Experience of large teams and extensive industry experience as Oracle PL/SQL, Developer/DBA and Unix Shell Scripting, DB programming, administration, production support/Technical support and data warehousing using Oracle, Oracle Golden Gate, PL/SQL Pro C, and Shell scripting.
• Worked with Data Modeling tools like ERWIN, Oracle development tools like PL/SQL Developer and TOAD. Scripting Language like Unix Shell Scripting.
• Proficient in performance tuning using through execution plan, Hints, Bulk Binding, Pipelined Functions, Partitions, index etc.
• Having experience of UNIX Shell programming using KSH, AWK.
• Expertise System Analysis, Designing, Testing Development & Support of Oracle 9i, 10g & 11g in Production, Staging, Development environments.
• Oracle supplied utilities including: SQL Loader, external tables, and Oracle built in packages.
• Significant experience in Oracle Db administration
• Created database objects like tables, views, sequences, synonyms, indexes using Oracle tools like SQL*Plus, SQL Developer and Toad.
• Proficient in advance features of Oracle 11g for PL/SQL programming like Using Records and Collections, Bulk Bind, Ref. Cursors, Nested tables and Dynamic SQL.
• Over five years of experience in ETL process, Extraction, transformation and loading in data warehousing environment.
• Significant Hands on experience in Oracle ETL suite Golden Gate to enforce integrity, Transformation and for ETL jobs.
• Extensive experience in Analysis and Design of Database, Data Migration, Performance Tuning and Shell Scripting
• Having Experience in using Sqoop, HIVE and MySql for extract data and store it in Hadoop.
• Possess diverse experience in different domains such as Telecom, Manufacturing, Automotive, Insurance and Banking domains, Extensive experience in creating complex reports using PL/SQL.
• Green Belt Certified for Completing the Six Sigma Project and Presented with new Automation ideas and advanced topics like Elastic Search.
• Highly motivated, excellent team player, enthusiastic, strong initiative and quick learner of new technologies.
• Strong interpersonal and communication skills in dealing with customers and teams.

TECHNICAL SKILLS

DATABASES: Oracle 12c, Oracle 11g, Oracle 10g,Oracle 9i, Oracle 8i,Mysql

OPERATING SYSTEM: Unix, Linux, Windows

ETL TOOLS: Oracle Golden Gate - 11.2

DATA MODELLING TOOL: Erwin

SCRIPTING LANGUAGES: Unix Shell Scripting

PROGRAMMING LANGUAGES: C, Pro*C,Sql,PL/SQL,Python

TOOLS: Toad, Oracle SQL Developer, SQL loaderBIG DATA TOOLS: Hive,Pig,Sqoop,Flume

SCHEDULING TOOLS: Autosys, TWS

PROFESSIONAL EXPERIENCE

Confidential

Sr Oracle Developer and Production Support Analyst

Responsibilities:

• Design and Develop for procedures using the PL/SQL Procedures/functions for frequent issues.
• Running the PL/SQL extract process to pull the data from Database and share to Dataware house Team for Cognos Report.
• Monthly Jobs using PL/SQL procedure and extract the data from Mainframe and move the files to SharePoint for Finance Team.
• Involved in project planning and providing work estimates.
• To understand requirement, identify database changes and create/modify database objects as per requirement.
• Create /Modify Data Model as per requirement using ERWIN.
• Involved in data migration project. understand old data model and application and migrating data into new application, which involve creating new objects in oracle like table, views, stored procedures, function etc. .
• Involved in SIT and UAT and fixing the bugs.
• Responsible for best practice and data quality.
• Performance tuning of DB objects using execution plan, various hint, temporary tables etc.
• Responsible for L3 production support for supporting more than 20 applications.
• To prepare database deployment scripts and providing support during deployment.

Confidential

Development and Support

Responsibilities:

• Design and Develop the automate process to send Proactive alerts to the RTB Support Team for Long Running Queries/Tablespace Alerts/Blocked Session using the PL/SQL Procedures/functions.
• To create/Modify Oracle procedure, Function, Packages. Refcursors, Views etc.
• Used BULK BINDING,Hints, INDEXs etc. for performance improvement.
• Design and Develop the Application Health Check Monitoring for RTB Applications .
• Worked on the SQL Query tuning and Performance Monitoring of the RTB Application and provide the recommendations to the RTB Support Team.
• Working with DBA for Production Issue to Resolve the Issues.
• Developed Top 20 SQL Queries for Proactive Monitoring the Database and shared with Support Teams.

Confidential

Development and Support

Responsibilities:

• Design and Develop the automate process to gather statistics for Tables/Index/Partitions using the PL/SQL Procedures/functions.
• Using PL/SQL procedure created batch jobs for daily/weekly and monthly processing.
• Importing and exporting data through SQL loader and Catalog Data analysis
• Include best programming practices to avoid future performance issues.
• Worked on the SQL Query tuning and Performance Monitoring of the HCA queries which is time consuming and blocking the daily uploads of the incoming and outgoing files.
• Working with DBA for Production Issue to Resolve the Issues.

Confidential

ADBA (Application DBA) and Technical Support

Responsibilities:

• Design and Develop in writing and tuning Unix Shell scripts including Oracle tables, views, indexes, and complex PL/SQL objects including: procedures, packages functions, triggers, and also Connect Direct to transfer files between two networked systems.
• During Database Migration need to replicate the data from Source to Target Server so created Extract/Replicate/Pump Process using Oracle Golden Gate and Data Replicated. Responsible for DB administration
• Responsible for Developing the new PL/SQL Procedures/functions to convert Time zone Conversion to EST in all DB's.
• Automation for Monitoring Script Using Shell Script for the Table space and Checking the Object Valid or not in Production table and will give an alert/warning to all users.
• Setup Complete End to End Setup for ETL process in Production using