Database Administrator

Tata Consultancy Services; Pune District; On-site; INR 1,200,000 - 2,400,000; Full time

Job summary

Tata Consultancy Services in Pune is seeking a PostgreSQL DBA with 5 to 8 years of hands-on experience to manage enterprise databases. The role requires deep expertise in PostgreSQL, replication, high availability, backups, PITR, and performance tuning, with strong Linux (RHEL) administration skills.

The ideal candidate will install, configure, upgrade, and migrate databases, monitor performance, and collaborate with application, infrastructure, and cloud teams to ensure production reliability

Qualifications

• 5–8 years of PostgreSQL DBA experience.
• Experience with Linux (RHEL) administration and production support.
• Strong skills in replication, high availability, backups, PITR, and performance tuning.

Responsibilities

• Manage, monitor, and maintain PostgreSQL databases.
• Install, configure, upgrades, and migrations.
• Handle replication, high availability, backups, recovery, and PITR.
• Monitor performance, optimize queries, and resolve database issues.
• Capacity planning, security management, and production support.
• Troubleshoot replication, failover, and RCA.
• Collaborate with application, infrastructure, and cloud teams.

Skills

PostgreSQL DBA

Replication & High Availability

Backup & Recovery & PITR

Performance Tuning & Query Optim

Database Upgrades & Migrations

Linux (RHEL) Administration

Tools

AWS RDS PostgreSQL

CloudWatch

Performance Insights

pgAdmin

PgBouncer

pgBadger

Bash/Shell Scripting

Database Migration Experience

Job description

Role: PostgreSQL DBA

Experience: 5 to 8 Years

Location: Pune

Key Responsibilities

• Manage, monitor, and maintain PostgreSQL databases.
• Perform installation, configuration, upgrades, and migrations.
• Handle replication, high availability, backups, recovery, and PITR.
• Monitor performance, optimize queries, and resolve database issues.
• Conduct capacity planning, security management, and production support.
• Troubleshoot replication, failover, and critical incidents (RCA).
• Collaborate with application, infrastructure, and cloud teams.

Required Skills

• PostgreSQL DBA
• Database Upgrades & Migrations
• Replication & High Availability
• Backup, Recovery & PITR
• Performance Tuning & Query Optimization
• Linux (RHEL) Administration

Preferred Skills

• AWS RDS PostgreSQL
• CloudWatch, Performance Insights
• pgAdmin, PgBouncer, pgBadger
• Bash/Shell Scripting
• Database Migration Experience

Primary Skills

• PostgreSQL DBA | Replication | High Availability | PITR | Performance Tuning | Query Optimization | Database Upgrades | Linux | Production Support