SQL Developer Module Lead, Sopra Steria

Sopra Steria

Location:
India, Chennai

Category:
IT - Software Development

Contract Type:
Employment contract

Salary:

Not provided

Save Job

Apply Position

Job Description:

We are looking for an experienced SSIS and MS SQL Developer to design, develop, and support SQL Server databases and SSIS packages. The role involves working on development projects and providing production support to ensure smooth database operations and optimal performance.

Job Responsibility:

Design and develop complex T-SQL queries, stored procedures, views, functions, and triggers
Optimize database queries for improved performance and efficiency
Develop scripts for data migration, import/export, and transformation tasks
Design, develop, and maintain ETL processes using SSIS
Create, modify, and troubleshoot SSIS packages for data integration, migration, and transformation
Monitor and support production databases to ensure high availability and performance
Troubleshoot and resolve database-related issues in production environments
Identify and optimize long-running queries, deadlocks, and other performance bottlenecks
Provide 24/7 production support as part of an on-call rotation for critical issues
Perform root cause analysis and provide resolutions for database incidents and outages

Requirements:

Hands-on experience with MS SQL Server
Proficiency in T-SQL programming (queries, stored procedures, functions, triggers)
Strong experience with SQL Server Integration Services (SSIS) for ETL processes
Experience in query optimization, indexing, and performance tuning
Relevant experience in database maintenance and support
Strong problem-solving skills and attention to detail
Excellent communication and teamwork abilities

Nice to have:

Knowledge or work experience in SSRS
Knowledge or work experience in C#.net/Java
Knowledge or work experience in Python
Knowledge or work experience in Zendesk
Knowledge or work experience in JIRA
Knowledge or work experience in BizTalk
Knowledge or work experience in RTI
Knowledge or work experience in Jenkins
Knowledge or work experience in Splunk
Knowledge or work experience in CICD
Knowledge or work experience in New Relic
Knowledge or work experience in Autosys scheduler
Knowledge or work experience in CA7 scheduler

What we offer:

Inclusive and respectful work environment
Commitment to fighting against discrimination
Open to people with disabilities

Additional Information:

Job Posted:
June 26, 2025

Employment Type:

Fulltime

Work Type:

Hybrid work

View All Jobs In This Company

Job Link Share:

SQL Developer Module Lead