[linuxjobs] MySQL DB Administrator / Systems Development, London

[James Pearson]

Vacancy at the Moving Picture Company, Soho, London - below is a copy of 
the advert posted on our web site at:

<http://www.moving-picture.com/index.php/recruitment/jobslondontechnology/924-mysql-db-administrator--systems-development.html>

James Pearson


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.