Reporting to the Technical Director on the project and collaborating with other programmers on the Digital Infrastructure team, the Database Administrator is focused on the implementation, performance and scalability of back-end database systems necessary to operate a game service.
Participate in architecture, design, implementation and integration of database systems with overall game platform and client.
Tune database performance and optimize queries.
Closely collaborate with gameplay team to support and align development of database systems with game client.
Design and develop analytics services that gather, move and process large amounts of data efficiently and quickly.
Implement, integrate and maintain automated ETL processes between telemetry sources and analytics tools.
Gather and analyze requirements, formulate tasks and provide estimates, communicate risks and propose solutions.
Work with Technical Director and Project Manager to plan and schedule releases.
2+ years of experience building web server applications and database systems, focused particularly on performance and scalability.
Experience building database access layers.
Experience implementing scalability and performance optimizations including: database design, sharding, clustering and replication, as well as experience with HTTP caching technologies such as Squid.
2+ years of experience designing ETL processes and data wrangling on a scalable platform.
Experience with real-time or near real-time analytics and data extraction.
Knowledgeable in the following database technologies: Postgres, Redis. Other RDBMS a bonus (Oracle, SQL Server, MySQL).
Knowledge of C# or Node.js a bonus.