Postgres Database Administrator

Preferred Location USA MN CT preferred Job Summary Experienced Postgres Database Administrator to manage maintain and optimize PostgreSQL environments across on-premises and cloud platforms The ideal candidate will have a strong understanding of PostgreSQL architecture, clustering technologies and migration strategies along with hands on experience in performance tuning backup recovery, and disaster recovery procedures Key Responsibilities Database Administration Install configure and maintain PostgreSQL databases in production and non production environments Perform database refresh activities between environments as required Demonstrate a good understanding of PostgreSQL database architecture including memory management indexing, and query optimization Implement and manage repmgr cluster technology for high availability and failover Troubleshoot and resolve cluster node failure issues promptly to minimize downtime Migration & Cloud Integratio Design and execute migration strategies from on-prem to cloud environments Knowledge of Google Cloud Platform GCP or Microsoft Azure for database hosting and services is a plus Backup Recovery Proficient in Database Backup Recovery and Disaster Recovery procedures ensuring data integrity and business continuity. Implement logical and physical backup strategies using native PostgreSQL tools and third party solutions Replication Configure and manage logical replication for data synchronization across environments Required Skills Qualifications Proven experience as a Postgres Database Administrator in enterprise environments Strong knowledge of PostgreSQL architecture including WAL MVCC and vacuum processes Hands on experience with repmgr clustering failover handling and node recovery Experience with migration strategies from on premises to cloud platforms Familiarity with Google Cloud or Azure database services Proficiency in backup recovery and disaster recovery planning Working knowledge of logical replication and streaming replication Preferred Qualifications Experience with automation tools Ansible Terraform for database deployments Knowledge of monitoring tools like pgAdmin Prometheus or Grafana Scripting skills in Shell Python or similar for automation