SQL Developer (Database Operations) at Rockstar Games | MS SQL Server | Bangalore

RESPONSIBILITIES

• Collaborate within agile software development teams to build, develop, maintain, and improve database solutions using Microsoft SQL Server (2017 and above) 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. 
• Develop and maintain database documentation. 
• Serve as database domain specialist, 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 shown ability in developing T-SQL stored procedures, functions, views, etc.
• Expertise in building, altering, tuning, and debugging large complex stored procedures and database design with referential integrity.
• Experience with high-availability database schemas, Online Transaction Processing (OLTP), and relational data models using SQL Server.
• Advanced T-SQL DDL and DML skills, with understanding of indexes and protocols.
• Ability to resolve common database issues, with analytical skills for root cause analysis and query performance optimization.
• Knowledge of deployments and source control.
• Self-directed and independent worker, with a focus on achieving objectives with minimal supervision.
• Good problem-solving skills, adept at solving problems and optimizing database performance.

PLUSES

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

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