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. Over 11 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.
The goal of Riot Games' Big Data team is to turn data into information and information into actionable insights. Millions of League of Legends players continue to rack up billions of hours of play -- all of it logged, all of the logs frankly rather useless until our lab-coated Big Data scientists work their black magics, transmogrifying unwieldy petabytes through the careful application of open-source and proprietary technologies and bucketloads of intellectual elbow grease.
That’s where you come in.
As Database Administrator, you’ll provide administration and support for all database infrastructure, ensuring the stability, security and accessibility of player data to help Riot Games better understand and improve the player experience.
Educated: you earned a BS in Computer Science or have the equivalent experience; you possess conceptual knowledge of service-oriented architectures and a strong understanding of applied statistics and analytics algorithms
Experienced: over the years, you’ve earned scars and stripes designing, implementing and managing database systems for mission critical, large-scale applications; you’re pro at baseline performance and load testing for capacity planning, preferably with some experience with database capacity scaling techniques
Agile: you are familiar with agile software development processes and likely have experience practices like continuous integration and test-driven deployment
Data-driven: you’re an expert in the MySQL platform, including high-availability design and operation, performance tuning, capacity planning, automated backup and recovery and you’ve mastered MySQL replication, active/passive clustering, disaster recovery and geographic load distribution of database services; your premium-grade MySQL skills are complemented by an expertise in data warehouse technologies, including MPP databases and experience with multiple relational databases and NoSQL products
Up to code: you bring experience with task automation scripting using Python, Perl, Shell or other UNIX based languages
A problem assassin: you conduct problem reconnaissance and termination with the skill and ruthlessness of Bond; you possess systems administration skills required to troubleshoot database-related problems at the O/S level, on Linux/UNIX/Solaris and commercially available server and storage systems
A communications black belt: you excel at interpreting teams’ implied needs to offer useful guidance and so you communicate easily in the most appropriate medium, be it email, hallway conversation, sneakernet or messenger pigeon; you’re comfortable collaborating with any specialty of Rioter including business analysts, engineers and operations personnel
Player-focused: as a gamer yourself, you know the importance of listening to player needs, especially the implicit needs that can only be uncovered by analyzing and understanding player data
Function as the primary point of administration and support for all database infrastructure in the data warehouse and data services environments
Ensure the integrity, availability and confidentiality of data, database systems and supporting services
Optimize performance of database and data warehouse infrastructure
Work with analysts and engineers to ensure adherence to best practices and data standards
Act as the technical point of contact for architectural changes and improvements to a world-class data and analytics infrastructure
Help support and optimize a global ETL infrastructure
Test and benchmark current and future releases of database server software and related hardware technologies
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.
Riot is a company of gamers who have fallen in love with DotA and want to take the experience to the next level. We believe that League of...