(Senior) PostgreSQL Database Administrator (DBA)

Job description
Department Insights

We are seeking a highly skilled Senior PostgreSQL Database Administrator (DBA) to manage, optimise, and maintain PostgreSQL databases hosted on Amazon Aurora and RDS. The ideal candidate will have extensive experience in database architecture, cloud-native database solutions, performance tuning, and implementing best practices for availability, scalability, and security.

This role requires hands-on technical expertise and strong collaboration with developers, architects, and DevOps teams to ensure our data infrastructure aligns with business needs and industry standards.

Your responsibilities

Database Administration
• Manage, configure, and optimise PostgreSQL databases hosted on Amazon Aurora and RDS.
• Design and implement database schemas, partitioning strategies, and indexing solutions.
• Ensure high availability, disaster recovery, and scalability of database systems using AWS-native solutions.

Performance Tuning and Optimization
• Diagnose and resolve performance bottlenecks, including slow queries, locks, and resource contention.
• Conduct regular health checks, indexing reviews, and query analysis to maintain optimal performance.

Automation and DevOps Integration
• Automate routine tasks such as backups, monitoring, scaling, and patching using scripting languages (e.g., Python, Bash).
• Collaborate with DevOps teams to integrate databases into CI/CD pipelines and infrastructure-as-code (IaC) frameworks like Terraform or CloudFormation.

Security and Compliance
• Implement PostgreSQL security best practices, including user management, encryption, and auditing.
• Ensure compliance with industry standards (e.g., GDPR, HIPAA) through robust access control and activity monitoring.

Backup and Disaster Recovery
• Develop and maintain backup and recovery strategies, including point-in-time recovery and failover setups.
• Conduct regular testing of disaster recovery plans.

Monitoring and Troubleshooting
• Set up and manage monitoring tools like CloudWatch, Datadog, or Prometheus to track database performance and availability.
• Troubleshoot and resolve complex database issues in real time.

Collaboration and Documentation
• Work closely with developers to optimise application queries and database interactions.
• Document processes, standards, and database architecture to ensure knowledge sharing and operational consistency.

Your profile
• 5+ years of hands-on experience as a PostgreSQL DBA in production environments.
• Expertise in managing databases on Amazon Aurora and Amazon RDS for PostgreSQL.
• Deep understanding of PostgreSQL architecture, including replication, clustering, and indexing strategies.
• Proven experience with query optimization and database performance tuning.
• Strong scripting skills in Python, Bash, or equivalent.
• Hands-on experience with AWS services such as EC2, S3, VPC, and IAM.
• Proficiency with infrastructure automation tools like Terraform or CloudFormation.
• Familiarity with monitoring tools such as CloudWatch, Datadog, or similar.
• Experience implementing robust backup and recovery strategies.
• Solid understanding of database security principles and compliance frameworks.

Advantageous

What we value most is curiosity, ambition, resilience and authenticity. So, if you can’t display all of the skills above we would still like to hear from you.

Our offer

We really appreciate you going the extra mile and using every ounce of energy when the heat is on. That’s why we want to make your time with us as enjoyable as possible. At RWE Supply & Trading we value our employees and strive to create a supportive and inclusive work environment. With a range of competitive benefits, we not only offer excellent development prospects and an attractive remuneration package, but also take care of your well-being and understand that life-work integration is essential. Also our offer includes the following perks:
• Task oriented and hybrid working model
• Join a diverse and multicultural team in a highly dynamic and rapidly growing business
• State-of-the-art campus with free fitness center, child care, on-site barista & restaurants

Core Skills: SQL, AWS, Power BI
Other Skills:
Seniority: Senior, Mid

United Kingdom
England
London Show on map Get directions