SUMMARY

• Over 11 years of experience in an Oracle Applications DBA 11i,R12, Oracle Databases 10g,11g and Oracle Fusion middleware Products 11g.
• Proficient in installation of Oracle EBS R12.2 applications and Oracle RDBMS 11g,12c database
• 24*7 support for the oracle ebs applications and database customers.
• Responsibilities as an Applications Database Administrator have helped acquire 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. Possesses good analytical skills, high impact communication skills and is very efficient at customer interfacing.
• Shell scripting for monitoring database and application services.
• Extensive experience in Implementing and Administering Multi Node Oracle Applications E - Business Suite R12.2, R12 and 11i stack with RAC databases.
• Good Experience in Understanding Business Requirements and accordingly prepared Instance Strategy for the entire Program.
• Working on Oracle Database and Application performance tuning.
• Experience in Installing Multi-node E-Business Suite 12.2 releases for RAC and NON-RAC databases
• Experience in Installing 11gR2 Grid Infrastructure, RAC databases.
• Set up and Documented Standards and Policies for Database and E-business suite Upgrades
• Experience in Upgrading RAC databases and Grid Infrastructure.
• Install Oracle BIEE on RHEL and integrating with Oracle Database.
• Experience in Upgrading E-Business Suite releases 11.5.10.2 to R12.2
• Experience in Administrating, Configuring, Troubleshooting WebLogic Server 11g.
• Configure SSO and integrating with Oracle E-Business R12.2 .
• Implemented Parallel Concurrent Processing (PCP) with RAC databases for EBS 11.5.10.2 release.
• Cloning of 12.2, 12.1.3 and 11.5.10 application file system from production to non-prod environments..
• Patch analysis and management using adop, adpatch, Opatch.
• Performance monitoring and tuning Applications and Databases on timely basis.
• Good experience using OEM 11g for Database Performance Monitoring and Tuning.
• Good experience on troubleshooting & handling Severity issues on timely basis.
• Installation of Oracle Goldengate and integration with oracle rdbms database.
• Good knowledge on Oracle Fusion middleware components OAM.
• Provide on call support for all enterprise wide oracle databases for daily database activities.
• Performed RCA (Root Cause Analysis) for all the issues which involved high level escalations and prepared process documents on need basis.
• Performed Production assessment and created a detailed business process document for the customer GO-LIVE.
• Provided technical support to development team for database issues.

TECHNICAL SKILLS

ERP: Oracle EBS R12.2, R12.1.3 and 11.5.10.2

RDBMS: Oracle 11g, 10g, 12c.

FMW: Weblogic Server, OAM, SOA and OBIEE.

Operating Systems: Red Hat Enterprise Linux, Oracle Enterprise Linux, Solaris, AIX, HP, Windows.

Cloud Technologies: Amazon EC2.

Tools: Putty, WinSCP, Plsql Developer, TOAD, VNC Server, VMWare.

PROFESSIONAL EXPERIENCE

Confidential, Winston-Salem, NC

Sr Oracle Applications DBA

Responsibilities:

• Multi-Node Oracle E-Business Suite 12.2 release on Red Hat Enterprise Linux.
• Applying ADOP patching on multimode oracle ebs R12.2 environments.
• Upgrading oracle EBS applications from 11.5.10.2 to R12.2.4.
• Performed Complete Server Validation which includes validating OS, File Systems and Network.
• Setup and Install 11gR2 Grid Infrastructure for RAC databases
• Upgraded Oracle RDBMS database from 11.2.0.3 to 11.2.0.4
• Cloning of 12.2 application file system from multi-node to multi-node.
• Patch Management using ADOP, OPATCH utilities for Oracle E-Business Suite releases
• Supporting for Oracle Fusion MiddleWare WebLogic Server, SOA Components.
• Develop, Maintain, Perform and test Backup and Recovery Procedures
• Performance monitoring and tuning Applications and Databases on timely basis.
• Monitored the databases for optimal performance. Recommended improvements to enhance overall performance.
• Conducted Performance testing and Stress testing for EBS system for successful Go-live
• Installation and management of Weblogic server, SOA and OBIEE.
• Supporting with functional and development team for code migration from development enveronments to production.
• Working on Oracle EBS sysadmin activities.
• Installation and configuration of Oracle EBS R12.2 and Oracle database 11g and 10g on Amazon AWS servers.
• Provide on call support for daily database activities.
• Troubleshooting long running Oracle EBS concurrent programs.
• Proactive monitoring oracle applications performance.
• Installing and Configuration of RHEL and Operating System administration activities.
• Was involved in Business Process calls with Service Delivery Management on daily basis.
• Performed RCA (Root Cause Analysis) for all the issues which involved high level escalations and prepared process documents on need basis.
• Performed Production assessment and created a detailed business process document for the customer GO-LIVE.

