We are looking for an experienced PostgreSQL Database Administrator (DBA) with 7+ years of hands-on experience in managing, maintaining, optimizing, and troubleshooting PostgreSQL database environments. The ideal candidate should have solid expertise in database administration, performance tuning, high availability, backup/recovery, security, and production support.
Key Responsibilities
Install, configure, upgrade, patch, and maintain PostgreSQL database environments.
Manage production and non-production PostgreSQL databases.
Perform database performance tuning, query optimization, and troubleshooting.
Monitor database health, capacity, performance, and availability.
Implement and manage backup, restore, and disaster recovery strategies.
Configure and maintain High Availability (HA) and replication solutions.
Troubleshoot database performance, connectivity, locking, and transaction-related issues.
Manage users, roles, permissions, authentication, and database security.
Perform database migrations, upgrades, and version upgrades with minimal downtime.




Develop and maintain database monitoring and alerting mechanisms.
Work closely with developers, DevOps, and infrastructure teams to resolve database-related issues.
Participate in production deployments, incident management, and root-cause analysis.
Maintain technical documentation, operational procedures, and database standards.
Required Skills
7+ years of experience as a PostgreSQL DBA.
Strong hands-on experience with PostgreSQL administration and troubleshooting.
Expertise in PostgreSQL performance tuning and query optimization.
Strong knowledge of Backup & Recovery, PITR, WAL, and replication.
Experience with Streaming Replication and High Availability solutions.
Knowledge of PostgreSQL upgrades, migrations, and patching.
Strong understanding of database security, roles, permissions, and authentication.
Experience with Linux/Unix environments and shell scripting.
Good understanding of SQL and database architecture.

📌 PostgreSQL DBA (India)
🏢 Macersoft Technologies, a DataPlatformExperts
📍 India