Job Title: PostgreSQL Database Administrator (PostgreSQL DBA)

Experience: 4-8 Years

Job Summary

Key Responsibilities
- Install, configure, administer, and maintain PostgreSQL databases across Development, QA, UAT, and Production environments.
- Monitor database health, availability, storage utilization, and overall system performance.
- Perform proactive database health checks, log analysis, and capacity planning.
- Configure, manage, and troubleshoot PostgreSQL Streaming Replication and High Availability solutions.
- Monitor replication status and resolve replication lag or synchronization issues.
- Plan, implement, and validate database backup and recovery strategies.
- Conduct disaster recovery (DR) testing and ensure business continuity.
- Optimize database performance through query tuning, indexing strategies, vacuuming, partitioning, and PostgreSQL parameter tuning.
- Troubleshoot database issues including locks, deadlocks, slow queries, connectivity problems, storage issues, and resource bottlenecks.
- Manage database users, roles, permissions, authentication,



and security policies.
- Perform database upgrades, patching, and maintenance activities with mínimal downtime.
- Create and maintain database documentation, SOPs, operational procedures, and troubleshooting guides.
- Support production incidents and participate in on-call support when required.

Required Skills:
- Solid experience with PostgreSQL Database Administration.
- Expertise in PostgreSQL installation, configuration, and upgrades.
- Experience with Streaming Replication, Logical Replication, and High Availability.
- Strong knowledge of Backup & Recovery using tools such as:
- pg_dump
- pg_basebackup
- WAL Archiving
- pgBackRest / Barman
- Strong experience in performance tuning and query optimization.
- Knowledge of PostgreSQL internals including:
- VACUUM
- ANALYZE
- Autovacuum
- Indexing
- Partitioning
- Experience in troubleshooting:
- Locks & Deadlocks
- Replication failures
- Slow quer

📌 PostgreSQL Dba (Gurugram)
🏢 Qloron Technology
📍 Gurugram