PostgreSQL Database Administrator – PostgreSQL, Clustering & Cloud Migration

PostgreSQL Database Administrator – PostgreSQL, Clustering & Cloud Migration Required Skills & Qualifications PostgreSQL Administration

Proven experience as a PostgreSQL Database Administrator in enterprise environments.

• Strong knowledge of PostgreSQL architecture, including:
• WAL
• MVCC
• Vacuum processes
• Hands‑on experience with Rep Mgr clustering, failover handling, and node recovery.
• Working knowledge of:
• Logical replication
• Streaming replication

• Expertise in performance tuning
• Query optimization
• Database troubleshooting
• Strong problem‑solving skills for complex database issues.

• Experience with migration strategies from on‑premises environments to cloud platforms.
• Proficiency in backup and recovery, disaster recovery planning.
• Familiarity with Oracle DBA technologies, including RMAN, Golden Gate, Exadata.

• Experience with database automation tools:
  Ansible, Terraform.
• Knowledge of database monitoring tools: pg Admin, Prometheus, Grafana.
• Scripting experience using Shell, Python, and similar automation scripting languages.

• Experience automating database deployments and operational processes.
• Strong communication skills with the ability to collaborate across technical teams.