PostgreSQL Database Administrator

PostgreSQL Database Administrator - EU Citizens OnlyThis is a role for an experienced PostgreSQL DBA to support database operations within a technical environment managing production grade systems. The successful contractor will take ownership of database health, performance, and security across the full administration lifecycle.Responsibilities:Install, configure, and upgrade PostgreSQL instances across environments.Monitor database performance and maintain high availability for critical systems.Design and implement backup and recovery strategies to meet business continuity requirements.Optimise and tune queries, indexes, and configurations to improve throughput and reduce latency.Enforce database security controls, manage access permissions, and maintain data integrity.Write and maintain scripts for automated maintenance, monitoring, and alerting tasks.Collaborate with development teams on database design, schema changes, and architecture decisions.Key Skills and Experience:4 to 8 years of hands on PostgreSQL administration experience.Strong knowledge of performance tuning, query optimisation, and index management.Experience with backup and recovery tools such as pgBackRest or pg_dump.Proficiency in scripting for automation, using Bash, Python, or SQL.Solid understanding of database security, roles, and access control in PostgreSQL.Desirable Skills:Experience with high availability configurations such as Patroni or Streaming ReplicationFamiliarity with monitoring tools such as pgBadger, Prometheus, or Grafana.Exposure to cloud hosted PostgreSQL environments such as AWS RDS or Azure Database for PostgreSQL.