Job Title: PostgreSQL Database Administrator (PostgreSQL DBA)
Experience: 4–8 Years
Job Summary
We are seeking a skilled PostgreSQL Database Administrator (DBA) with strong expertise in PostgreSQL database administration, monitoring, performance tuning, backup & recovery, replication, and production database support. The ideal candidate should have hands-on experience managing high-availability PostgreSQL environments, ensuring database reliability, security, and optimal performance.
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.
- Collaborate with application developers, DevOps, and infrastructure teams during deployments, migrations, and production releases.
- Perform database upgrades, patching, and maintenance activities with minimal 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
- Strong 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 queries
- Database crashes
- Storage issues
- Good understanding of PostgreSQL security, user management, and role-based access control.
- Experience with Linux administration and shell scripting.
- Familiarity with monitoring tools such as:
- pgAdmin
- Prometheus
- Grafana
- Nagios
- Zabbix
- Knowledge of SQL query optimization and execution plans.
Preferred Skills
- Experience with PostgreSQL High Availability solutions such as Patroni, Pgpool-II, or HAProxy.
- Experience with cloud databases on AWS RDS PostgreSQL, Azure Database for PostgreSQL, or Google Cloud SQL.
- Knowledge of DevOps tools such as Docker, Kubernetes, Jenkins, Ansible, or Terraform.
- Experience with database automation and scripting using Bash or Python.
- Understanding of ITIL processes and production support.
Qualifications
- Bachelor's degree in Computer Science, Information Technology, or a related field.
- PostgreSQL certification is an added advantage.
Required Experience
- 4–8 years of experience as a PostgreSQL Database Administrator.
- Experience managing production PostgreSQL environments.
- Hands-on experience with backup/recovery, replication, performance tuning, and database monitoring.
Good to Have
- Experience with database migrations.
- Exposure to multi-terabyte databases.
- Knowledge of CI/CD deployment processes.
- Experience working in Agile/Scrum environments.
Pay: ₹350,974.60 - ₹1,000,000.00 per year
Work Location: In person
