Job SummaryWe are seeking an experienced PostgreSQL Database Administrator to manage, maintain, and optimize PostgreSQL databases in a production environment. The role focuses on database performance, availability, security, and reliability while working closely with application, infrastructure, and DevOps teams.
Key Responsibilities- Install, configure, and maintain PostgreSQL database systems
- Monitor database performance and proactively tune queries and indexes
- Manage database backup, recovery, and disaster recovery strategies
- Ensure database security, access control, and compliance
- Perform database migrations, upgrades, and patching
- Troubleshoot database issues and conduct root cause analysis
- Support high availability and replication setups (Streaming Replication, Logical Replication, etc.)
- Collaborate with application, infrastructure, and DevOps teams
Required Skills & Experience- 5+ years of hands-on experience as a PostgreSQL DBA
- Strong expertise in PostgreSQL architecture and internals
- Hands-on experience with performance tuning and optimization
- Experience with backup and recovery tools (pg_dump, pg_basebackup, WAL archiving)
- Strong knowledge of replication, clustering, and failover solutions
- Experience working in Linux/Unix environments
- Strong scripting skills (Shell, Python, or similar)
Competencies- Strong troubleshooting and analytical skills
- Ability to work independently in a production environment
- Strong collaboration and communication skills
- Attention to detail and operational excellence
Preferred Skills- Experience supporting large-scale or mission-critical database environments
- Exposure to DevOps practices and automation
- Experience with cloud-based PostgreSQL deployments
