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