EXPERIENCE SUMMARY:

• 10+ years of experience as Oracle Apps DBA & Oracle Core DBA.
• Experience on Oracle Applications (EBS) 11i, R12, R12.2.4 through managing and maintaining large and medium sized production and non - production relational databases.
• Implementations and support experience on DMZ, Shared APPL TOP and Hardware Load Balancer Configurations
• Good experience in Oracle E-Business Suite Upgrades and Installations on Multinode environments and Oracle Database Upgrades. Upgraded E-Business suite from R12.1.3 and R12.1.2 to R12.2.4.
• Worked on installing and implementing Single Sign On using OAM wif EBS Releases (R12.2.4, R12.1.3, 11.5.10.2).
• Experience on configuring Zero Sign on using WNA wif OAM for EBS Releases (R12.2.4, R12.1.3, 11.5.10.2).
• Extensively worked on issue related to user connecting to EBS through OAM.
• Experience in handling the internal issues related to OAM.
• Installed and configured 12c/13c Oracle Enterprise Manager to monitor Databases, E-Biz Suite components.
• Worked on installing and implementing Application Change Management Pack on OEM13c for applying adpatches and migrating custom codes through custom patches
• Oracle Implementation and support for 9i,10g,11g databases
• Responsibilities include all Database Administration related activities, OAM Autantication, Installation, Rapid Install, Configuration, Design, Troubleshooting, Performance Tuning, Replication, Auditing, Patching, Workflow Configuration, Cloning, Backup & Recovery, Recovery Manager (RMAN), Export-Import, Migration, Upgradation, Security and Stand By database setup and administration, Imparting Training to customers etc.
• Experience of working in 24*7 environments for supporting Oracle Apps, Core Db and other applications.
• Extensively worked on Maintenance of Oracle E-Business suite applications using Oracle AD utilities/tools, patching, cloning, backup, administering concurrent manager, sysadmin responsibilities, troubleshooting database and EBS application related issues.
• Capacity planning, storage analysis, monitoring, best practices for database and oracle EBS environments.
• Good experience wif project management activities including project planning, scheduling, phasing, coordinating, presentations and workshop sessions.
• Experience of working in 24x7 Production and 16x5 Development environments and on call support for mission critical databases and Oracle EBS Applications.
• Successfully performed numerous Cloning procedures from Prod to Developments, Quarterly Security patching, troubleshooting and improved database performances to exceed client’s expectations. Thus improved overall client’s systems uptime and productivity to become most efficient.

TECHNICAL SKILLS

ERP Products: Oracle E-Business Suite 11.5.10CU2,R12.1.3, and R12.2.4, Epicor

RDBMS: Oracle 9i/10g/11gR2/12cSecurity Products/IDAM Products

Directory technologies: Oracle Internet Directory 11g, Active Directory 2003&2008

Application servers: Weblogic 10.3.5/10.3.6, Oracle 10g iAS

Languages: SQL

Operating Systems: IBM AIX 6.1/7.1, HP-UXB.11.23, Sun Solaris, RHEL 6.1/7.1 SUSIE

Misc: SVN, ServiceNow and Remedy

PROFESSIONAL EXPERIENCE

Senior Apps DBA Consultant

Confidential, Malvern PA

Responsibilities

• R12.2.4 Applications maintenance using ADOP.
• Applications & Database Patching.
• Installed R12.2.4 vision instance. Configuration of Oracle Applications
• Oracle 11i Applications maintenance using AD Utilities. R12 Applications maintenance using AD Utilities. Applications & Database Patching.
• Working on installing fusion middleware products.
• Working on single-sign-on issues.
• Handling technical issues being faced by Oracle Apps development team.
• Concurrent processing server monitoring, troubleshooting and tuning.

Senior Apps DBA Consultant

Confidential

Responsibilities

• Upgrade & Implementation of Oracle Applications
• Worked on upgrading OEM12c to OEM13c.
• Worked on installing OAM and integrating it wif EBS R12.
• Worked on EBS zero sign on using WNA.
• Worked on installing custom code using ACMP on OEM.
• Installed R12.2.4 vision instance. Configuration of Oracle Applications
• Oracle 11i Applications maintenance using AD Utilities. R12 Applications maintenance using AD Utilities. Applications & Database Patching. Database and Application Migration.
• Java upgradation to JRE 7u45 on desktops.
• Upgrade EBS DB to 11.2.0.4 from 11.2.0.3.
• Handling technical issues being faced by Oracle Apps development team.
• Configure database & applications parameters. Apps back-end database administration.
• Oracle 10g administration/performance tuning using OEM DB console.
• Managing high availability of production systems.
• Apache server, Forms server & Reports server monitoring and troubleshooting.
• Concurrent processing server monitoring, troubleshooting and tuning.
• Opening SR and its follow-up. Hot backup and Cold Backup and recovery management.
• Export / Import at all levels. Cloning of Oracle Applications
• Adding new languages to Oracle Application instances.
• Researching & analysing of Oracle Application patches

Oracle Apps DBA

Confidential

Responsibilities

• Oracle 11i Applications maintenance using AD Utilities.
• Applications & Database Patching.
• Handling technical issues being faced by Oracle Apps development team.
• Configure database & applications parameters.
• Migrating DB and Apps Hosts to new hosts.
• Apache server, Forms server & Reports server monitoring and troubleshooting.
• Concurrent processing server monitoring, troubleshooting and tuning.
• Hot backup and Cold Backup and recovery management.
• Cloning of Oracle Applications.
• Researching & analysing of Oracle Application patches
• Merging and applying Oracle Application patches
• Backup/recovery & maintenance of Oracle databases

Oracle Apps DBA

Confidential

Responsibilities

• Upgradation of Oracle Apps RAC database from 10.2.0.5 to 11.2.0.3
• Upgradation of Oracle RAC database from 10.2.0.5 to 11.2.0.3
• Installation of Oracle 11.2.0.3 RAC database
• Providing R12 Support.
• Cloning of Oracle Apps Instance
• Space Management through ASM
• Supporting the Oracle Apps Prod and other instances
• Administering Oracle databases
• Providing on-call support(24x7)
• Oracle R12 Applications maintenance using AD Utilities.
• Applications & Database Patching.
• Database and Application Migration.
• Archiving Oracle data

Eaton Electrical DBA Support

Confidential

Responsibilities

• Upgrade, implementation and Configuration of Oracle Applications
• Oracle 11i Applications maintenance using AD Utilities.
• Applications & Database Patching. Database and Application Migration.
• Handling technical issues being faced by Oracle Apps development team.
• Configure database & applications parameters. Apps back-end database administration.
• Oracle 10g administration/performance tuning using OEM DB console
• Managing high availability of production systems.
• Apache server, Forms server & Reports server monitoring and troubleshooting.
• Concurrent processing server monitoring, troubleshooting and tuning.
• Opening SR and its follow-up. Hot backup and Cold Backup and recovery management.
• Export / Import at all levels. Adding new languages to Oracle Application instances. Cloning of Oracle Applications. Researching & analysing of Oracle Application patches