This job might no longer be available.
Database Engineer, Game Operations, TTCG (Contractor)
1 year ago
Riot Games was established in 2006 by entrepreneurial gamers who believe that player-focused game development can result in great games. In 2009, Riot released its debut title League of Legends to critical and player acclaim. As the most played video game in the world, over 100 million play every month. Players form the foundation of our community and it’s for them that we continue to evolve and improve the League of Legends experience.
We’re looking for humble but ambitious, razor-sharp professionals who can teach us a thing or two. We promise to return the favor. Like us, you take play seriously; you’re passionate about games. We embrace those who see things differently, aren’t afraid to experiment, and who have a healthy disregard for constraints.
That's where you come in.
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 large breadth of service and game architecture 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.
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:
- 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 MySQL database stack
- Support and debug database production issues
- Support HDFS based data warehouse infrastructure
- 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 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 when needed
Desired Qualifications:
- Hands on experience with AWS RDS or Aurora
- Hands on experience with Percona MySQL
- Demonstrable Linux systems administration skills
- Familiarity with database technology such as MySQL, MongoDB, SQL Server
- Familiarity with Hadoop based Datawarehouse solutions
- Experience programming in GoLang, Python, Terraform
- Ability to speak Mandarin and English conversationally
Don’t forget to include a resume and cover letter. We receive a lot of applications, but we’ll notice a fun, well-written intro that shows us you take play seriously.
Create Your Profile — Game companies can contact you with their relevant job openings.