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 solid 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.
Robust 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