Sr Database Administrator - Production Reliability

Tata Consultancy Services; Sunnyvale (CA); On-site; USD 100,000 - 135,000; Full time

Job summary

Tata Consultancy Services Limited is seeking an experienced Database Engineer to administer and optimize Oracle, MongoDB, and PostgreSQL in production. You will ensure high availability, perform performance tuning, and manage backups and DR planning in a Linux environment.

Collaboration with application teams for schema design and releases is essential, with on-call responsibilities as needed. The role emphasizes incident triage, root-cause analysis, automation of provisioning and monitoring,

Qualifications

• 8+ years of experience in database engineering, administration, and production support.
• Hands-on expertise in Oracle, MongoDB, and PostgreSQL, including high availability, replication, clustering, patching, and upgrades.
• Strong experience in performance tuning, query optimization, indexing, capacity planning, backup, PITR, and disaster recovery.
• Ability to monitor and troubleshoot complex production issues, perform root-cause analysis, and support on-call operations.
• Working knowledge of Linux/Unix and scripting or automation using Python, Shell, or equivalent tools.

Responsibilities

• Administer and maintain highly available Oracle, MongoDB, and PostgreSQL production environments.
• Perform database performance tuning, query optimization, indexing, and capacity planning.
• Monitor database health, replication, storage, connections, locks, and resource consumption, and resolve issues proactively.
• Lead database incident triage, service restoration, root-cause analysis, and preventive actions.
• Automate provisioning, monitoring, maintenance, backup validation, recovery testing, and operational reporting.
• Partner with application and platform teams on schema design, migrations, releases, security, and non-functional requirements.
• Maintain database documentation, runbooks, DR evidence, and operational status updates for stakeholders.

Skills

Oracle

PostgreSQL

MongoDB

Tools

Prometheus

Grafana

Splunk

ELK/OpenSearch

Job description

Must Have:

• 8+ years of experience in database engineering, administration, and production support.
• Hands-on expertise in Oracle, MongoDB, and PostgreSQL, including high availability, replication, clustering, patching, and upgrades.
• Strong experience in performance tuning, query optimization, indexing, capacity planning, backup, PITR, and disaster recovery.
• Ability to monitor and troubleshoot complex production issues, perform root-cause analysis, and support on-call operations.
• Working knowledge of Linux/Unix and scripting or automation using Python, Shell, or equivalent tools.

Good To Have

• Experience with AWS, Azure, or Google Cloud managed database services.
• Knowledge of infrastructure as code, CI/CD, and database observability tools such as Prometheus, Grafana, Splunk, or ELK/OpenSearch.
• Understanding ITIL processes and experience preparing runbooks, operational dashboards, and DR test reports.
• Relevant database, cloud, or site reliability engineering certifications.

Responsibility / Expectation

• Administer and maintain highly available Oracle, MongoDB, and PostgreSQL production environments.
• Perform database performance tuning, query optimization, indexing, and capacity planning.
• Monitor database health, replication, storage, connections, locks, and resource consumption, and resolve issues proactively.
• Lead database incident triage, service restoration, root-cause analysis, and preventive actions.
• Automate provisioning, monitoring, maintenance, backup validation, recovery testing, and operational reporting.
• Partner with application and platform teams on schema design, migrations, releases, security, and non-functional requirements.
• Maintain database documentation, runbooks, DR evidence, and operational status updates for stakeholders.
• Design and manage robust backup, point-in-time recovery (PITR), failover and DR strategies to guarantee strict Recovery Point Objective (RPO) and Recovery Time Objective (RTO) targets

Location: Austin, TX/ Sunnyvale, CA

Salary Range: $100,000 - $135,000 a year #LI-AS3

Location Sunnyvale, CA

Function TECHNOLOGY

Role Engineer

ID 435335

Skills Oracle | PostgreSQL | MongoDB

Salary Range $100,000 - $135,000