RWE Supply Trading GmbH To start as soon as possible, full time / part time, permanent 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 CloudFo