MySQL DB Administrator / Systems Development

Start Date – Immediate

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
Experience/Knowledge
·Significant and substantial background experience managing large and complex databases
·Experience working closely with Software Engineering and Systems Engineering staff
·Deep understanding of Linux, preferably Red Hat based and how the kernel and filesystem interact with DB performance
·Able to demonstrate knowledge and experience administering complex MySQL configurations in a production environment
·Good knowledge of hardware; cpu architectures, ram and disk storage and how they impact DB performance
·Be able to demonstrate a very high level of knowledge and proficiency in SQL and MySQL v5.1 in particular
·Good knowledge of other DB engines such as Postgres, Oracle, Informix, DB2 etc.
·Understand the complexity of managing data across multiple sites in multiple environments (development, test, stage) in a high pressure, collaborative culture
·Significant knowledge and experience using at least two of bash, perl, python or C/C++
·Some knowledge of FOSS/Linux/Unix technologies including Apache, NFS, CVS, Subversion, make, rsync, rpm, yum, etc.

Salary: Competitive remuneration package
Location: London

Application Closing Date: (None) Ongoing recruitment
This is an exciting opportunity to work in the dynamic world of visual effects. If you are interested please apply online here: http://www.moving-picture.com/index….nology&loc=ldn

No Responses to “MySQL DB Administrator / Systems Development”

Post a Comment