Postgresql Database Administrator

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

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