Overview

hackajob Swindon, England, United KingdomDatabase Administrator

Location: Swindon, England, United KingdomPosted: 2 days ago • Be among the first 25 applicantsResponsibilities

Manage, configure and optimise PostgreSQL databases hosted on Amazon Aurora and Oracle databases hosted on on-premise Exadatas and AWS RDS.Support the migration of high-performance, mission-critical databases from on-premise Exadatas to AWS Aurora Postgres.Support workloads on other database engines in AWS, including MySQL, MariaDB and SQL Server.Implement and maintain strong security standards to ensure compliance with PCI DSS and other regulatory requirements.Implement security best practices, including user management, encryption and auditing.Design and implement database schemas, partitioning strategies and indexing solutions.Ensure high availability, disaster recovery and scalability of database systems.Configure strong monitoring and management processes and tooling to help troubleshoot and resolve complex database issues in real time.Essential qualifications

Hands-on experience as a PostgreSQL and Oracle DBA in production environments.Significant experience of migrating database workloads to Postgres from Oracle.Deep understanding of PostgreSQL architecture, including replication, clustering and indexing strategies, and a strong understanding of Postgres'' vacuum/MVCC process.Proven experience with query optimization and database performance tuning.Hands-on experience with AWS services such as EC2, S3, VPC, and IAM.Solid understanding of database security principles and compliance frameworksExperience implementing robust backup and recovery strategies.Desirable qualifications

Proficiency with infrastructure automation tools like Terraform or CloudFormation.Familiarity with monitoring tools such as CloudWatch, Datadog, or similar.Experience of database replication tooling such as AWS DMS and Goldengate.Experience of collaborating with DevOps teams to integrate databases into CI/CD pipelines and infrastructure-as-code (IaC) frameworks like Terraform.Seniority level

Mid-Senior levelEmployment type

Full-timeJob function

Information TechnologyIndustriesSoftware Development

#J-18808-Ljbffr