SQL Administrator: Database Operations

Rockstar Games•Carlsbad, CA

5d•Onsite

About The Position

At Rockstar Games, we create world-class entertainment experiences. Become part of a team working on some of the most rewarding, large-scale creative projects to be found in any entertainment medium - all within an inclusive, highly-motivated environment where you can learn and collaborate with some of the most talented people in the industry. Rockstar is looking for an operational focused Microsoft SQL Server DBA who possesses a passion for monitoring, alerting, and tuning. This is a full-time, in-office position based out of Rockstar’s new state-of-the-art game development studio in Carlsbad, CA. WHAT WE DO The Rockstar Database Operations team provides operational and development support for critical platforms and services.

Requirements

5+ years of experience with Microsoft SQL Server administration and development.
Solid understanding of SQL Server internals.
Knowledge of SQL Server configuration best practices.
Extensive expertise with SQL backups and recovery.
Experience with database deployments and source control.

Nice To Haves

Passion for Rockstar Games.
Knowledge of .NET/C#.
Knowledge of SSRS and SSIS.
SQL Sentry.
Experience with database load testing.
Knowledge of Splunk searches and dashboards.
Knowledge of other database technologies.

Responsibilities

Audit server health, error logs, windows logs, and application performance to take corrective actions if needed.
Implement HA-DR solutions in tandem with architects and SQL developers using multi-data center best practices.
Strong knowledge of SQL Server internals to troubleshoot database performance problems.
Automate day-to-day tasks to increase team productivity.
Setup and configure SQL Server installations according to best practices.
Routine patching and upgrading SQL Server installations and FCI clusters.
Tune and configure SQL backups to maintain RTO and RPO targets.
Participate in 24/7 operations via on call rotation schedule.
Document processes and procedures.
Provide guidance to SQL developers or architects as needed.