Apply for Postgres Admin Job

6+ Years Relevant Experience

We are seeking an experienced PostgreSQL Database Administrator (DBA) with strong expertise in database administration, performance tuning, high availability, and cloud-based deployments. The ideal candidate will be responsible for managing complex PostgreSQL environments, ensuring system reliability, scalability, and performance, as well as supporting migration and automation initiatives.

Key Responsibilities:

Database Architecture & Design

• Design and maintain complex database schemas and architecture to meet business and application needs.

Performance Tuning & Optimization

• Conduct advanced performance tuning, query optimization, and indexing using tools like EXPLAIN, ANALYZE, pg_stat_statements, etc.

Backup and Recovery

• Implement and manage robust backup strategies using tools like pgBackRest or Barman.
• Perform disaster recovery planning, documentation, and testing.

High Availability & Replication

• Set up and maintain HA environments using streaming replication, Patroni, repmgr, or Pgpool-II.
• Support logical replication and change data capture (CDC) strategies.

Security & Compliance

• Implement role-based access control (RBAC), SSL/TLS encryption, and auditing mechanisms.
• Ensure database environments comply with security and industry best practices.

Monitoring & Maintenance

• Proactively monitor database health using Prometheus, Grafana, or similar tools.
• Perform routine database maintenance such as VACUUM, REINDEX, and ANALYZE.

Upgrades & Migrations

• Plan and execute PostgreSQL version upgrades with minimal downtime.
• Lead migration initiatives from on-premise to cloud platforms like AWS RDS/Aurora, Azure PostgreSQL, or GCP Cloud SQL.

Required Skills:

• 6+ years of hands-on experience with PostgreSQL (v11 and above).
• Strong expertise in PL/pgSQL scripting, Linux/Unix-based systems.
• Experience with HA tools (Patroni, repmgr), backup tools (pgBackRest, Barman).
• Knowledge of cloud-native PostgreSQL deployments (AWS, GCP, Azure).
• Familiarity with database automation and monitoring best practices.

Good-to-Have Skills:

• Experience with other databases (Oracle, MySQL, MongoDB, etc.).
• Familiarity with PostgreSQL Operators for Kubernetes (e.g., Zalando, Crunchy).
• Understanding of Infrastructure as Code tools like Terraform, Ansible.
• CI/CD practices for database release automation.
• Clustering, sharding, and advanced replication setups.
• Network monitoring, database auditing, and vulnerability management.

Certifications (Preferred, but Not Mandatory):

• AWS Certified Database – Specialty
• Other relevant PostgreSQL or cloud certifications

Soft Skills:

• Strong analytical and troubleshooting skills
• Excellent verbal and written communication skills
• Proven ability to work in a cross-functional and collaborative environment
• Effective stakeholder and project management skills