PostgreSQL DBA

Whereuelevate; Chennai District; On-site; INR 900,000 - 1,500,000; Full time

Job summary

KlusterFirst Pvt Ltd is seeking an experienced PostgreSQL DBA to manage, monitor, and support PostgreSQL Community Edition databases critical to business workloads. The role emphasizes availability, performance, stability, backups, and operational support.

Responsibilities include installation, configuration, health monitoring, tuning, HA and replication, TimescaleDB support, and proactive incident management.

Qualifications

• Strong hands-on experience in PostgreSQL Database Administration.
• Experience with PostgreSQL Community Edition.
• Expertise in Performance Tuning, Query Optimization, and Indexing.
• Experience with PostgreSQL HA and Replication.
• Hands-on experience with TimescaleDB.
• Strong knowledge of Backup, Recovery, and Restore Testing.
• Good Linux administration and troubleshooting skills.
• Strong incident management and RCA documentation skills.

Responsibilities

• Install, configure, and administer PostgreSQL databases following industry best practices.
• Monitor database health, availability, performance, and capacity.
• Perform performance tuning, query optimization, and indexing.
• Manage database incidents, troubleshooting, and prepare RCA reports.
• Validate backups and perform regular restore and recovery testing.
• Set up and troubleshoot PostgreSQL High Availability (HA) environments.
• Configure and support TimescaleDB for time-series workloads in single-instance and HA setups.
• Perform hands-on administration and troubleshooting in Linux environments.
• Maintain SOPs, runbooks, architecture documents, and operational documentation.
• Coordinate with application and infrastructure teams to resolve database issues.

Skills

PostgreSQL Database Administration

PostgreSQL Community Edition

Performance Tuning

Query Optimization

Indexing

PostgreSQL HA/Replication

TimescaleDB

Backup/Recovery Testing

Linux Administration

Incident Management & RCA

Job description

We are looking for an experienced PostgreSQL DBA to manage, monitor, and support PostgreSQL Community Edition databases. The role focuses on database availability, performance, stability, backup/recovery, and operational support for business-critical workloads.

Key Responsibilities

• Install, configure, and administer PostgreSQL databases following industry best practices.
• Monitor database health, availability, performance, and capacity.
• Perform performance tuning, query optimization, and indexing.
• Manage database incidents, troubleshooting, and prepare RCA reports.
• Validate backups and perform regular restore and recovery testing.
• Set up and troubleshoot PostgreSQL High Availability (HA) environments.
• Configure and support TimescaleDB for time-series workloads in single-instance and HA setups.
• Perform hands-on administration and troubleshooting in Linux environments.
• Maintain SOPs, runbooks, architecture documents, and operational documentation.
• Coordinate with application and infrastructure teams to resolve database issues.

Required Skills

• Strong hands-on experience in PostgreSQL Database Administration.
• Experience with PostgreSQL Community Edition.
• Expertise in Performance Tuning, Query Optimization, and Indexing.
• Experience with PostgreSQL HA and Replication.
• Hands-on experience with TimescaleDB.
• Strong knowledge of Backup, Recovery, and Restore Testing.
• Good Linux administration and troubleshooting skills.
• Strong incident management and RCA documentation skills.

Skills required

Mandatory skills

HA

Replication

TimescaleDB

Performance-Tuning

Troubleshooting.

All available locations

About Klusterfirst Pvt Ltd

KlusterFirst is a specialized IT services company helping businesses simplify, secure, and scale their data platforms

We deliver expert solutions in Database Management, Cloud Migration, Performance Optimization, Database Security, Emergency Database Support, and Data Analytics.
Our services ensure your data and cloud systems are highly available, secure, compliant, and cost-efficient. With 18+ years of enterprise experience, we combine strategic insight with hands-on expertise. Whether modernizing legacy systems or building cloud-native solutions, we help you stay ahead in today’s fast-moving digital landscape.