Job Description:
Latest job information from Spectrum IT Recruitment for the position of Contract Database Administrator. If the Contract Database Administrator vacancy in London matches your qualifications, please submit your latest application or CV directly through the updated Jobkos job portal.
Please note that applying for a job may not always be easy, as new candidates must meet certain qualifications and requirements set by the company. We hope the career opportunity at Spectrum IT Recruitment for the position of Contract Database Administrator below matches your qualifications.
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 () for more information.
Spectrum IT Recruitment (South) Limited is acting as an Employment Business in relation to this vacancy.
JBRP1_UKTJ
Job Info:
- Company: Spectrum IT Recruitment
- Position: Contract Database Administrator
- Work Location: London
- Country: GB
How to Submit an Application:
After reading and understanding the criteria and minimum qualification requirements explained in the job information Contract Database Administrator at the office London above, immediately complete the job application files such as a job application letter, CV, photocopy of diploma, transcript, and other supplements as explained above. Submit via the Next Page link below.
Next Page »