Oracle Apps DB Administrator

Desired Competencies (Technical/Behavioral Competency)

Must-Have**

(Ideally should not be

more than 3-5) Proficient in RMAN backup recovery, performance tuning, data guard, upgrade, Patching, cloning, data pump, sql loader, flashback, ASM and RAC.

Good-to-Have Oracle Enterprise Manager, Golden Gate

SN Responsibility of / Expectations from the Role

1 Overview of Database Administraton , Installation, Creation of DB, Patching DB,

2 Creating DB cluster and Proficient in RMAN backup recovery, user management, performance tuning, data guard, upgrade, Patching, cloning, data pump, sql loader, flashback, ASM and RAC

3 Experience in ADUTILITES and Autoconfig utility. Performing Oracle Applications Utilities like AD Administration, AD Controller, Auto Config, AD Relink and Auto Patch, f60gen and managed passwords by using FNDCPASS. Generating AWR, ADDM, report for the better performance.

4 Up-gradation of database from Oracle 11g to 12c with RAC and EBS 12.2 version

5 Monitoring of all the production databases and doing all the DBA housekeeping activities like monitoring the load, free space check, disk space, CPU utilization check, alert log and listener log check, monitoring database connections etc

6 Working knowledge in “Oracle Enterprise Manager”and Troubleshooting expertise for all tiers (Apache, Forms, Concurrent, Admin, J-initiator and database).

7 Monitoring the services of Applications Components like Apache, forms, reports etc. Supporting development teams, general troubleshooting & support in administration of Product & Test instances.

8 Incident and Request Management , Project activity - 24*7 support