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

Comprehensive Medical Coverage

Parental Leaves

401K Plan

Certification & Training Reimbursement

Vacation, Time Off, Sick Leave & H

Holidays

Legal & Financial Assistance

Job summary

Tata Consultancy Services in St. Louis, MO, seeks an experienced Oracle Database Administrator to install, configure and maintain Oracle databases across 11g/12c/19c on Linux/Unix. You will manage storage, backups, and performance tuning to ensure high availability.

The role covers DR readiness, Data Guard, RAC, security, and patching, with 24x7 production support and release coordination with application teams. Salary ranges from $100,000 to $130,000 with comprehensive employee benefits.

Qualifications

• Install, configure, and maintain Oracle databases on Linux/Unix.
• Perform database creation, configuration, cloning, and decommissioning.
• Manage storage components and perform space management.
• Design and implement backup/recovery strategies with RMAN.
• Ensure high availability using Data Guard and RAC.

Responsibilities

• 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.
• Monitor performance using AWR/ADDM/ASH and tune SQL/parameters.
• Provide 24x7 on-call production support and DR readiness.

Skills

Oracle DBA

Backup & Recovery

Performance Tuning

High Availability

Security & Compliance

Education

Bachelor of Computer Science

Tools

RMAN

Oracle RAC

AWR/ADDM/ASH

OEM

SQL/PLSQL

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

Job Description

Must Have Technical/Functional Skills

Database Administration

• 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

Upgrades, Patch & Migration

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

Qualifications:

BACHELOR OF COMPUTER SCIENCE