Details:
- Job Type: Contract
- Job Status: Full-Time
- Location: London
- Date: 6 hours ago
Description:
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 ((url removed)) for more information.
Spectrum IT Recruitment (South) Limited is acting as an Employment Business in relation to this vacancy