Company Overview
RWE is leading the way to a clean energy world. With its investment and growth strategy Growing Green, RWE is contributing significantly to the success of the energy transition and the decarbonisation of the energy system. Around 20,000 employees work for the company in almost 30 countries worldwide. RWE is already one of the leading companies in the field of renewable energy. RWE is investing billions of euros in expanding its generation portfolio, in particular in offshore and onshore wind, solar energy and batteries. It is perfectly complemented by its global energy trading. RWE is decarbonising its business in line with the 1.5-degree reduction pathway and will phase out coal by 2030. RWE will be net-zero by 2040. Fully in line with the company’s purpose — Our energy for a sustainable life.
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.
APPLY