Staff is supposed to participate in management, prioritization, minor enhancements / fix activities, problem management, stability analysis, etc. L3 is supposed to be proactive in nature thus identifying problems in advance and looking for continuous service improvements.

• Design and Implementation

• Advanced configuration and Troubleshooting

• Analysis of technical issues and permanent fix/solution

• Implementation of RAC

• Implementation of ASM

• Good knowledge/Hands on in Oracle Golden Gate, Shareplex and HVR replication

• Implementation of Data Guard for database failover between Data center and DR site, perform switchover /failover activities.

• Desired experience includes a working knowledge of Oracle Backup/Recovery (RMAN) and Linux/Windows, RAC, GRID, Dataguard and Oracle Performance Tuning

• Troubleshooting of cluster failures, ASM disk group’s failures and DR related problem etc.

• Adding and resizing of ASM disk groups.

• Work on issues that couldn’t be resolved by L2 team.

• Formulating Backup and Recovery strategies.

• Database upgrades/migrations.

• Install and configure Oracle enterprise manager Grid control.

• Formulating Backup and Recovery strategies

• Physical and Logical database designing

• Design for CPU, memory, and storage capacity requirements.

• Design security policy and audit plan.

• Database recoveries and identifying and fixing database corruption.

• Designing database for High Availability

• Designing a Strategy to Maintain and Manage Databases

• Work on the performance issues related to Clustering, create logical diagrams to figure out the loop pools in the database designs and functionality.

• SQL tuning and optimization

• Administering Basic and Advanced replication

• Administer a VLDB

• Transport data across platforms.

• DB-Related Software Evaluation

• Administer 3rd Party DBA Tools

• Facilitate Training/Education

• Willingness to work in 24X7 projects (Shifts)