SUMMARY

• IT Professional with over 12 years+ of experience as an ‘ORACLE APPS DBA’ on different versions and platforms.
• EBS Instance upgrade from 11.5.10.2 to 12.0.4, 11.5.10.2 to R12.1.3 & R12.1.3 to R12.2.6
• Database upgrades from 9i to 10g, 10g to 11.2.0.4 & 11.2.0.3 to 11.2.0.4.
• Experience in Migration of On - Premises Oracle Application R12.2.4 to AWS.
• Experience in Migration of On-Premises R12.2.4 to OCI.
• Experience in working on EBS Cloud Manager and OCI console.
• Experience in administration of OCI database and EBS.
• Database installation and migration on Oracle Cloud Infrastructure.
• Expert in Application and Database Cloning using Rapid Clone Utility and troubleshooting post clone issues.
• Experience and proficient in using AD utilities. (adop, adpatch, admrgpch, adctrl, AutoConfig, adadmin, adident, adrelink etc) and applied Database Patches using Opatch utility.
• Proficient in Oracle Database Administration including backup, recovery, installation, patch application, RMAN configuration etc.
• Good hands-on experience in Oracle Applications (EBS) Installation & Troubleshooting.
• Experience in 12C OEM.
• Experience in supporting, managing and troubleshooting ASM, Data Guard and RAC.
• Experience in supporting and managing multiple Production, Test and Development instances.
• Experience in supporting, managing and troubleshooting OBIEE environment, Informatics services and DAC services.
• Responsible to drive DB outages from onshore and communicate the client on the progress.
• Responsible to keep the incident management tickets under control and ensure RCA is done for aging tickets.
• Conduct meetings for problem management and identify regularly occurring issues
• Part of steering committee meeting from on-shore and coordinating with the offshore team.
• Comfortable working in co-ordination with Application Developers, System Administrators or other team members and superiors.
• Creation of Clone databases through COLD, HOT, and RMAN backups.
• Monitoring Oracle EBS servers Login issues, balancing load, health check of DB in case of performance issues and resolving them.
• Applying Hot Patches, Cold Patches and reducing patch downtime for Oracle Applications.
• Expertise in Database Backup strategies & recovery scenarios.
• Oracle Discoverer Installation, Upgradation and Configuration.
• Good knowledge on Golden Gate, RAC, Data Guard and ASM.
• Fusion Middleware and WebLogic Installation, Upgradation and Support.
• Good knowledge on OAM, OID & OUD.
• Troubleshooting knowledge on Self-service web application issues, Form server issues
• Installation and Configuration of Oracle Enterprise Manager (OEM) 13c.
• Development Unix Shell Scripts for automating DBA tasks and scheduling in Cron jobs.
• Reorganized the tables and rebuild indexes to improve space utilization.
• Participate in a team to maintain & support for multiple oracle databases in high availability (24 X 7) heterogeneous environment.
• Preparation and maintenance of day to day documentation.
• Excellent analytical problem solving, oral and written skills.
• Experience in configuring the Printer Installation in EBS 11i/R12.
• Experience in configuring the Work flow notification Mailer.
• Perform root cause analysis of difficult problems and their solutions.
• Generating Stats pack report, AWR Report whenever required.
• Single point of contact for the client for any type of communication.
• Proactively interacting with the Oracle Product support and performing the OWC.
• ITIL Certified, AWS Certified Solutions Architect - Associate.

TECHNICAL SKILLS

Cloud Computing: Oracle Cloud Computing (OCI), Amazon Web Services (AWS)

ERP: Oracle Apps Release 12.2.6, 12.2.4, 12.1.3, 12.0.4, 11.5.10.2, 11.5.9.

RDBMS: Oracle 12c, Oracle 11g, Oracle 10g, Oracle 9.x/8.x, Golden Gate, Data Guard, ASM, RAC

Middleware: Oracle Fusion Middleware (OID, OUD, OAM), Oracle WebLogic Server, OBIEE, SSO, Demantra, Discoverer.

