Contract Database Administrator
S
Spectrum IT Recruitment
📍 London, London, United Kingdom
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 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,...
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,...