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

Back To Jobs