The Role
Designs and develops Microsoft SQL Server database objects, including schemas, tables, views, stored procedures, functions, and ETL/ELT pipelines. Tunes queries, indexes, and execution plans to meet performance SLAs; implements data quality, governance, auditing, and transactional integrity. Maintains system integrations, collaborates with application engineers and analysts, participates in reviews, and resolves production issues. Requires expert T-SQL, full software development lifecycle experience, SQL Server expertise, version control, scripting, debugging, and database development experience.
Summary Generated by Built In
Duties & Responsibilities
- 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.
- Exposure to NoSQL stores (e.g., Cosmos DB, Redis, Couchbase)
Skills Required
- Bachelor's degree or equivalent work experience
- Proficiency in SQL programming
- Expert T-SQL skills, including set-based programming, window functions, CTEs, error handling, dynamic SQL, and MERGE
- Experience with the full software development lifecycle, including design, testing, deployment, and documentation
- 8+ years designing and implementing Microsoft SQL Server database objects
- 8+ years of full software development lifecycle experience, including analysis, coding, testing, and deployment
- 8+ years of experience working with SQL Server Management Studio
- Experience with ETL/ELT using SSIS or modern alternatives and scheduling/orchestration
- 8+ years of combined experience developing solutions with relational database technologies
- Proficiency with code versioning tools such as Git
- Ability to debug complex stored procedures
- Knowledge of file transmission methods such as SFTP
- Understanding of batch command and PowerShell scripts
- Ability to understand C# code
- Exposure to NoSQL stores such as Cosmos DB, Redis, or Couchbase
Am I A Good Fit?
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.
Success! Refresh the page to see how your skills align with this role.
The Company
What We Do
Staples India is Staples’ technology and innovation hub in Chennai, building platforms, systems, and digital solutions that support the company’s global operations and future of work. Staples serves consumers and businesses with workplace products and services, including office supplies, janitorial products, technology, furniture, breakroom essentials, print and marketing, shipping, travel, and promotional offerings. Its India teams focus on engineering, eCommerce, process optimization, and enterprise solutions.
