Oracle DBA

Tata Consultancy Services; New York (NY); On-site; USD 95,000 - 110,000; Full time

Job summary

Tata Consultancy Services in New York, NY seeks an Oracle DBA to optimize SQL, analyze execution plans, and manage database objects including tables, indexes, and sequences. You will monitor performance with OEM, tune Oracle objects, and work across database and application layers.

Strong troubleshooting, AWR/ASH proficiency, and release-management know-how are essential. Experience with RAC, Data Guard, ASM, GoldenGate, and Linux shell scripting is highly valued.

Qualifications

• Optimization of SQL queries and analyzing execution plans.
• Create and maintain database objects like tables, indexes, sequences.
• Monitoring database using OEM and tuning Oracle objects.
• Experience in performance tuning at database and application level.
• Must have good troubleshooting skills.
• Understanding AWR, Oracle hints, ASH reports is a must.
• Strong knowledge of source control and release management tools.
• Stay updated with emerging technologies and recommend improvements for system efficiency.

Responsibilities

• Optimization of SQL query, Analyzing execution plans.
• Create and maintain database objects like 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.

Skills

Oracle DBA

RAC

OEM

Performance Tuning

RMAN Backup & Recovery

Tools

RMAN

Data Guard

ASM

GoldenGate

Job description

• 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.

Job Description

Oracle DBA

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.

Primary Skills

• Oracle DBA, Real Application Cluster (RAC), Oracle Enterprise Monitor (OEM), Performance Tuning
• RMAN Backup & Recovery
• RAC, Data Guard, ASM, Security & Patching
• GoldenGate, Exadata support

Secondary Skills

• Shareplex, Database Migration & Upgrade
• Linux & Shell Scripting
• Monitoring Tools, Automation and Other Database hands-on (Postgres/Mongo).

Salary Range- $95,000-$110,000 a year