Senior Database Engineer: Oracle/PostgreSQL/MongoDB, HA & DR

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

Job summary

Tata Consultancy Services Limited in Sunnyvale, CA is seeking a Senior Engineer to administer and optimize mission-critical database environments, including Oracle, PostgreSQL, and MongoDB, with focus on high availability and disaster recovery. You will lead performance tuning, capacity planning, and on-call triage, and collaborate with application teams on schema design and migrations.

The role requires 8+ years of experience in database engineering, production support, and scripting in

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

Skills

Oracle

PostgreSQL

MongoDB

Tools

Linux/Unix

Python

Shell

Job description

Tata Consultancy Services Limited in Sunnyvale, CA is seeking a Senior Engineer to administer and optimize mission-critical database environments, including Oracle, PostgreSQL, and MongoDB, with focus on high availability and disaster recovery. You will lead performance tuning, capacity planning, and on-call triage, and collaborate with application teams on schema design and migrations.

The role requires 8+ years of experience in database engineering, production support, and scripting in