Environment: Oracle EBS R12.2, 11.5.10.2, RDBMS 11gR2, Linux, Solaris, Amazon EC2, FMW

Confidential, CA

Sr Oracle Applications DBA

Responsibilities:

• Installed Multi-Node E-Business Suite 12.2 release on Red Hat Enterprise Linux.
• Worked on Instance Strategy, Candidate Architecture and detailed Architecture with Release Management teams and technology delivery.
• Provided leadership on technical business applications, project teams, complex project management issues and technical challenges for Oracle Application Release 12.2, and upgrades, setups and configuration.
• Performed Complete Server Validation which includes validating OS, File Systems and Network.
• Setup and Install 11gR2 Grid Infrastructure for RAC databases
• Upgraded Oracle RDBMS database from 11.2.0.3 to 11.2.0.4
• Upgraded E-Business Suite from 12.2.0 to 12.2.4.
• Cloning of 12.2 application file system from multi-node to multi-node.
• Patch Management using ADOP, OPATCH utilities for Oracle E-Business Suite releases
• Installed and Configured 11g Discoverer and WebLogic Products.
• Develop, Maintain, Perform and test Backup and Recovery Procedures
• Performance monitoring and tuning Applications and Databases on timely basis.
• Monitored the databases for optimal performance. Recommended improvements to enhance overall performance.
• Conducted Performance testing and Stress testing for EBS system for successful Go-live
• Installation and management of Weblogic server, SOA and OBIEE.
• Work with other IT departments to make sure that data and systems are available and perform activities within SLA.
• Oracle EBS sysadmin activities.
• Installation and configuration of Oracle EBS R12.2 and Oracle database 11g and 10g on Amazon AWS servers.
• Provide on call support for daily database activities.
• Installing and Configuration of RHEL and Operating System administration activities.
• Was involved in Business Process calls with Service Delivery Management on daily basis.
• Performed RCA (Root Cause Analysis) for all the issues which involved high level escalations and prepared process documents on need basis.
• Performed Production assessment and created a detailed business process document for the customer GO-LIVE.
• Mentored new team members, providing trainings on the process flow and at Technology aspects.

Environment: Oracle EBS R12.2, 11.5.10.2, RDBMS 11gR2, Linux, Solaris, Amazon EC2, FMW

Confidential

Oracle Applications DBA

Responsibilities:

• Oracle applications 11.5.10.2, R12.2, FMW installations, Cloning, Patching, Monitoring, and Troubleshooting.
• Cloning the production instance to development instance using Rapid clone utility and manual cloning.
• Documenting and applying Oracle application patches using adop, adpatch on single node, multi node environments.
• Monitoring Concurrent requests and troubleshooting.
• Service Request management and working with Support for issue resolution.
• Upgrading Oracle EBS applications from 11.5.10.2 to R12.2.4 on Solaris Operating System.
• Upgrading Applications from 11.5.9 to 11.5.10.
• Refreshing Applications Database.
• Installation, configuration, cloning & administration of Oracle RDBMS 10g, 11gr2 and RAC environment on Linux, Solaris and Windows platforms.
• Proficiency in DBA tools like Export & Import Utilities, OEM, DBCA and DBUA.
• Tablespace Management, Managing Invalid objects. Reorganization of tablespaces.
• Disk space checking, Archive logs and their spaces for routine administration. Alert log and trace monitor.
• Managing hot & cold backups of databases using custom shell scripts.
• Apply patches using opatch tool for RDBMS Oracle Home.
• Configuring SSO with Oracle E-Business Suite.
• Applying Developer6i patches for 806 Oracle Home and IAS patches for IAS Oracle Home.
• DB Refresh through export and import utility.
• Autoconfig customizations for EBS application node.

