Contract Database Administrator
Posted 5 days ago by Spectrum IT Recruitment
Negotiable
Undetermined
Undetermined
London
Summary: We are seeking a senior contract Database Administrator (DBA) to optimize a large, write-heavy Aurora MySQL database by reducing storage and I/O costs without causing downtime or production impact. The role involves validating and executing a known approach to address issues related to high storage costs and IOPS bills. This is a tightly-scoped, high-leverage project requiring expertise in MySQL and AWS Aurora. The contract duration is four weeks, and only UK-based contractors will be considered.
Key Responsibilities:
- Optimize storage and I/O costs on a large Aurora MySQL database.
- Ensure zero downtime and no production impact during the optimization process.
- Validate and execute the intended approach for database optimization.
Key Skills:
- DBA with MySQL / Aurora MySQL (InnoDB)
- Knowledge of MySQL RANGE partitioning
- Percona toolkit
- AWS Aurora
- Node.js / GoLang (beneficial)
Salary (Rate): Negotiable
City: London
Country: UK
Working Arrangements: undetermined
IR35 Status: undetermined
Seniority Level: Senior
Industry: IT
- Negotiable
- London
- Contract
Only UK based contractors to be considered
Description:
We need a senior contract DBA for a tightly-scoped, high-leverage piece of work: cut storage and I/O (IOPS) cost on a large, write-heavy Aurora MySQL database, with zero downtime and no production impact until a controlled cutover.
Project:
The database is overwhelmingly write-driven (high-volume API request and ping logging). Years of growth and
over-long retention have left it expensive to store and slow to query. Two issues dominate cost: a ~4 TB
request-log table whose space cannot be reclaimed by DELETE (InnoDB does not return it; OPTIMIZE TABLE
would lock the table for an unpredictable time), and a high IOPS bill from running the write-heavy cluster on Aurora
standard pricing.
Required Skills:
- DBA with MySQL / Aurora MySQL (InnoDB)
- Knowledge of MySQL RANGE partitioning
- Percona toolkit
- AWS Aurora
- Node.js / GoLang (beneficial)
This will be a 4 week contract, with the intended approach already known (can be provided), so requires an expert to validate this, harden it and execute it.
If interested, please apply or contact Matt Randall (mattrandall@spectrumit.co.uk) for more information.
Spectrum IT Recruitment (South) Limited is acting as an Employment Business in relation to this vacancy.