Lead MS SQL Developer

Staples India; Chennai District; On-site; INR 800,000 - 1,200,000; Full time

Job summary

Staples India is seeking an experienced Senior SQL Server Database Engineer to design, optimize, and support enterprise-scale database solutions. The candidate should have strong expertise in TSQL, SQL Server performance tuning, and ETL/ELT processes.

The role involves working closely with application teams, managing integrations, and ensuring database performance meets SLAs. Applicants should possess extensive experience with Microsoft SQL Server and Azure SQL environments.

Qualifications

• Proficient in Microsoft SQL Server, Azure SQL and TSQL.
• Experience in developing stored procedures, functions, and views.
• Strong abilities in performance tuning and query optimization.

Responsibilities

• Design and maintain SQL Server schemas and tables.
• Build and support ETL/ELT pipelines using SSIS.
• Manage integrations for transactional integrity.
• Provide production support and resolve critical issues.

Skills

Microsoft SQL Server

Azure SQL Database / Managed Instance

Advanced TSQL

Stored Procedures, Functions, Views

Performance Tuning & Query Optimization

Indexing & Execution Plans

ETL / ELT, SSIS

SQL Server Management Studio (SSMS)

Git / Version Control

Production Support

Job description

Job Description

We are looking for an experienced Senior SQL Server Database Engineer with strong expertise in TSQL, SQL Server performance tuning, ETL/ELT, and Azure SQL environments. The candidate will be responsible for designing, developing, optimizing, and supporting enterprise scale database solutions with high availability and performance.

Roles & Responsibilities

• Design, develop, and maintain SQL Server schemas, tables, views, stored procedures, and functions
• Build and support ETL/ELT pipelines using SSIS or modern integration tools
• Perform query optimization, index tuning, execution plan analysis, and performance troubleshooting
• Ensure database performance meets defined SLAs
• Implement data validation, constraints, auditing, and governance standards
• Manage integrations with upstream and downstream systems ensuring transactional integrity
• Work closely with application teams and analysts to deliver scalable database solutions
• Participate in code reviews and design reviews
• Provide production support and resolve critical issues promptly

Key Skills

Mandatory Skills

• Microsoft SQL Server
• Azure SQL Database / Managed Instance
• Advanced TSQL
• Stored Procedures, Functions, Views
• Performance Tuning & Query Optimization
• Indexing & Execution Plans
• ETL / ELT, SSIS
• SQL Server Management Studio (SSMS)
• Git / Version Control
• Production Support

Additional Skills

• Dynamic SQL, CTEs, Window Functions
• MERGE, Error Handling (TRY/CATCH)
• SFTP, File Transfers
• PowerShell / Batch scripting
• Full SDLC experience

Preferred Skills

• Understanding of C# code
• Exposure to NoSQL databases (Cosmos DB, Redis, Couchbase)