Microsoft SQL Server Developer

Posted:
7/24/2024, 9:09:54 AM

Location(s):
Andover, Massachusetts, United States ⋅ Massachusetts, United States

Experience Level(s):
Senior

Field(s):
IT & Security

At Rockstar Games, we create world-class entertainment experiences.

A career at Rockstar Games is about being part of a team working on some of the most creatively rewarding and ambitious projects to be found in any entertainment medium. You would be welcomed to a dedicated and inclusive 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 newly renovated game development studio in Andover, MA. 

WHAT WE DO

  • 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.

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.

QUALIFICATIONS

  • 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). 

SKILLS

  • 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.

PLUSES

Please note that these are desirable skills and are not required to apply for the position.

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

HOW TO APPLY

Please apply with a resume and cover letter demonstrating how you meet the skills above. If we would like to move forward with your application, a Rockstar recruiter will reach out to you to explain next steps and guide you through the process.

Rockstar is committed to creating a work environment that promotes equal opportunity, dignity and respect. In line with this commitment, Rockstar will provide reasonable accommodations to qualified job applicants with disabilities during the recruitment process in order for such applicants to be considered for the position for which they are applying, as well as to qualified employees to enable them to perform the essential functions of their roles. If you need more information about Rockstar’s reasonable accommodation policies or process, or need to request an accommodation, please contact the Human Resources Department.                                   

If you’ve got the right skills for the job, we want to hear from you. We encourage applications from all suitable candidates regardless of age, disability, gender identity, sexual orientation, religion, belief, race, or any other protected category.