Senior Oracle DBA - HA, DR & RAC Specialist

Tata Consultancy Services Limited; St. Louis (MO); On-site; USD 100,000 - 130,000; Full time

Benefits offered by this job

Discretionary annual incentive

Medical coverage

Dental & Vision

Disability insurance

401K plan

Certification & training reimbursement

Vacation & holidays

Commuter benefits

Legal & financial assistance

Pet insurance

Job summary

Tata Consultancy Services Limited is seeking an experienced Oracle DBA to install, configure, and maintain Oracle databases on Linux/Unix, with strong focus on backup, recovery, tuning, and high availability. The role includes on-call production support, security enforcement, and DR readiness across Data Guard and RAC environments.

The candidate will manage performance, patching, migrations, and change control in a fast-paced enterprise setting, partnering with application and infrastructure

Qualifications

• Install, configure, and maintain Oracle databases on Linux/Unix platforms.
• Perform database creation, configuration, cloning, and decommissioning.
• Manage tablespaces, datafiles, redo logs, control files, and storage growth.
• Perform routine maintenance activities such as space management and housekeeping.
• Design and implement backup and recovery strategies using RMAN.
• Perform database restores and recoveries (complete and point-in-time recovery).
• Test backup and recovery procedures regularly to ensure DR readiness.
• Handle archive log management and retention policies.
• Monitor database performance using AWR, ADDM, ASH, OEM.
• Identify and resolve performance issues related to CPU, memory, I/O, SQL.
• Tune SQL queries, indexing strategies, and optimizer statistics.
• Manage Oracle initialization parameters for optimal performance.
• Implement and support Oracle Data Guard (Physical/Logical Standby).
• Manage Oracle RAC environments for high availability.
• Perform planned and unplanned failover and switchover operations.
• Support DR drills and business continuity testing.
• Manage database users, roles, profiles, and privileges.
• Ensure database security standards and compliance requirements are met.
• Implement auditing, password policies, and access controls.
• Apply security patches and CPU updates.
• Perform Oracle patching, PSU/CPU upgrades, and version upgrades.
• Support database migrations across platforms or versions.
• Coordinate with application and infrastructure teams during releases.
• Follow change management and release processes.

Responsibilities

• Provide 24x7 on-call support for production databases.
• Troubleshoot database incidents and perform root cause analysis.
• Work with vendors and internal teams to resolve complex issues.
• Maintain SOPs, runbooks, and operational documentation.

Skills

Oracle DBA

RMAN

Data Guard

Oracle RAC

Performance Tuning

High Availability

Security & Compliance

Linux/Unix

On-call Support

SQL Tuning

Tools

RMAN

OEM

AWR/ADDM/ASH

Job description

Tata Consultancy Services Limited is seeking an experienced Oracle DBA to install, configure, and maintain Oracle databases on Linux/Unix, with strong focus on backup, recovery, tuning, and high availability. The role includes on-call production support, security enforcement, and DR readiness across Data Guard and RAC environments.

The candidate will manage performance, patching, migrations, and change control in a fast-paced enterprise setting, partnering with application and infrastructure