Job Title:Postgres DBALocation:Dublin (Remote)Salary/Rate:Up to £409 per dayStart Date: Jan 2026Job Type:6-month contractCompany Introduction:Experienced Postgres Database Administrator to manage, maintain, and optimise PostgreSQL environments across on-premises andcloud platformsfor our client in the healthcare sector. 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.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.Expertise in performance tuning, query optimization, and troubleshooting.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.Excellent problem-solving and communication skills.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.Key Responsibilities:Database Administration:Install, configure, and maintain PostgreSQL databases in production and non-production environments.Perform database refresh activities between environments as required.Executepatching and upgrade activitiesto ensure databases remain secure, stable, and up to date.Architecture & Performance:Demonstrate a good understanding of PostgreSQL database architecture, including memory management, indexing, and query optimization.Handle performance issues by analysing query execution plans, tuning configurations, and implementing best practices.High Availability & Clustering:Implement and manage repmgr cluster technology for high availability and failover.Troubleshoot and resolve cluster node failure issues promptly to minimize downtime.Migration & Cloud Integration: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 synchronisation across environments.