MySQL DBA - Huge Project Phase - Yorkshire - REF 922

Interface Recruitment UK; Wakefield; On-site; GBP 40,000 - 80,000; Full time

Job description

If you love big, weighty projects and hands-on problem solving, this role is for you. We require a MySQL DBA who will be part of a programme of work to overhaul the database structure, rolling up the versions to V8 and getting heavily involved in cloud migrations. If you have experience of building and splitting databases to ensure a resilient and robust platform, then you will fit well into this role. The MySQL Database Administrator works as part of a growing Technology company providing administration, support, and strategic guidance to the company’s MySQL databases for an enterprise-grade, online platform. The postholder should have proven experience in a similar role and be comfortable working on both project and operational tasks to support the business. The postholder will need to foster internal and external business relationships, understand complex requirements, and communicate effectively at all times.

Key Responsibilities:

• Reviewing and suggesting DDL for new features inline with SQL coding standards and best database performance for the development team
• Deploying DDL changes for new features to staging and production environments
• Optimising any slow and inefficient queries which are identified and suggesting improvements to the development team
• Ensuring service availability through 24/7 on-call
• Following and updating, where necessary, in-house procedure and environment documentation on Confluence
• Advising development teams on possible implementations for new features at the planning stage
• Configuring database credentials in dev, staging, and production platforms for applications and providing database credentials to the devops team
• Configuring developer access to development environments and distributing credentials
• Configuring developer and Data Analyst access to the data warehouse and production environment for production reports
• Tracking Data Analyst requests for GDPR sensitive data, seeking authorisation where necessary
• Following a continuous improvement goal to keep all database systems as up to date as possible through researching changes in new versions, testing new versions with the development team and proposing/actioning live upgrade plans (expecting all platforms to have at least one upgrade per year)
• Regularly auditing instance usage and ensuring monetary and resource costs are understood with stakeholders
• Following a CAB approval process for any live service affecting change ensuring that changes are understood by all stakeholders and approved by management

Essential Competencies/Skills and Experiences for the Role:

• Ideally Oracle Certified Professional OCP (MySQL 5.7 Database Administrator) or equivalent
• Ability to optimise and suggest alternatives to MySQL queries (data, table and index assessment, explain plan, knowledge of covering indexes, hash indexes, derived tables, factors affecting temporary table requirements, query hints, index hints)
• Ability to manage own workloads and priorities well
• Ability to engage with a variety of stakeholders, maintaining a professional “can do” approach at all times

Desirable Competencies/Skills and Experiences for the Role:

• Maintenance of supporting scripts for data feeds (perl) (decisions likely need to be made on how to split this between Data Analysts and DBA’s)
• Maintenance of in-house scripting (perl) for:
  • database monitoring (reporting to Zabbix / CheckMK)
  • binary log housekeeping
• Experience of working with Business Intelligence Platforms such as PowerBI and Business Objects
• Experience of supporting Financial Reporting and Reconciliation activity
• Experience of working in a fast-paced environment
• Good understanding of GDPR and other data protection regulations