Microsoft SQL Server Developer

$101,100 - $101,100/Yr

Rockstar - Carlsbad, CA

Full-time - Mid Level

Carlsbad, CA

Insurance Carriers and Related Activities

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 a Microsoft SQL Server Developer who possesses a passion for database development and optimization. This is a full-time, in-office position based out of Rockstar's new state-of-the-art game development studio in Carlsbad, CA. The Rockstar Games Online Services Team is a passionate development group, focused on growing and maintaining the technology platform that powers Rockstar's online titles and our ability to deliver world-class player experiences. The Rockstar Database team provides development and operational support for critical platforms and services. As a Microsoft SQL Server Developer, you will work directly as part of agile software engineering teams to design, develop, maintain, and enhance database solutions using Microsoft SQL Server (2016 and up) for all of Rockstar Game's products. You will conduct periodic evaluations of existing T-SQL queries to identify issues and implement changes to increase query performance, create and maintain database documentation, and serve as a database subject matter expert to internal teams on the structure and content of relational databases. Additionally, you will work with Builds Engineering teams to improve database deployment automation and participate in a rotating on-call schedule to support database operations.

Responsibilities

• Work directly as part of agile software engineering teams to design, develop, maintain, and enhance database solutions using Microsoft SQL Server (2016 and up) for all of Rockstar Game's products.
• Conduct periodic evaluations of existing T-SQL queries to identify issues and implement changes to increase query performance.
• Create and maintain database documentation.
• Serve as database subject matter expert, to internal teams, on the structure and content of relational databases.
• Work with Builds Engineering teams to improve database deployment automation.
• Participate in rotating on-call schedule to support database operations.

Requirements

• 5+ years of experience developing in T-SQL stored procedures, functions, views etc.
• Experience creating, altering, tuning and debugging large complex stored procedures.
• Experience with database design including referential integrity.
• Experience designing large, high transaction, high availability database schemas.
• Experience working with Online Transaction Processing (OLTP).
• Advanced T-SQL DDL and DML skills.
• Strong knowledge of different types of indexes and best practices applying them.
• Experience with practical application of best practices with relational data modelling using SQL Server.
• Ability to troubleshoot common database issues.
• Adept at solving complex problems, strong analytical skills, and conduct root cause analysis on query performance issues.
• Knowledge of deployments and source control.
• Highly motivated and self-directed; independent worker, self-starter, ability to work without direct supervision.

Nice-to-haves

• Knowledge of .NET/C#.
• Knowledge of NoSQL and big data technologies.
• Knowledge of SQL Server internals.
• Previous experience in a CI/CD environment.

Benefits

• Full range of medical benefits
• Financial benefits
• Bonus and/or equity awards
• Reasonable accommodations for qualified job applicants with disabilities
• Equal opportunity work environment