Job description

Oracle DBA Expectations from Role o Optimization of SQL query, Analyzing execution plans. o Create and maintain database objects likes Tables, Index, Sequence etc. o Monitoring Database using OEM. Tuning of Oracle objects. o Experience in Performance Tuning at Database and Application level. o Must have good troubleshooting skills. o Understanding Automatic Workload Repository (AWR), Oracle hints, Active Session History (ASH) reports is a must. o Strong knowledge of source control and release management tools. o Stay updated with emerging technologies and recommend improvements to enhance system efficiency. o Flexible to extend the work hours based on Project delivery need. Primary Skills o Oracle DBA, Real Application Cluster (RAC), Oracle Enterprise Monitor (OEM), Performance Tuning o RMAN Backup & Recovery o RAC, Data Guard, ASM, Security & Patching o GoldenGate, Exadata support Secondary Skills o Shareplex, Database Migration & Upgrade o Linux & Shell Scripting o Monitoring Tools, Automation and Other Database hands-on (Postgres/Mongo). Salary Range- $95,000-$110,000 a year #LI-SP3 #LI-VX1

Requirements

Must-haves

Expectations from Role
o Optimization of SQL query, Analyzing execution plans.
o Create and maintain database objects likes Tables, Index, Sequence etc.
o Monitoring Database using OEM. Tuning of Oracle objects.
o Experience in Performance Tuning at Database and Application level.
o Must have good troubleshooting skills.
o Understanding Automatic Workload Repository (AWR), Oracle hints, Active Session History (ASH) reports is a must.
o Strong knowledge of source control and release management tools.
o Stay updated with emerging technologies and recommend improvements to enhance system efficiency.
o Flexible to extend the work hours based on Project delivery need.
Primary Skills
o Oracle DBA, Real Application Cluster (RAC), Oracle Enterprise Monitor (OEM), Performance Tuning
o RMAN Backup & Recovery
o RAC, Data Guard, ASM, Security & Patching
o GoldenGate, Exadata support
Secondary Skills
o Shareplex, Database Migration & Upgrade
o Linux & Shell Scripting
o Monitoring Tools, Automation and Other Database hands-on (Postgres/Mongo).

Nice-to-haves

None flagged.

Application prep

Use the role’s language and application details while tailoring your materials.

Keywords to mirror

sqlpostgres

Platform: careers-page
Effort: medium