Ms Sql Server Developer

SG Lottery India; Bengaluru; Hybrid; INR 700,000 - 1,100,000; Full time

Job summary

SG Lottery India in Bengaluru is seeking a SQL Developer / Full-Stack Developer with a SQL-heavy focus. The role emphasizes MS SQL Server work—writing, tuning, and debugging complex queries—while collaborating across the Microsoft stack.

You will design schemas, migrate data with SSIS, optimize performance with execution plans and indexes, and handle production data issues. Strong debugging and documentation skills are essential.

Qualifications

• Experience with MS SQL Server 2014+ and complex queries.
• Proficient in writing and tuning T-SQL, stored procedures, functions, views and triggers.
• Experience with data migration, SSIS packages, and paginated reports.
• Ability to read execution plans and optimize performance using indexes.
• Familiar with SQL Server administration and debugging techniques.

Responsibilities

• SQL Server Development – primary focus (80%), writing, tuning, and debugging complex T-SQL objects.
• Design database schemas, tables, relationships, and constraints for new modules.
• Data migration and cleansing using SSIS; bulk operations and performance tuning.
• Troubleshoot deadlocks, blocking, timeouts, and production issues; document procedures.
• Collaborate with BAs to translate requirements into SQL queries and reports; deploy DB objects via scripts and version control.
• Support UAT, provide data extracts, and resolve production data issues; maintain documentation of schemas and logic.

Skills

Strong SQL

MS SQL 2014+

Advanced T-SQL

Execution Plans

Indexes

SSIS/SSRS

Tools

Visual Studio

SSMS

IIS basics

TFS/Git

Job description

Job Description: SQL Developer / Full-Stack Developer - SQL Heavy

Role: Developer SQL
Experience: 2 to 4 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.

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

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
• 2+ 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

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