Simple Logic - PostgreSQL Database Administrator

We are seeking an experienced PostgreSQL Database Administrator (DBA) to join our database engineering team. This role is critical in ensuring the performance, availability, security, and stability of PostgreSQL database environments.

The ideal candidate will have strong hands-on expertise in PostgreSQL administration, upgrades, replication, backup & recovery, and high-availability solutions, and will play a key role in supporting mission-critical applications.

Key Responsibilities :

Database Administration & Operations :

- Install, configure, and maintain PostgreSQL database servers across development, testing, and production environments.

- Ensure high availability, reliability, and optimal performance of PostgreSQL databases.

- Perform daily monitoring, health checks, and proactive issue resolution.

- Manage database capacity planning and growth forecasting.

Performance Tuning & Optimization :

- Monitor database performance using PostgreSQL tools and third-party monitoring solutions.

- Perform query optimization, index tuning, vacuum/analyze, and configuration tuning.

- Identify and resolve performance bottlenecks related to CPU, memory, storage, and I/O.

Backup, Recovery & Disaster Management :

- Design, implement, and maintain backup and recovery strategies (logical and physical backups).

- Regularly test restore procedures to ensure data integrity and business continuity.

- Implement disaster recovery (DR) solutions and document recovery runbooks.

- High Availability & Replication Implement and manage PostgreSQL replication (Streaming Replication, Logical Replication).

- Configure and maintain high-availability solutions such as Patroni, pgPool, PgBouncer, or similar tools.

- Ensure minimal downtime during failover and recovery scenarios.

Upgrades & Migrations :

- Plan and execute PostgreSQL upgrades and migrations with minimal or zero downtime.

- Perform cross-version upgrades, platform migrations, and cloud/on-prem transitions.

- Validate post-upgrade performance, compatibility, and data consistency.

Required Skills & Qualifications :

Technical Skills :

- Strong hands-on experience as a PostgreSQL DBA (5+ years preferred).

- Expertise in PostgreSQL installation, configuration, upgrades, and patching.

- Solid understanding of replication, high availability, and clustering concepts.

- Experience with backup/recovery tools (pg_dump, pg_basebackup, WAL archiving, etc.).

- Proficiency in performance tuning and troubleshooting PostgreSQL databases.

- Strong knowledge of Linux/Unix environments and shell scripting.

- Experience with monitoring tools such as pgAdmin, Prometheus, Grafana, or similar.