Database Engineer - Live Operations

Database Engineering at Riot is challenged with maintaining and developing automation to manage Riot’s fleet of cloud based databases to meet the scale and performance of all Riot’s Live Service game’s and shared services. The team aspires to become a center of excellence for shared persistent data store technologies.

As a Database Engineer you will be working on a global scope of databases servicing the breadth of services and games at Riot. You will be designing and administering solutions to help teams implement database standards you have established to make service databases easier to operate and maintain. You’ll be partnering and coordinating with engineers across Riot and ironing out overlooked details that matter most to our players. You’re right for this role if the idea of working on high impact, high visibility, high expectation projects that provide demonstrated database improvements for our players excites you. You love building iterative approaches to problems and know how to compromise between ideal solutions and practical outcomes. 

Responsibilities: 

• Configure, deploy, maintain, and optimize new and existing database infrastructure and database automation to support new and existing games and services 
• Design and implement Relational Database schema and query changes, supporting assorted service and game development teams with their database performance and application needs 
• Design and implement replication and backup technologies for critical MySQL databases 
• Design and implement routine data migrations between MySQL data sources as part of routine database consolidation, upgrades and host changes. 
• Design and implement Database level monitoring and alerting for Riot’s MySQL database stack 
• Support and debug database production issues.
• Build automation of database infrastructure and build self-service tools. 
• Be part of active 24x7 on call rotation with your team 

Required Qualifications: 

• 2+ years administration experience working with medium (and small) scale Relational databases (MySQL preferred) in a production environment 
• 2+ years administration experience working with cloud based or locally deployed database technologies (MySQL preferred) in a production environment 
• Experience with administration, maintenance, and recovery of databases 
• Experience with full database development life cycle 
• Ability to work with development teams on schema, query and database design 
• Ability to optimize Database and SQL Query performance 
• Ability to solve problems with programming scripts (python, bash, groovy, etc) 
• Proficient in writing and optimizing SQL statements ● Hands on experience with database replication 
• Associates/Bachelors Degree Computer Science, Engineering or equivalent experience. 
• Ability to go on call every 4 weeks. 

Desired Qualifications: 

• Hands on experience with AWS RDS or Aurora 
• Demonstrable Linux systems administration skills 
• Familiarity with database technology such as MySQL, MongoDB, SQL Server 
• Experience with Docker, Kubernetes and microservice application development 
• Experience programming in GoLang, Python and/or Java, Terraform, Cloudformation 
• Ability to speak Korean and English conversationally

For this role, you'll find success through craft expertise, a collaborative spirit, and decision-making that prioritizes your fellow Rioters, who are the customers of your work. Being a dedicated fan of games is not necessary for this position!

Our Perks:

Riot focuses on work/life balance, shown by our open paid time off policy and other perks such as flexible work schedules. We offer medical, dental, and life insurance, parental leave for you, your spouse/domestic partner, and children, and a 401k with company match. Check out our benefits pages for more information.

Riot Games fosters a player and workplace experience that values teamwork embodied by the Summoner's Code and Community Code. Our culture embraces differences as a strength, and our values are the guiding principles for how we approach work. We are committed to putting diversity and inclusion (D&I) at the center of everything we do, and promoting a fair and collaborative culture where Rioters treat one another with dignity and respect. We encourage you to read m