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 more about our value of thriving together and our ongoing work to build the most inclusive company in Gaming.

It’s our policy to provide equal employment opportunity for all applicants and members of Riot Games, Inc. Riot Games makes reasonable accommodations for handicapped and disabled Rioters and does not unlawfully discriminate on the basis of race, color, religion, sex, sexual orientation, gender identity or expression, national origin, age, handicap, veteran status, marital status, criminal history, or any other category protected by applicable federal and state law. We consider for employment all qualified applicants, including those with criminal histories, in a manner consistent with applicable federal, state and local law, including the California Fair Chance Act, the City of Los Angeles Fair Chance Initiative for Hiring Ordinance, the Los Angeles County Fair Chance Ordinance for Employers, the San Francisco Fair Chance Ordinance, and the Washington Fair Chance Act.

Per the Los Angeles County Fair Chance Ordinance, the following core duties may create a basis for disqualifying candidates with relevant criminal histories:

Safeguarding confidential and sensitive Company data
Communication with others, including Rioters and third parties such as vendors, and/or players, including minors
Accessing Company assets, secure digital systems, and networks
Ensuring a safe interactive environment for players and other Rioters

These duties are directly related to essential operations, safety, trust, and compliance obligations within our organization. Please note that job duties may evolve based on business needs and additional responsibilities may be assigned as necessary to maintain operational efficiency and security.