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)