Senior Oracle Dba

Tata Consultancy Services; 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

• Install, configure, and maintain Oracle databases (11g / 12c / 19c) 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

Backup & Recovery

• 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

Performance Monitoring & Tuning

• 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

High Availability & Disaster Recovery

• 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

Security & Compliance

• 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

Production Support

• 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 documentat ion

Salary Range: $100,000 - $130,000 a year

TCS Employee Benefits Summary:

• Discretionary Annual Incentive.
• Comprehensive Medical Coverage: Medical & Health, Dental & Vision, Disability Planning & Insurance, Pet Insurance Plans.
• Family Support: Maternal & Parental Leaves.
• Insurance Options: Auto & Home Insurance, Identity Theft Protection.
• Convenience & Professional Growth: Commuter Benefits & Certification & amp; Training Reimbursement.
• Time Off: Vacation, Time Off, Sick Leave & Holidays.
• Legal & Financial Assistance: Legal Assistance, 401K Plan, Performance Bonus, College Fund, Student Loan Refinancing.