SUMMARY

• Have 25+ Years of Experience in IT Industry as Sr. Oracle Database Administrator and Oracle PL/SQL Developer providing support to Production as well as Development and Testing environments. Have intellectual knowledge for creating knowledge base by preparing and maintaining documentation during the project implementation phase and maintenance phase.
• Developing and Maintaining UNIX/Linux Shell, Perl, SQL, PL/SQL scripts for Linux/UNIX and Batch file for Windows.
• Creating and maintaining Triggers, Stored Procedures, Functions, and Packages using PL/SQL
• Performance Tuning for SQL Scripts using Explain Plan, TKPROF and by Indexing, Partitioning, Hints and Statistics.
• Good knowledge of the replication tool Oracle GoldenGate
• Data Migrations using Datapump and Custom Scripts for Extracting, Transforming and Loading data, using Shell/PERL Scripts, SQL Loader, External Tables and PL/SQL
• Developing Linux/UNIX shell scripts to automating the recurring database tasks.
• Creating CRONJOBs and Daemon Processes for Automation of Processes
• Using Oracle Utilities like sql*ldr, exp, imp, expdp, impdp
• Installing, Monitoring and Maintaining Oracle Databases 12c/11g and 9i under various flavors of UNIX/Linux (Oracle Enterprise Linux, RedHat Linux, Sun Solaris, HPUX) and Windows for development, test, production environments.
• Creating, Monitoring and Maintaining Tablespaces and Data Files.
• Installing, Monitoring and Maintaining MySQL 5.6 databases under RedHat Linux (RHEL 5) and Windows.
• Installing Monitoring and Maintaining PostgreSQL database under CentOS and RedHat Linux (RHEL 5).
• Designing, Implementing and maintaining Database Back Up and Recovery as well as Database Cloning Procedures.
• Cloning of Oracle Databases using RMAN and Cold Backups for creating Test environments.
• Upgrading Oracle Databases from 11gR1 to 11gR2 and from 11gR2 to 12c.
• Configuring and managing Standby Databases using Data Guard.
• Configuring, monitoring and managing Cold Backups.
• Performing backups and tested crash recoveries using conventional cold, hot & RMAN Backup.
• Oracle Database Administration activities such as

TECHNICAL SKILLS

• Oracle DBA - - Oracle 12c
• Oracle 11g
• HPUX, Linux
• Windows installation and scripting.
• MySQL 5.6
• PostgreSQL
• Oracle Apps/E-Business Suite - Release 12 Installation
• Patching and Upgrading
• Cloning
• Deployments and performance tuning.
• Oracle Partitioning
• Data Guard
• Database Security
• Oracle Enterprise Manager/DBA Studio.
• UNIX/Linux Shell scripting, SQL
• PL/SQL and Perlfor UNIX, Linux and Windows
• Database and SQL Query Optimization
• Requirements Analysis
• Preparing and Presenting Technical Information

PROFESSIONAL EXPERIENCE

Confidential, Sunnyvale, CA

Sr. Database Administrator

Responsibilities:

• Installed and upgraded Oracle 10g, 11gR1, 11gR2 and 12c databases on Linux and Windows Platforms.
• Handling medium to large database environments using Oracle Enterprise Manager (OEM) on daily basis observing the performance of the production database and constantly active regarding performance and space management issues and accordingly providing recommendations to make database healthy and running, Performance Tuning, and Workload Analysis Reports.
• Monitoring the databases including but not limited to Space Management, Performance Tuning, and Workload Analysis (AWR, ADDM)
• Involved in setting up disaster recovery sites using Data Guard technology. Configuring the Physical Standby data guard.
• Upgraded Databases from 11.1.0.2 to 11.2.0.3 by creating a new home of 11.2.0.3 and relinking the binaries.
• Configuration, Monitoring and Maintenance of Data Guard. .
• Cloning the 11gR1 and 11gR2 Databases.
• Installing, Configuring and Maintaining Oracle GoldenGate 11g.
• Installations and maintenance of In-house Oracle Applications R12.1.x in Single Node for Development and Test & Multi-node for Production.
• Developed and Maintaining Unix Shell, SQL and PL/SQL Scripts
• Trouble shooting, optimizing and tuning SQL and PL/SQL Scripts.
• Developing and Maintaining Custom User Schemas, Database Triggers, Procedures and Functions.
• Refreshing the test environments.
• Developed and Maintaining Shell Scripts to automate database operations and schedule jobs using CRONTAB and Daemon processes.
• Developed Scripts to Extract Data in comma separated values (csv) format from individual tables of Oracle Applications 11.5.4 to be used to set up for the Oracle Applications R12.1.x.
• Upgraded Oracle Applications R12.1.1 to R12.1.3 for Development, Test and Production Instances
• Cloning Oracle Applications R12.1.3 for Development and Testing
• Supporting Oracle Applications R12.1.3 Developers.
• Participated in preparing a prototype of open source Puppet Software

Confidential

Senior Oracle Database Engineer

Responsibilities:

• Configurations of Data Guard.
• Upgrading Databases from 9i to 10g, 10g to 11g
• Creating custom scripts to bulk load data in various application objects using UNIX/Linux Scripts, SQL, PL/SQL.
• Prepared the Functional and Technical Design Documents after reviewing the Business Requirement and Functional Design Documents. Preparing the Test Cases.
• Prepared Process Flow Diagrams using Microsoft Visio.
• Developed and maintained of Packages, containing Procedures and Functions, used for create, modify and convert quotes to contract using PL/SQL.
• Conducted Unit Tests and Integration Testing.
• Provided training for new versions to End Users
• Developed SQL Scripts for querying the Oracle Apps 11i’s tables for Contracts and Installed Base modules and querying and modifying the customized tables for the Quote Data
• Fine Tuned SQL Queries using Explain Plan, Hints for Cost Based Optimizer and adding new indexes.
• Prepared and executing packages for migrating code from Development to Test (for CRP and UAT) and Production instances using Kintana’s APPS Integrity tool.
• Production support for the Quote Conversion Errors for Customized Quoting Applications SCC and IQT.