Senior MS SQL Developer

Role: Developer SQL

Experience: 5 to 9 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

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

Must-Have Skills

Strong SQL Knowledge

4+ 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