Senior Software Engineer - MS SQL Developer

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 / VB / VB.NET 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 / 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

Qualifications

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

As a prerequisite to employment with SG (to the extent permitted by law), you shall be asked to consent to SG conducting a due diligence/background investigation on you.

This job description should not be interpreted as all-inclusive; it is intended to identify major responsibilities and requirements of the job. The employee in this position may be requested to perform other job-related tasks and responsibilities than those stated above.

Disclaimer : This job posting has been aggregated from external source. Role details, content, and availability are subject to change. Applicants are advised to confirm the latest information directly on the company website before applying.