Reward Gateway

MySQL Database Administrator

Reward Gateway

full-time

Posted on:

Origin:  • 🇬🇧 United Kingdom

Visit company website
✨ AI Apply
Apply

Salary

💰 £78,000 - £84,000 per year

Job Level

Mid-LevelSenior

Tech Stack

AWSCloudMySQLPHPPythonSQLTerraform

About the role

  • Day-to-day management and optimisation of our MySQL databases within a Galera cluster and AWS environments.
  • Managing and optimising query workloads to ensure performance.
  • Collaborating closely with our DevOps and SRE teams to ensure database performance and reliability.
  • Implementing best practices for database management, including backup, recovery, and high availability.
  • Establishing and maintaining observability standards for database performance metrics, including SLI/SLO/Error Budgets.
  • Continuously evolving our database monitoring and observability tools for comprehensive coverage.
  • Driving database technology change to support regional deployments.
  • Utilising a code-first approach for database changes to minimise manual intervention.
  • Advocating for a strong focus on database availability, reliability, and uptime.
  • Liaising with Engineering teams to evolve database metrics and performance indicators.
  • Working towards planned Roadmap goals.
  • Actively participating in daily stand-ups and ensuring alignment with project sprints.
  • Maintaining up-to-date documentation in our JIRA & Confluence tools.
  • Participating in incident management processes.
  • Acting as a key point of contact during database-related incidents and outages.
  • Ensuring cost efficiency in database operations and resource utilisation.
  • Fostering collaboration across teams to enhance database solutions and practices.
  • Communicating effectively with stakeholders regarding database needs.

Requirements

  • Experience with AWS, particularly with RDS and Galera clusters, or other cloud providers.
  • Strong background in managing databases in high availability (HA) environments.
  • Proficiency in automation tools such as Terraform, Python, Bash, or similar for database management tasks.
  • Deep understanding of database management practices and principles, with a focus on MySQL.
  • Understanding of DB sharding technologies in regional deployments.
  • Familiarity with SQL, PHP, and CI/CD processes related to database deployments.
  • Experience with observability tools specific to database performance (e.g., New Relic, Datadog).
  • Knowledge of managing database infrastructures using SLI/SLO & Error Budgets.
  • Ability to work both independently and collaboratively within a team.
  • Capacity to perform under pressure and maintain high reliability.
  • Adaptability and flexibility to changes in a fast-paced environment.
  • Quick learner with the ability to grasp new tools and processes and share that knowledge with the team.