Senior Data Engineer - MS SQL Developer

Staples India; Chennai District; On-site; INR 2,500,000 - 4,500,000; Full time

Job summary

Staples India Business Innovation Hub Private Limited in Chennai seeks a senior MS SQL Server professional to design, implement, and optimize database solutions. The role emphasizes building robust schemas, ETL pipelines, and strong data governance to meet SLA requirements.

With 8+ years of experience, you will own performance tuning, code reviews, and production support while collaborating with engineers and analytics teams to deliver scalable, reliable data platforms across the enterprise.

Qualifications

• Bachelor’s degree or equivalent work experience.
• Proficient in SQL programming.
• Expert TSQL skills (set-based programming, window functions, CTEs, error handling, dynamic SQL, MERGE).
• Experience with the full software development lifecycle, including design, testing, deployment, and documentation activities.
• 8+ years of experience designing and implementing MS SQL Server database objects.
• 8+ years of full software development lifecycle experience, including independent analysis, coding, testing, and deployment.
• 8+ years of experience working with SQL Management Studio.
• Experience with ETL/ELT (SSIS or modern alternatives) and scheduling/orchestration.
• 8+ years of combined experience developing solutions with relational database technologies.
• Proficient understanding of code versioning tools, such as Git.
• Ability to debug complex stored procedures.
• Knowledge of file transmission methods such as SFTP.
• Understanding of batch command /PowerShell scripts.

Responsibilities

• Design & develop robust schemas, tables, views, stored procedures, functions, and ETL/ELT pipelines in SQL Server.
• Profile and tune queries, indexes, and execution plans to meet SLAs.
• Improve performance and reliability of data processes.
• Ensure data quality, governance, constraints, validation, and auditing.
• Build and maintain integrations with upstream/downstream systems; ensure transactional integrity.
• Collaborate with application engineers and analysts to translate requirements into scalable database solutions; participate in code/design reviews.
• Respond promptly to production issues and outages.

Skills

T-SQL

Performance tuning

Data governance

SQL Server security

Batch scripting

Education

Bachelor’s degree or equivalent

Tools

MS SQL Server

SSIS

Git

PowerShell

ETL/ELT

Job description

Staples India Business Innovation Hub Private Limited | Permanent

• Design & development: Build robust schemas, tables, views, stored procedures, functions, and ETL/ELT pipelines in Microsoft SQL Server (Azure SQL, Managed Instance).
  
• Performance & reliability: Profile and tune queries, indexes, and execution plans;
  
• come up with solutions to improve the performance to meet SLAs.
  
• Data quality & governance: Implement constraints, validation, and auditing; contribute to data standards, naming conventions, and documentation.
  
• Integration: Build and maintain integrations with upstream/downstream systems and ensure transactional integrity.
  
• Collaboration: Work with application engineers and analysts to translate requirements into scalable database solutions; participate in code/design reviews.
  
• Support: Respond to any production issues with urgency.
  

Requirements

Basic Qualifications

• Bachelor’s degree or equivalent work experience.
  
• Proficient in SQL programming.
  
• Expert TSQL skills (set-based programming, window functions, CTEs, error handling, dynamic SQL, MERGE).
  
• Experience with the full software development lifecycle, including design, testing, deployment, and documentation activities.
  
• 8+ years of experience designing and implementing MS SQL Server database objects.
  
• 8+ years of full software development lifecycle experience, including independent analysis, coding, testing, and deployment.
  
• 8+ years of experience working with SQL Management Studio.
  
• Experience with ETL/ELT (SSIS or modern alternatives) and scheduling/orchestration.
  
• 8+ years of combined experience developing solutions with relational database technologies.
  
• Proficient understanding of code versioning tools, such as Git.
  
• Ability to debug complex stored procedures.
  
• Knowledge of file transmission methods such as SFTP.
  
• Understanding of batch command /PowerShell scripts.
  

Preferred Qualifications

• Ability to understand C# code.