SQL Developer Module Lead

Company 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.

• SQL Server Development:
• 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.
• SSIS Package Development:
• Design, develop, and maintain ETL (Extract, Transform, Load) processes using SSIS.
• Create, modify, and troubleshoot SSIS packages for data integration, migration, and transformation.
• Scheduling of SSIS packages.
• Production Support:
• 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.

Required Technical Skills:

• 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.

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

Total Experience Expected: 04-06 years

Qualifications

• Relevant experience in database maintenance and support.
• Strong problem-solving skills and attention to detail.
• Excellent communication and teamwork abilities.

Additional Information

• Must be willing to work in shifts and participate in on-call support as required.

At our organization, we are committed to fighting against all forms of discrimination. We foster a work environment that is inclusive and respectful of all differences.

All of our positions are open to people with disabilities.