Database Engineer (Contractor)

Database Engineering at Riot is challenged with administration, developing and scaling Riot database capabilities to meet the scale and performance of all of 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:

• Respond to on-call / customer / emergent work relating to database deployments and maintenances
• Configure, deploy, maintain, and optimize new and existing database infrastructure to support new and existing games and services
• Design and implement routine data migrations between MySQL data sources as part of routine database consolidation, upgrades and host changes
• Design and implement replication and backup technologies for critical MySQL databases
• Design and implement Database level monitoring and alerting for Riot’s MySQL database stack
• 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 automation to manage Riot’s database infrastructure

Required Qualifications:

• 3+ years database administration experience working with cloud based and locally deployed MySQL technologies
• 4+ years database administration experience working with large scale Relational MySQL databases
• Experience with full database development life cycle
• Proven ability to administrate, maintain, and recover MySQL databases
• Proven ability to design and implement automated data migrations using replication, code and business logic between data systems
• Proven ability to work with development teams and service code on schema, query and database design
• Ability to optimize Database and SQL Query performance
• Ability to solve problems with programming scripts (python, bash etc)
• Ability to implement solutions through automation
• Proven experience using monitoring and alerting tools to determine health of your database ecosystem.
• Bachelor's Degree Computer Science, Engineering or equivalent experience.
• Must speak English conversationally

Desired Qualifications:

• Hands on experience with AWS RDS or Aurora
• Experience with Docker, Kubernetes and microservice application developmentLinux systems administration skills (operate the database and the infrastructure)
• Experience programming in GoLang, Python and/or Java