Database Administrator

  • Bengaluru, Karnataka, India
  • Full-time

Company Description

The Moving Picture Company (MPC) has been a global leader in visual effects (VFX) for over 25 years and counting, with established facilities across the globe.  We are renowned for adding visual wonder and creative expertise to the film, advertising and entertainment industries, with some of our most famous projects including the blockbuster movies Blade Runner 2049, The Jungle Book, and The Martian, and advertising campaigns for Channel 4, Sony and IKEA.

MPC is part of Technicolor’s premiere portfolio of VFX brands and services, working alongside The Mill, Mr. X and Mikros to provide offerings tailored to the specific creative and storytelling needs of each project.  Within this collective, MPC has built a reputation for industrial-scale production of images, and the software development to enable this.

Job Description

Introduction

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.

Essential Technical Skills:

  • Must have strong MySQL exposure to:
  • Installation/Upgrades 
  • Replication topologies
  • High Availability (failover and load balancing)
  • Backup and Recovery
  • Scaling strategies
  • Migration planningScripting languages, preferably Python and Bash.

Primary Responsibilities:

  • To take technical responsibility for our global DB server infrastructure
  • Suggest performance/reliability enhancements and carry out performance trouble-shooting
  • Maintenance of production, development and test DB environments and provide user support
  • Monitor usage, forecast capacity requirements, plan upgrades and scalability improvements
  • 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
  • General software "troubleshooting" e.g. stracing for segfaults, helping with bugs and workarounds

Desirable skills and experience:

  • 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
  • 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
    • Good knowledge of other DB engines such as Postgres, Oracle, Informix, DB2 etc.
    • Some experience with NoSQL
    • Some experience with cloud deployment and managed databases
    • Configuration management tools, preferably Ansible
    • Understand the complexity of managing data across multiple sites in multiple environments (development, test, stage) in a high pressure, collaborative culture
    • Some knowledge of FOSS/Linux/Unix technologies including Apache, NFS, CVS, Subversion, make, rsync, rpm, yum, etc.
 

Qualifications

Bachelors degree in Computer Science or a related technical discipline, or the equivalent combination of education, technical training, or work experience. To take technical responsibility for our global DB server infrastructure,

  • Maintenance of production, development and test DB environments and provide user support
  • Good knowledge of other DB engines such as Postgres, Oracle, Informix, DB2 etc.
  • Some experience with NoSQL
  • Some experience with cloud deployment and managed databases
  • Configuration management tools, preferably Ansible
  • Understand the complexity of managing data across multiple sites in multiple environments (development, test, stage) in a high pressure, collaborative culture
  • Some knowledge of FOSS/Linux/Unix technologies including Apache, NFS, CVS, Subversion, make, rsync, rpm, yum, etc.
Privacy Policy