Description

You will own the administration and performance of our PostgreSQL infrastructure.

Responsibilities

• Manage the full lifecycle of PostgreSQL, including installation, configuration, patching, and version upgrades to maintain 99.9% uptime.
• Optimize database performance by analyzing execution plans, tuning postgresql.conf, and managing indexing strategies.
• Design and maintain highly available (HA) clusters using repmgr, owning failover testing and split-brain prevention.
• Execute low-downtime migrations from on-premises systems to Cloud SQL or Azure Database for PostgreSQL.
• Oversee comprehensive Backup & Recovery (PITR) and Disaster Recovery (DR) strategies.

Required Skills

• 5+ years of experience administering PostgreSQL.
• Deep knowledge of PostgreSQL internals, including WAL, MVCC, Autovacuum, and memory architecture.
• Proven hands-on experience with repmgr for automated cluster failover.
• Proficiency with standard tools: pg_dump, pg_restore, pg_basebackup, and pg_upgrade.
• Working knowledge of GCP or Microsoft Azure database services.
• Experience configuring streaming and logical replication.
• Familiarity with monitoring stacks like Prometheus, Grafana, or pgAdmin.

Preferred Skills

• Experience automating deployments using Ansible or Terraform.

Key Skills

Education

Any Gradute