Postgresql MS Sql Database Administrator

Tata Consultancy Services; Delhi; On-site; INR 900,000 - 2,000,000; Full time

Job summary

Tata Consultancy Services is seeking a PostgreSQL specialist to install, configure, and maintain PostgreSQL, MySQL and SQL Server databases across on-premises and cloud environments. You will manage backups, high availability, upgrades, and monitoring while collaborating with developers on schema and performance optimization.

Responsibilities include tuning queries, implementing PITR and disaster recovery, and ensuring security via proper roles, encryption, and hardening.

Qualifications

• Strong SQL and PL/pgSQL knowledge.
• Experience with PostgreSQL 9.x / 11+ / 17+.
• Expertise in replication, PITR and disaster recovery.
• Strong Linux administration background.
• Experience with cloud DB (AWS RDS/Aurora PostgreSQL, Azure PostgreSQL).

Responsibilities

• Install, configure, and maintain PostgreSQL/MS Sql/MySQL databases (onprem & cloud).
• Perform backup/restore using pgBackRest, pg_dump, WAL archiving.
• Implement and manage high availability: Streaming Replication, Patroni, Failover Manager.
• Optimize database performance: indexing, query tuning, vacuum/analyze tuning.
• Plan and execute version upgrades and migrations.
• Configure monitoring and alerting (Prometheus, Grafana, pgAdmin, EFM).
• Manage roles, privileges, SSL, encryption, database hardening.
• Troubleshoot database issues and provide L3 support.
• Work with developers for schema design, query optimization, and SQL review.

Skills

PostgreSQL expert

SQL & PL/pgSQL

Linux administration

Database replication

Backup & recovery

Performance tuning

Cloud DB (AWS/Azure)

Tools

pgBackRest

pg_dump

Prometheus

Grafana

pgAdmin

Job description

PostgreSQL:-

• Install, configure, and maintain PostgreSQL/MS Sql/MySQL databases (onprem & cloud).
• Perform backup/restore using pgBackRest, pg_dump, WAL archiving.
• Implement and manage high availability: Streaming Replication, Patroni, Failover Manager.
• Optimize database performance: indexing, query tuning, vacuum/analyze tuning.
• Plan and execute version upgrades and migrations.
• Configure monitoring and alerting (Prometheus, Grafana, pgAdmin, EFM).
• Manage roles, privileges, SSL, encryption, database hardening.
• Troubleshoot database issues and provide L3 support.
• Work with developers for schema design, query optimization, and SQL review.
• Strong SQL skills and PL/pgSQL knowledge.
• Experience with PostgreSQL 9.x / 11+ / 17+.
• Expertise in replication, PITR, and disaster recovery.
• Strong Linux administration background.
• Experience with cloud DB (AWS RDS/Aurora PostgreSQL, Azure PostgreSQL) is a plus.