Database Administrator (DBA) (offline)

The customer of Particles Global is looking for a Database Administrator (DBA) for a long term project.

The Customer is HQ in the UK, London, and operates in the Computer Games industry, it is one of the world's largest mobile game studios, with global presence.

 

Candidates should be worked in EST.

 

As a member of the Platform Reliability Team, you will spend most of your time improving database performance, scalability, and reliability as well as delivering database services and best practices to our internal customers who range from, architecture, and data scientists to software engineers.

Our primary database platform is MySQL which is critical to the running of the business and as such we require a database administrator with a

high level of expertise in MySQL.

 

Functional Responsibilities:

- Seek to be constantly improving and moving forward the database

environments;

- Provide consistent and successful partnerships between Architecture,

Development and Data Science;

- Improve processes to make your function more effective;

- Proactively identify database performance problems and resolve them by proposing and delivering changes to the codebase. Own this process end-to-end, from triaging issues to verifying your solution in production;

- Deliver changes that allow us to scale our games and their database and make sure we're prepared for data growth;

- Act as a database maintainer for the Customer codebase and review

database-related application changes before they are released;

-Providing database expertise to our architects, engineering and data science teams through code reviews, pairing and training to help deliver secure and performant database designs and queries;

- Review, optimize and refactor the existing database schema;

- Create and improve documentation;

- Database security best practices;

- Database best practices;

- Workflows and team processes;

- Long term scalability and architecture planning;

- Improve tooling to detect performance bottlenecks and security issues, early in the development cycle;

- Participate in the incident management processes to ensure reliability goals (SLOs) are met by working with the Platform Reliability Team.

 

Requirements:

- Significant experience in using MySQL for mission-critical applications;

- In-depth knowledge of MySQL backup/recovery and replication;

- It would be desirable to have a knowledge of MySQL clustering technologies like Galera Cluster;

- SQL and query optimising techniques with a demonstrable ability to both diagnose and prevent performance problems;

- Assist the development teams with database design and schema modifications;

- Expert understanding of high-performance MySQL (50k QPS);

- Working knowledge of PostgreSQL, Redis, MongoDB, Snowflake and Clickhouse;

- Core skills and attributes;

- Customer focussed;

- Thrive in a highly collaborative and fast-paced organisation that has office-based,distributed teams and individuals;

- Proficiency in the English language, both written and verbal, sufficient for success in a remote workplace;

- You are a good Linux admin;

- Bonus points if you have knowledge of:

- GCP (We are GCP focussed) or AWS data products and services;

- Ansible;

- Helm;

- Terraform;

- Commercial experience of working in a regulated environment, such as gaming or PCI-DSS.

 

Interview process:

1. Initial 30 minute call with the customer.

2. 60 minute final technical call with the customer.