Job Title: PostgreSQL Database Administrator (DBA) / PostgreSQL Lead
Experience: 10+ Years
Location: Chennai

Job Summary

We are seeking an experienced PostgreSQL Database Administrator (DBA) with 10+ years of experience in database administration, performance tuning, high availability, backup and recovery, and database security. The ideal candidate should have strong expertise in managing large-scale PostgreSQL environments, supporting mission-critical applications, and driving database optimization initiatives.

Key Responsibilities

- Install, configure, administer, and maintain PostgreSQL databases in production and non-production environments.
- Monitor database performance and perform proactive tuning to ensure optimal performance and availability.
- Design and implement backup, recovery, replication, and disaster recovery strategies.
- Manage PostgreSQL upgrades, patching, and migration activities.
- Implement High Availability (HA) solutions such as Streaming Replication, Patroni, PgPool, or similar technologies.
- Analyze and resolve database performance bottlenecks, locking issues, and query optimization requirements.




- Develop and maintain database standards, documentation, and operational procedures.
- Ensure database security, auditing, compliance, and access management.
- Work closely with application, infrastructure, and DevOps teams for database deployment and support.
- Support incident management, root cause analysis, and production issue resolution.

Required Skills

- Solid experience in PostgreSQL Administration (10+ years).
- Expertise in Performance Tuning, Query Optimization, and Indexing.
- Experience with PostgreSQL Replication, Clustering, and High Availability Solutions.
- Strong knowledge of Backup & Recovery, Disaster Recovery Planning.
- Experience in PostgreSQL version upgrades and migrations.
- Proficiency in SQL, PL/pgSQL, Stored Procedures, Functions, and Triggers.
- Experience with Linux/Unix administration.
- Knowledge of monitoring tools such as PgAdmin, Grafana, Prometheus, Nagios, or Zabbix.
- Experience in automation using Shell Scripting, Python, or Ansible.
- Understanding of database security best practices.

📌 Postgresql Database Administrator (Chennai)
🏢 Tata Consultancy Services
📍 Chennai