Job Description

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

1. To be responsible for providing technical guidance to a team of developers, enhancing their technical capabilities and increasing productivity.
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

Other Requirements

null