MySQL DB Administrator / Systems Development

Description

Department: Systems

Responsible to: Head of Systems and Features Technology

Main Purpose of Job:

To ensure the ongoing smooth operation of MPC’s global production systems with particular specialisation in database systems, to develop them further to meet business needs whilst supporting use of database technologies throughout the organisation. In addition to these responsibilities you’d also be part of the Systems team developing and maintaining the department tools and libraries.

Key Tasks/duties:



* To take primary technical responsibility for our global enterprise DB server infrastructure
* Maintenance of production, development and test databases and provide user support
* Suggest performance/reliability enhancements and carry out performance trouble-shooting
* Monitor usage, forecast capacity requirements, plan upgrades and scalability improvements
* Work with the Backup Administrator to create regular, reliable, timely and viable backups
* Formulate and document a comprehensive disaster recovery plan
* Extensively test and benchmark changes before deployment in the production environment
* Support R&D with schema design, query optimisation and ad hoc problem solving
* Identify upcoming requirements, pre-empt, recommend and implement solutions
* Mentoring team members, end user documentation and ongoing education of staff
* Tool and Systems development projects e.g. writing wrapper scripts, building and installing software, maintaining and developing monitoring and support systems
* General software "troubleshooting" e.g. stracing for segfaults, helping with bugs and workarounds