Senior Database Administrator - AWS, Aurora, RDS

Investigo; Greater London; Hybrid; GBP 22,140,000 - 25,830,000; Full time

Job summary

Investigo seeks a Senior Database Administrator with active SC clearance to lead the design, operation, and optimization of critical AWS-based database platforms in a hybrid London setup. The role focuses on Aurora, RDS, and PostgreSQL with responsibility for DR, performance tuning and data integrity.

You will drive architecture decisions, support governance, and collaborate with cloud teams to ensure robust, scalable database solutions and smooth CI/CD integration.

Qualifications

• Active SC Clearance held by a Government agency within the last 6 months.
• Lead architecture and delivery of enterprise AWS database solutions (Aurora, RDS, PostgreSQL).
• Design scalable, resilient and highly available database platforms with DR strategies.
• Drive database performance optimisation through SQL development, query tuning, and plan analysis.
• Manage operations including upgrades, patching, security, monitoring, capacity planning, backup and recovery.
• Troubleshoot production issues, data reconciliation and root cause analysis of data discrepancies.
• Collaborate with architects, developers and cloud teams to support governance, automation and CI/CD.

Responsibilities

• Lead design, operation and optimisation of enterprise AWS databases.
• Architect and implement highly available database platforms with DR plans.
• Coordinate upgrades, patching and security for critical systems.
• Tune queries and optimize performance; monitor capacity and recovery procedures.
• Investigate data discrepancies and perform root-cause analysis.

Skills

AWS Aurora

Amazon RDS

PostgreSQL

Performance tuning

Data reconciliation

Root cause analysis

CI/CD

Terraform

CloudFormation

SC clearance

Tools

Terraform

CloudFormation

Job description

Senior Database Administrator – Active SC Clearance £538 per day – Inside IR35 London / Hybrid 4 months initially

We are seeking a highly experienced Senior DBA with expertise in AWS Aurora, Amazon RDS and PostgreSQL to lead the design, operation, optimisation, resilience, and recovery of critical database platforms. The successful candidate will be a hands-on technical expert, actively involved in architecture decisions, database design, performance tuning, data reconciliation, and operational support.

Key Requirements:

• Active SC Clearance held by a Government agency used within the last 6 months.
• Lead the architecture, design and delivery of enterprise AWS database solutions, with a focus on AWS Aurora, Amazon RDS and PostgreSQL.
• Design scalable, resilient and highly available database platforms, including schema design, data modelling, indexing, replication and disaster recovery strategies.
• Drive database performance optimisation through SQL development, query tuning, execution plan analysis and configuration improvements.
• Manage database operations including upgrades, patching, security, monitoring, capacity planning, backup and recovery processes.
• Troubleshoot complex production issues, perform data reconciliation and integrity validation, and lead root cause analysis of data discrepancies.
• Collaborate with architects, developers and cloud teams to support technical governance, infrastructure automation (Terraform/CloudFormation), CI/CD practices, and the production of technical standards and documentation.