Currently, we have a great opportunity for a MySQL Database Administrator in our Los Angeles, CA office. If you are passionate about working in a fun, fast-paced, and creatively challenging environment this is the place for you. We are looking for someone who manages time wisely, solves development and operational challenges with smart and efficient solutions, meets deadlines, and works in a self-directed manner.
Responsibilities: The MySQL Database Administrator is responsible to the organization for the integrity, availability, and confidentiality of the database systems, data, and supporting services. The DBA is the focal point and technical lead for all databases, database infrastructure, and supporting services.
Functions as primary point of support for all data layer services in production, staging, and development environments.
Participates in on-call rotation schedule for support of database services in production environments.
Acts as the technical point of contact for architectural changes and improvements to a rapidly growing, data intensive, world-class relational database environment.
Functions as the go-to resource for testing and benchmarking current and future releases of database server software and related hardware technologies.
Possesses required skills as defined by ITIL Service Delivery and Service Design roles as they apply to database operations: Level 3 support, Incident/Problem Management, Capacity/Risk/Availability Management, and Standards/Compliance Management.
Experience in designing, implementing, and managing database systems for mission critical, high-traffic OLTP and OLAP systems.
In-depth knowledge of the MySQL platform, including high-availability design/operation, performance tuning, capacity planning, automated backup and recovery.
Expertise with MySQL replication, active/passive clustering, disaster recovery, and geographic load distribution of database services.
Experience with task automation scripting using Python, Perl, Shell, or other UNIX based languages.
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.
Ability to work with and support a team of game development professionals, operations team members, and design engineers.
Excel at documenting database architectures, and processes. Follow ITIL change management best practices for system modifications.
Conceptual knowledge of service-oriented architectures.
Strong understanding of applied statistics and analytics algorithms.
Foundation knowledge and experience with baseline performance and load testing for computing system capacity planning methodology.
B.S. degree in Computer Science or equivalent experience. Must be legally authorized to work in the US.
5+ years as a database administrator.
Experience with database capacity scaling techniques such as caching, sharding, data partitioning highly desirable.
Excellent communication skills (written and oral), excellent interpersonal skills. Positive, team-oriented attitude.
Ability to liaise with vendors and other business / technical teams, able to function with minimum supervision.
Has a demonstrable interest in the game industry, and experience in working in and with Agile development teams.
Ability to conduct analysis and provide input to senior management for decision making.
Riot Games - 2 years ago