Postgresql Database Administrator

Job Title: PostgreSQL Database Administrator (Postgres DBA)

Job Overview:

The PostgreSQL Database Administrator is responsible for the design, implementation, maintenance, and performance of critical PostgreSQL database systems. This individual ensures high availability, security, and optimal performance across multiple applications and environments.

Technical Skills:

• PL/pgSQL

  (advanced querying, stored procedures, functions, performance tuning)

• pgAdmin, psql CLI

  , or equivalent admin tools

• High availability and disaster recovery

  : streaming replication, logical replication, failover tools (e.g., Patroni, repmgr), clustering

• Backup/recovery tooling and strategies

  , encryption, and auditing frameworks (e.g., pgBackRest, WAL-G)

• Monitoring and performance tools

  : pg_stat_statements, auto_explain, pgBadger

• Scripting and automation

  : Bash, Python, Ansible, CI/CD pipeline integration

• Knowledge of storage, OS tuning, and virtualization or cloud platforms

  (AWS RDS/Aurora, Azure Database for PostgreSQL) for capacity and I/O optimization

Responsibilities:

Database Management:

• Install, configure, and maintain PostgreSQL instances (on-prem, cloud VM, or managed PaaS)
• Design and implement scalable database solutions to meet business needs
• Perform capacity planning, version upgrades, and patch management

Performance Tuning and Optimization:

• Monitor query performance and system metrics proactively
• Analyze and optimize slow queries and indexing strategies
• Collaborate with developers to improve application-database interaction

Security and Compliance:

• Enforce role-based access control and encryption standards
• Ensure compliance with data protection regulations (e.g., GDPR, HIPAA)
• Conduct regular audits and vulnerability assessments

Backup and Recovery:

• Design and maintain robust backup and recovery strategies
• Validate restore procedures and ensure data integrity

High Availability and Disaster Recovery:

• Implement replication and failover mechanisms
• Test and document disaster recovery procedures

Monitoring and Reporting:

• Deploy monitoring tools and generate health/performance reports
• Maintain documentation for database configurations and operational procedures

Collaboration:

• Partner with developers, DevOps, and infrastructure teams
• Provide guidance on schema design, query optimization, and data lifecycle

Training and Documentation:

• Educate team members on PostgreSQL best practices
• Document architecture, processes, and operational playbooks

Qualifications:

• Proven experience as a PostgreSQL DBA in production environments
• Deep understanding of PostgreSQL architecture and internals
• Expertise in performance tuning and troubleshooting
• Familiarity with replication, failover, and disaster recovery tools
• Strong grasp of database security and compliance frameworks
• Excellent communication and cross-functional collaboration skills
• Relevant certifications (e.g., PostgreSQL CE, AWS Certified Database Specialty) are a plus