Job 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 andover-long retention have left it expensive to store and slow to query. Two issues dominate cost: a ~4 TBrequest-log table whose space cannot be reclaimed by DELETE (InnoDB does not return it; OPTIMIZE TABLEwould lock the table for an unpredictable time), and a high IOPS bill from running the write-heavy cluster on Aurorastandard 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 () for more information.
Spectrum IT Recruitment (South) Limited is acting as an Employment Business in relation to this vacancy.