Data Systems Engineer (MySQL)

You will be responsible for ensuring the performance, availability, and security of clusters of MySQL instances in a mixture of containerized and non-containerized environment.
Scroll to content

Who we are

The Workshop is a tech company that develops incredible software for the online gaming industry. Living by the motto “Fearlessly Forward,” innovation is at the centre of everything we do, whether it’s our games, new products and technologies. We understand that great ideas come from great people, and great people thrive when they’re trusted to challenge, change, improve, and perfect our products and processes.Our strength lies in the diversity of our skills, and that comes from the diversity of our people. The Workshop is committed to being a diverse and inclusive workplace where we learn from each other, trust each other, and value collaboration. We welcome candidates of all genders, gender identity and expression, sexual orientation, disability, physical appearance, body size, race, age, nationality, belief (or lack thereof,) and programming language preference. As an equal opportunity employer, we offer a pleasant, supportive place to work – whoever you are. It’s a place where you can try new ideas, take risks, and move Fearlessly Forward.

What you'll do

As the Data Systems Engineer (MySQL) you will be part of our team and will join our expanding Information Technology Services Group.

You will be responsible for ensuring the performance, availability, and security of clusters of MySQL instances in a mixture of containerized and non-containerized environment. You will be a main point of contact for various teams (such as Software Development, Delivery and DevOps Services) for MySQL databases topics. As well as being responsible for orchestrating upgrades, backups, provisioning of database instances and day-to-day maintenance of Production and Non Production Databases.

You will:

  • Be point of reference for all questions related to MySQL instances for colleagues from various teams
  • Provision MySQL instances, both in clustered and non-clustered configurations
  • Be using company-standard tools, handle common database procedures such as upgrade, backup, recovery, migration, deployment etc.
  • Prepare quality documentation and specifications, including database design and coding standards, best practices and training materials.
  • Optimize profile server resource usage and make adjustments as needed.
  • Ensure performance, security, and availability of 24x7 mission critical databases
  • Work closely with colleagues, including Database Services and application development teams, to improve the performance of existing MySQL databases.
  • Provide 24x7 support during on-call support rotation schedule

What you'll bring

  • Demonstrated seniority and overall IT experience, including expert Linux knowledge
  • Strong interpersonal and collaboration skills
  • Consultative approach to supporting various teams
  • Systems administration experience
  • Expertise in the following
    • Strong proficiency in MySQL database management.
    • Solid experience with recent versions of MySQL 5.7 and 8
    • Understanding of MySQL’s underlying storage engines, such as InnoDB and MyISAM
    • Experience with replication configuration in MySQL
    • Experience with Percona XtraDB Cluster
    • Experience with ProxySQL
    • Experience with Puppet and Ansible configuration management tools
    • Knowledge of de-facto standards and best practices in MySQL
    • Proficient in writing and optimizing SQL statements
    • Proficient understanding of code versioning tools such as Git, SVN etc.
    • Knowledge of limitations in MySQL and their workarounds in contrast to other popular RDBMS
  • Ability to plan resource requirements from high level specifications
  • Ability to quickly learn new technologies and business functions
  • Excellent English verbal and written communication skills

It would be advantageous to have

  • Experience with other SQL/NoSQL databases such as Elastic Search, Hadoop, Cassandra, etc.
  • Experience with other configuration management tools, e.g. Terraform
  • Cloud knowledge, e.g. Google & OpenStack
  • Knowledge of *nix tuning

What's in it for you

  • Challenging and fulfilling work at an innovative, global company that uses cutting-edge tech
  • Global work experience in an agile methodology
  • International, friendly and inclusive multi-cultural environment (over 35 nationalities that speak altogether almost 30 languages!)
  • Competitive salary and relocation packages for you and your family
  • Flexibility of working from home/office to stay both safe and collaborative
  • Flexible working hours, well-being programs, learning and growth opportunities
  • Team building events, learning labs, Hackathons/Designatons 
  • Opportunity to shape the tech community inside and outside of The Workshop, mentoring and sharing knowledge with others
Usually responds within three days

Or, know someone who would be a perfect fit? Let them know!

Málaga

Calle Severo Ochoa, 16
29590 Málaga Directions View page

Our culture

We’re lucky enough to have a home in two of Europe’s best tech cities – London and Malaga – and are proud of our diversity. Our Inventors represent over 40 different nationalities and almost 30 languages.


Already working at The Workshop?

Let’s recruit together and find your next colleague.

email
@theworkshop.com
Teamtailor

Applicant tracking system by Teamtailor