We provide IT Staff Augmentation Services!

Senior Oracle Apps Dba Consultant Resume

5.00/5 (Submit Your Rating)

Dallas, TexaS

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.

We'd love your feedback!