SUMMARY

• 11+ years of experience in IT industry, as an Oracle Application DBA (EBS R 12.2/12.1/11 i) and core DBA supporting multi - Terabyte databases (12c/11g/10g/9i) on multiple environments.
• Proficient in installation of Oracle EBS R12.2 applications and Oracle RDBMS 12c/11g/10g database.
• Database upgrade from 10g (10.2.0.4) to 11g (11.2.0.2, 11.2.0.4) and application upgrade from 11i to R12.2.
• Proven experience in working with Oracle CRS, RAC, ASM, Data Guard.
• 8+ years of experience in Performance Tuning including Database, Concurrent Programs, Forms and Individual Sqls.
• A strong understanding of Best Practices in Applications and Database Management comprising Availability Management (viz., System Performance, Database and Applications availability), Release Management (viz., Cloning/Refresh), Change Management (viz., Patching, Code Migration) apart from regular Maintenance activities.
• Experience in creating & maintaining Standby databases (11g/10g).
• Platform migration of 11i application/10g database from HP-UX to Linux.
• Experience in Oracle Golden Gate installation, configuration and troubleshooting related issues.
• Experience in User & RMAN managed backup/disaster recovery/standby server recovery
• Experience in Patching (using adpatch, adop, opatch), Cloning (RMAN, Rapid Clone and Manual Clone) and trouble-shooting related issues.
• Experience in Administrating, Configuring, Troubleshooting Weblogic Server 11g, SOA 11g.
• Installation, upgrade and setup of OBIEE 11g/12c
• Installation and maintenance of the Oracle Enterprise Manager (OEM12c) and the plugins necessary for our environment.
• Excellent problem solving and troubleshooting skills.
• Shell scripting for monitoring database and application services.
• Performed RCA (Root Cause Analysis) for all the issues which involved high level escalations and prepared process documents on need basis.
• Proven ability to interact with end users, good team player and quick learner.
• Ability to work independently with little or no supervision

PROFESSIONAL EXPERIENCE

Confidential, Winston-Salem, NC

Sr. Oracle Apps DBA

Responsibilities:

• EBS Application Upgrade from 11i (11.5.10.2) to R12.2 (12.2.4) running on 3-node 11g(11.2.0.4) RAC database
• Cloning Oracle Application Instances (R12.2) to build Development, UAT, QA and project instances.
• Performance tuning on databases and related applications.
• SQL Tuning.
• Applying Oracle Application and database patches (patch analysis and application using adop)
• Creating and maintaining standby databases.
• Backup databases using RMAN and devise restore/recover strategies.
• Oracle Golden Gate to replicate tables between instances.
• Ensure smooth running & high availability of Oracle Production applications & databases including different ERP systems, BI and Demantra applications.
• SNOW (Service Now) Ticket solution for Oracle Application and database users
• Planning database and application outages for maintenance window.
• Implement new changes to monitoring scripts as per new requirements.
• Administer UNIX from a DBA perspective with respect to Linux.
• Table space and data file management, file system management.
• Shell scripting for cron jobs & some customization in already created scripts.
• Hand-shake calls with the off-shore team.

Confidential, Grafton, WI

Sr. Oracle Apps DBA

Responsibilities:

• Cloning Oracle Application Instances to build Development, UAT, QA and project instances.
• Installation and maintenance of the Oracle Enterprise Manager (OEM12c) and the plugins necessary for our environment.
• Database (11g (11.2.0.1 & 11.2.0.3) to 11g (11.2.0.4)) upgrade.
• License Analysis for Oracle Application User License.
• Ensure smooth running & high availability of Oracle Production applications & databases including different ERP systems, BI, Discoverer, Hyperion and Demantra applications.
• Applying Oracle Application and database patches (patch analysis and application using adpatch)
• JIRA Ticket solution for Oracle Application and database users
• STAT migration tool for version control.
• Performance tuning on databases and related applications.
• SQL Tuning.
• Planning database and application outages for maintenance window.
• Control-M tool for scheduling oracle concurrent jobs&cronjobs.
• Implement new changes to monitoring scripts as per new requirements.
• Patch analysis and schedule downtime for applying of patch
• Ensure DBA Support to all the ongoing & upcoming projects.
• Administer UNIX from a DBA perspective with respect to IBM-AIX.
• Shell scripting for cron jobs & some customization in already created scripts.

Confidential, Houston, TX

Sr. Oracle Apps DBA

Responsibilities:

• Cloning Oracle Application Instances to build Development, UAT and QA instances
• SSL implementation in oracle apps environments and other web-based applications (Apex).
• Apex upgrade from 3.2 to 4.1.
• Database (10g to 11g) and application (11.5.10.2 to R12.1.3) upgrade.
• Applying Oracle Application and database patches (patch analysis and application using adpatch)
• Table space and data file management, file system management.
• Planning database and application outages for maintenance window.
• Basic weblogic administration and SOA 11g and OBIEE installation and setup.
• Implement new changes to monitoring scripts as per new requirements.
• Patch analysis and schedule downtime for applying of patch
• Clone and Patch Oracle applications (ERP) 12.0.4/12.1.3 instances.
• Performance tuning in Oracle Applications instances and other production DBs
• Shell scripting for cron jobs & some customization in already created scripts.

Confidential

Sr. Oracle Apps DBA

Responsibilities:

• Cloning Oracle Application Instances to build Development, UAT and QA instances
• Applying Oracle Application and database patches (patch analysis and application using adpatch)
• Regular database backup activity
• Table space and data file management, file system management
• Planning database and application outages for maintenance window
• HEAT Ticket solution for Oracle Application and database users
• Implement new changes to monitoring scripts as per new requirements.
• Provide 24/7 support for multiple production instances
• Patch analysis and schedule downtime for patching window.
• Clone and Patch Oracle applications (ERP) 11.5.10.2 instances.
• Performance tuning in Oracle Applications instances and other production DBs
• Shell scripting for cron jobs & some customization in already created scripts.
• Maintained all documents of Oracle database operations. Prepared documentation of database backup and recovery standards

Confidential

Team Member/Lead (Sr. Oracle Apps DBA)

Responsibilities:

• Ensured high availability and performance for multiple production databases (24*7 production support)
• Cloning Oracle Application Instances to build Development, UAT and QA instances
• Applying Oracle Application and database patches (patch analysis and application using adpatch)
• Regular database backup activity
• Table space and data file management, file system management
• Planning database and application outages for maintenance window
• Remedy Ticket solution for Oracle Application and database users
• Implement new changes to monitoring scripts as per new requirements.
• Patch analysis and schedule downtime for applying of patch
• SSL implementation in oracle apps environments.
• Clone and Patch Oracle applications (EBS) 11.5.10.2/R12 instances.
• Performance tuning in Oracle Applications instances and other production DBs
• Shell scripting for cron jobs & some customization in already created scripts.
• Maintained all documents of Oracle database operations. Prepared documentation of database backup and recovery standards