Senior PostgreSQL DBA | Automation & High Availability

Synechron; Sheffield; On-site; GBP 60,000 - 90,000; Full time

Job summary

Synechron is seeking a hands-on PostgreSQL DBA to ensure availability, performance, security and resilience of enterprise-scale database platforms. The role involves automation, on-call support, and collaboration with application, cloud, infrastructure and security teams.

You will administer PostgreSQL, design high-availability solutions, manage backups and perform migrations in a 24/7 production environment, using scripting and DevOps practices to optimise operations.

Qualifications

• Proven PostgreSQL DBA experience managing enterprise-scale databases.
• Strong understanding of PostgreSQL architecture, replication, failover, and disaster recovery.
• Experience with backup, restore, WAL, vacuuming and routine maintenance.
• Advanced SQL, query optimisation and performance-tuning skills.
• Good Linux/Unix administration and shell-scripting experience.
• Experience with Python, Bash, Ansible or similar automation technologies.
• Experience supporting critical databases in a 24/7 production environment.
• Familiarity with ITIL processes, incident management and change control.
• Strong communication and problem-solving skills.

Responsibilities

• Administer, configure, upgrade and patch PostgreSQL databases.
• Design and support high-availability, replication and disaster-recovery solutions.
• Manage backup, restore and point-in-time recovery processes.
• Monitor and optimise database performance, capacity and availability.
• Troubleshoot complex database incidents and performance issues.
• Carry out database migrations, upgrades and infrastructure changes.
• Automate administration and operational tasks using scripting and DevOps tools.
• Implement database security, access controls, auditing and vulnerability remediation.
• Work closely with application, cloud, infrastructure and security teams.
• Maintain technical documentation, runbooks and operational procedures.
• Participate in change management, incident response and on-call support.

Skills

PostgreSQL DBA

PostgreSQL architecture

Replication & HA

Backup & recovery

SQL optimization

Linux administration

Shell scripting

Python

Ansible

DevOps tooling

ITIL & incident management

On-call support

Change control

Security & access controls

Documentation

Tools

Bash

Unix tooling

Job description

Synechron is seeking a hands-on PostgreSQL DBA to ensure availability, performance, security and resilience of enterprise-scale database platforms. The role involves automation, on-call support, and collaboration with application, cloud, infrastructure and security teams.

You will administer PostgreSQL, design high-availability solutions, manage backups and perform migrations in a 24/7 production environment, using scripting and DevOps practices to optimise operations.