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.