Oracle (DBA)

Upgrading Oracle database from 12c to 19c version for Oracle EBS application 12.2.8

1. Troubleshooting and resolution of database and application issues encountered as part of the upgrade
2. Working with Oracle support to resolve issues and seek recommendation on best practices for upgrade
3. Extensive knowledge and experience in Oracle RAC, PCP and DMZ environments.
4. Collaborate with Application Functional testing and boundary application teams and work on issue resolution reported by teams
5. Develop upgrade runbook for database upgrade
6. Work towards reducing the upgrade downtime by streamlining and optimizing the upgrade process
7. Work with Infrastructure teams (Linux, storage teams) to plan and upgrade for infrastructure components e.g. OS, Grid upgrade
8. Environment planning for multiple upgrade test cycles
9. Working with Project Manager and other stakeholders to adhere to project timelines set for upgrade
10. Work on performance issues reported by testing teams, work on SQL tuning advisor, SQL profiling
11. Develop documents for system maintenance (Patching, cloning, service account password change)
12. Setup a Disaster recovery environment using Oracle dataguard and perform DR test

Experience

• 10+ Years of experience as Oracle Apps DBA and Oracle DBA
• Extensive experience working on 12c and 19c database versions
• Extensive experience working on Oracle EBS 12.2 version
• Flexibility to work in 24*7 model.
• Ability to learn new technologies and tools
• Good communication skills