Description

Job Description

Expectations from Role

- Optimization of SQL query, Analyzing execution plans.

- Create and maintain database objects likes Tables, Index, Sequence etc.

- Monitoring Database using OEM. Tuning of Oracle objects.

- Experience in Performance Tuning at Database and Application level.

- Must have good troubleshooting skills.

- Understanding Automatic Workload Repository (AWR), Oracle hints, Active Session History (ASH) reports is a must.

- Strong knowledge of source control and release management tools.

- Stay updated with emerging technologies and recommend improvements to enhance system efficiency.

- Flexible to extend the work hours based on Project delivery need.

Roles & Responsibilities

Primary Skills

1. Oracle DBA, Real Application Cluster (RAC), Oracle Enterprise Monitor (OEM), Performance Tuning

2. RMAN Backup & Recovery

3. RAC, Data Guard, ASM, Security & Patching

4. GoldenGate, Exadata support 

Secondary Skills 

1. Shareplex, Database Migration & Upgrade 

2. Linux & Shell Scripting 

3. Monitoring Tools, Automation and Other Database hands-on (Postgres/Mongo)

Key Skills

Education

Any Graduate