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