Senior Software Engineer - MS SQL Developer

Scientific Games Scientific Games is the global leader in lottery games, sports betting and technology, and the partner of choice for government lotteries. From cutting-edge backend systems to exciting entertainment experiences and trailblazing retail and digital solutions, we elevate play every day. We push game designs to the next level and are pioneers in data analytics and iLottery. Built on a foundation of trusted partnerships, Scientific Games combines relentless innovation, legendary performance, and unwavering security to responsibly propel the global lottery industry ever forward.

Position Summary Job Description SQL Developer

Experience: 3 to 7 years

Location: Bangalore

Type: Full-time

About The Role Looking for a strong SQL developer who can also work across the Microsoft stack. 80% of work will be deep in MS SQL Server – writing, tuning, debugging complex queries. The other 20% maintain/enhance legacy ASP/VB.NET apps and build new features in C# + JavaScript.

Key Responsibilities SQL Server Development - Primary - 80%

Write, optimize, and debug complex T-SQL stored procedures, functions, views, triggers

Tune slow queries using Execution Plans, Indexes, DMVs. Handle tables with 10M+ rows

Design database tables, relationships, and constraints for new modules

Data migration, cleansing, and bulk operations using SSIS packages

Troubleshoot deadlocks, blocking, timeouts, and performance issues in production

Application Development - Secondary - 20%

Maintain and enhance existing Classic ASP / http://VB.NET / VB6 web applications

Develop new features in C# .NET Framework/.NET Core with ADO.NET/Entity Framework

Create/modify SSRS reports – datasets, parameters, subscriptions, drill-down reports

Build UI screens using HTML, CSS, JavaScript, jQuery. Handle AJAX calls to backend

Fix bugs across the stack – from SQL proc to JS front-end

Support & Collaboration Work with BAs to translate business requirements into SQL queries + reports

Deploy DB objects and code via SQL scripts + TFS/Azure DevOps/Git

Support UAT, provide data extracts, and resolve production data issues

Document stored procs, table schemas, and report logic

Must-Have Skills Strong SQL Knowledge

3+ years hands-on with MS SQL Server 2014+

Advanced T-SQL: Joins, CTEs, window functions, temp tables, dynamic SQL, error handling

Performance: Can read execution plans, create covering indexes, avoid cursors, reduce scans

SSIS/SSRS: Built/modified packages and paginated reports. Know SQL Agent jobs

DB Objects: Comfortable with all CRUD operations, schema design, constraints, transactions

Moderate Application Skills Classic ASP / VB / http://VB.NET: Can read legacy code, fix bugs, add small features. No need to architect

C# .NET: Write console apps, APIs, or web forms. Understand OOP, ADO.NET, basic LINQ

JavaScript/jQuery: DOM manipulation, AJAX calls, form validations, JSON handling

HTML/CSS: Create tables, forms, basic responsive layouts

Tools: Visual Studio, SSMS, IIS basics, TFS/Git for version control

Qualifications Education Bachelors degree in related field.

Years Of Related Experience Years of experience 5 to 8 years

Physical Requirements The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. While performing the duties of this job, the employee is regularly required to sit, stand, walk, bend, use hands, operate a computer, and have specific vision abilities to include close and distance vision, and ability to adjust focus working with computer and business equipment.

Work Conditions Scientific Games, LLC and its affiliates (collectively, “SG”) are engaged in highly regulated gaming and lottery businesses. As a result, certain SG employees may, among other things, be required to obtain a gaming or other license(s), undergo background investigations or security checks, or meet certain standards dictated by law, regulation or contracts. In order to ensure SG complies with its regulatory and contractual commitments, as a condition to hiring and continuing to employ its employee…