Operating Systems: HP-UX 11.11, Sun Solaris 11, Red hat Linux, IBM AIX, Windows server 2003.

PROFESSIONAL EXPERIENCE

Confidential, Dallas, Texas

Senior Oracle Apps DBA Consultant

Responsibilities:

• Planning and implementing migration of On-premise to OCI cloud.
• Prepared documentation for the migration.
• Pre migration and post migration validation checks.
• Performing risk analysis on the Patching.
• Taking care of the performance issues.
• Applying Application patches and FMW patches.
• Cloning the Development instances from the PROD instance.
• Working closely with the development teams and addressing their issues.
• Migration activities like code migration and discoverer migrations.
• Discover admin activities.
• Troubleshooting the issues and performing the root cause analysis.
• Maintaining documentations of critical activities.
• Installation of the Oracle applications, WebLogic and configurations.
• Troubleshooting the concurrent managers issues.
• Housekeeping activities.
• Decrease the occurrence of Repetitive Alerts.
• Responsible for providing backend support for the development, testing and UAT environments for Oracle ERP as well as other production databases and new projects.
• Manage the deployments for Coding, Cloning, Refreshing, Patching, Backups, Purges, etc.
• System administrator tasks.

Confidential, Dallas, Texas

Senior Oracle Apps DBA Consultant

Responsibilities:

• Prepared Operating system Migration document from Solaris 10.3 to Solaris 11.4 version.
• Migrated R12.2.4 from Solaris 10.3 to Solaris 11.4 onto the new hardware.
• Handling of post migration issues.
• Working closely with the development teams and addressing their issues.
• Configuring printers on the new EBS servers.
• Pointing Discover and Demantra from the upgraded OS version EBS.
• Performing Non-Prod clones from the PROD instance for the migration.
• Attending the Steering committee meeting regularly.
• Performed root cause analysis and documenting the issues.
• Coordinating with the other teams like Unix, Infra and Developers.
• Providing day to day updates and status with the Project Manager.
• Setting up the scheduled jobs in the Cron tab.
• Configuring OEM with the migrated instance.
• Applied patches.

Confidential

Senior Oracle Apps DBA

Responsibilities:

• Technically leading the upgrade and migration projects from signoff till go-live.
• Taking care of the OBIEE admin activities
• Working closely with delivery teams, Implement standard best practices in target accounts to deliver consistent service delivery and exceptional customer satisfaction
• Implementing standard governance, reporting and escalation processes across responsible accounts
• Operations optimization - processes driven, standardize and simplify approach.
• Adopting latest infrastructure and innovative techniques for significant reduction of iteration timings by the end of every project go-live.
• Define scope, timelines with work breakdown structure and resources associated
• Project risk, issues and mitigation plans - failure mode and effect analysis and risk tracker
• Reporting and business approvals to address critical issues in customer relationship & governance meets
• Define communication, escalation and operational metrics
• Result driven time to time working group meetings for gauging potential slippages in scope & time
• Automation techniques for reducing the migration timelines and reducing duplicity / human error quotient significantly directly impacting Quality of Service.
• Expert in technical issue resolution in all the areas of DB and EBS including integrations and configurations.
• Planned and Performed Migration of EBS R12 from on-premise to AWS Cloud.
• Planned and Performed upgrades EBS R121.3 to R12.2
• Performed EBS 11i upgrades i.e. from 11.5.10.2 to 12.1.1 and 12.1.3.
• Performed Oracle Database upgrades and OS Platform Migrations
• Oracle Demantra Installation, Upgradation and Configuration
• Oracle OEM 13c Installation and Configuration
• Interacting with Delivery managers for the deliverables and planning timelines of the projects
• Worked on Performance issues after upgrades.
• Implementation of Data Guard.
• Oracle Fusion Middleware and WebLogic Server
• Security Hardening of EBS systems and Database.