Environment: EBS R12.2, 11.5.10.2, RDBMS 11gR2, HP Unix, SOA and Discoverer.

Confidential

Oracle Applications DBA

Responsibilities:

• Cloning the production instance to development instance using Rapid clone utility and manual cloning.
• Documenting and applying Oracle application patches using adpatch on single node, multi node environments.
• Service Request management and working with Support for issue resolution.
• Refreshing Applications Database.
• Tablespace Management, Managing Invalid objects. Reorganization of tablespaces.
• Disk space checking, Archive logs and their spaces for routine administration. Alert log and trace monitor.
• Managing hot & cold backups of databases using custom shell scripts.
• Apply patches using opatch tool for Oracle Home.
• Configuring SSO with Oracle E-Business Suite.
• Applying Developer6i patches for 806 Oracle Home and IAS patches for IAS Oracle Home.
• Autoconfig customizations for EBS application node.
• Creating Application users and assigning responsibilities.

Environment: EBS 11.5.10.2 with 10GR2 RAC & NON - RAC

Confidential

Oracle Applications DBA

Responsibilities:

• Oracle Database 10g, Cloning, Patching, Monitoring, and Troubleshooting.
• Cloning the production instance to development instance using Rapid clone utility and manual cloning.
• Documenting and applying Oracle patches using OPatch on single node, multi node environments.
• Service Request management and working with Support for issue resolution.
• Upgrading Oracle database to 10g using dbua utility on Linux operating systems.
• Refreshing Applications Database using cold backup.
• Installation, configuration, cloning & administration of Oracle RDBMS 10g, 11gR2 and RAC environment on Linux, Solaris and Windows platforms.
• Proficiency in DBA tools like Export & Import Utilities, OEM, DBCA and DBUA.
• Tablespace Management, Managing Invalid objects. Reorganization of tablespaces.
• Disk space checking, Archive logs and their spaces for routine administration. Alert log and trace monitor.
• Managing hot & cold backups of databases using custom shell scripts.
• Apply patches using opatch tool for Oracle Home.
• Configuring SSO with Oracle E-Business Suite.
• Applying Developer6i patches for 806 Oracle Home and IAS patches for IAS Oracle Home.
• DB Refresh through export and import utility.
• Autoconfig customizations for EBS application node.
• Creating Application users and assigning responsibilities.

Environment: Oracle 10gR2 RAC & NON - RAC

Confidential

Oracle Applications DBA

Responsibilities:

• 24/7 Sys Admin Activities and Support
• Applying Tech Stack patches and RDBMS patches.
• Performing Pre Patch Analysis for all the patches that need to be applied.
• Changed the Profile options in Site/Responsibility/Application/User Level.
• Creating and assigning appropriate roles and privileges to users depending on the user activity.
• Granting and Revoking Privileges/Roles from Users.
• Changed the configuration Parameters as per the Customer requirement and Bouncing Applications /Database if need.
• Installing required rpms for server configuration.
• Making certain changes in files related to discoverer server.
• Application user creation / responsibilities assignment
• Customization Updates and working on Code promotions
• Administering concurrent managers
• Managing Forms, Report Servers and Web Servers
• Regular system health checkups
• Monitoring alert log and trace files.
• Monitoring Alerts and table space growth proactively.
• Performing regular backups.
• User access control and administration.

Environment: EBS 11i with 9i/10GR2 NON - RAC & RAC

Confidential

Oracle Applications DBA

Responsibilities:

• Disk space checking, Archive logs and their spaces for routine administration. Alert log and trace monitor.
• Applied the application and database patches in testing, quality and production servers.
• Maintained daily hot backup and weekend cold backups.
• Cloned from production to test servers for testing the compounds by development team.
• Supported the service requests raised by the users.
• Created the database and application users and assigning the roles and responsibilities.
• Managed the archive files and database files.
• Tablespace Management, Managing Invalid objects. Reorganization of tablespaces.
• Refreshed Applications Database every weekend from production to development.

Environment: Oracle EBS 11.5.9, Oracle 9i/10gR2 NON - RAC & RAC