Intermediate PostgreSQL Database Administrator

Role & responsibilities

Job Specification: Intermediate PostgreSQL Database Administrator (DBA)

We are seeking an Intermediate PostgreSQL Database Administrator to join our team to support one of our Banking clients. The ideal candidate will have strong hands-on experience in administering PostgreSQL databases, performance tuning, and ensuring high availability and security. This role requires someone with solid technical expertise, problem-solving skills, and the ability to collaborate effectively with system administrators, application owners and business stakeholders.

Key Responsibilities:

• Install, configure, upgrade, and maintain PostgreSQL database instances.
  
• Monitor database performance and proactively optimize queries, indexes, and configurations.
  
• Implement and maintain database security policies, including role-based access and data encryption.
  
• Manage backup and recovery processes to ensure data integrity and business continuity.
  
• Perform database patching and version upgrades with minimal downtime.
  
• Support high availability (HA) and disaster recovery (DR) solutions (e.g., replication, failover).
  
• Collaborate with developers to optimize SQL queries and schema designs.
  
• Troubleshoot database-related issues and provide root cause analysis.
  
• Develop and maintain documentation for database architecture, processes, and procedures.
  
• Participate in on-call rotation for critical database support.
  

Required Skills & Experience:

• 35 years of proven experience as a PostgreSQL DBA in production environments.
  
• Strong understanding of PostgreSQL architecture, internals, and performance tuning.
  
• Proficiency in writing and optimising SQL queries and PL/pgSQL functions.
  
• Experience with PostgreSQL replication, partitioning, and clustering.
  
• Solid understanding of backup/recovery strategies (pg\_dump, pg\_basebackup, WAL archiving).
  
• Familiarity with monitoring tools (e.g., pgAdmin, Nagios, Prometheus, Grafana).
  
• Hands-on experience with Linux operating systems (RHEL, Ubuntu).
  
• Knowledge of database security best practices.
  
• Exposure to automation tools (Ansible) is advantageous.
  

Qualifications:

• PostgreSQL certifications (e.g., EDB PostgreSQL Associate/Professional) would be an advantage.
  

Soft Skills:

• Strong problem-solving and analytical skills.
  
• Ability to work independently and as part of a team.
  
• Good communication skills for liaising with technical and non-technical stakeholders.
  
• Attention to detail and commitment to delivering high-quality work.