Job Summary
JD
Total Relevant experience of 10-12 years, Supporting Oracle EBS 12.2 Production env for mission critical business application
Upgrading Oracle database from 12c to 19c version for Oracle EBS application 12.2.8
Troubleshooting and resolution of database and application issues encountered as part of the upgrade
Working with Oracle support to resolve issues and seek recommendation on best practises for upgrade
Extensive knowledge and experience in Oracle RAC, PCP and DMZ environments.
Collaborate with Application Functional testing and boundary application teams and work on issue resolution reported by teams
Develop upgrade runbook for database upgrade
Work towards reducing the upgrade downtime by streamlining and optimizing the upgrade process
Work with Infrastructure teams (Linux, storage teams) to plan and upgrade for infrastructure components e.g. OS, Grid upgrade
Environment planning for multiple upgrade test cycles
Working with Project Manager and others stakeholders to adhere to project timelines set for upgrade
Work on performance issues reported by testing teams, work on SQL tuning advisor, SQL profiling
Develop documents for system maintenance (Patching, cloning, service account password change)
Setup a Disaster recovery environment using Oracle dataguard and perform DR test.
============
Key Responsibilities
2. To conduct comprehensive code reviews, establish and oversee quality assurance processes, performance optimization , implementation of best practices and coding standards to ensure successful delivery of complex projects.
3. To ensure process compliance in the assigned module| and participate in technical discussions/review as a technical consultant for feasibility study (technical alternatives, best packages, supporting architecture best practices, technical risks, breakdown into components, estimations).
4. To collaborate with stakeholders to define project scope, objectives, deliverables and accordingly prepare and submit status reports for minimizing exposure & closure of escalations.
Skill Requirements
SKILLS - Oracle Apps DBA Consultant
|
Skill |
Mandatory |
Proficiency Level (1-5) |
|
Oracle Apps DBA |
Yes |
4 |
|
Oracle Core DBA |
Yes |
4 |
|
Oracle Weblogic |
Yes |
4 |
|
Performance Tuning |
Yes |
4 |
|
Shell Scripting |
No |
3 |