Tech Consultant - SQL Server Integration Services (SSIS)

NTT DATA's Client is seeking an experienced, hands-on SQL Server / SSIS Application Engineer to support mission-critical production processes built primarily on Microsoft SQL Server, T-SQL stored procedures, SSIS, and related SQL Server technologies. The contractor will analyze existing production workloads, diagnose failures and performance issues, optimize complex SQL and ETL processes, and improve the reliability, maintainability, and operational supportability of critical business processes.

Job Description:

• Job Title: Tech Consultant - SQL Server Integration Services
• Location: Charlotte or Minneapolis, hybrid – 3 days work from office
• Experience: 5+ Years
• NTT DATA's Client is seeking an experienced, hands-on SQL Server / SSIS Application Engineer to support mission-critical production processes built primarily on Microsoft SQL Server, T-SQL stored procedures, SSIS, and related SQL Server technologies.
• The contractor will analyze existing production workloads, diagnose failures and performance issues, optimize complex SQL and ETL processes, and improve the reliability, maintainability, and operational supportability of critical business processes.

Key Responsibilities

• Troubleshoot and resolve production issues involving complex T-SQL stored procedures, SSIS packages, SQL Agent jobs, and batch processes.
• Analyze slow-running or unstable SQL workloads and identify root causes.
• Optimize stored procedures, queries, indexes, execution plans, temp-table usage, locking, blocking, and transaction handling.
• Debug and optimize SSIS packages, including data flows, control flows, transformations, error handling, restart/recovery, and performance.
• Diagnose dependencies and failures across multi-step batch and ETL workflows.
• Perform root-cause analysis of recurring production incidents and implement durable fixes rather than short-term workarounds.
• Improve logging, monitoring, exception handling, reconciliation, and operational supportability.
• Refactor legacy SQL and SSIS components where necessary while preserving critical business functionality.
• Partner with application developers, DBAs, infrastructure teams, and business SMEs to understand and improve existing processes.
• Document process flows, dependencies, failure points, recovery procedures, and technical improvements.

Required Skills

• Advanced T-SQL development, including complex stored procedures, functions, views, CTEs, temporary tables, and transaction management.
• Extensive experience debugging and optimizing Microsoft SQL Server production workloads.
• Strong knowledge of SQL Server execution plans, indexing strategies, query optimization, statistics, locking, blocking, and deadlocks.
• Extensive hands-on experience with SQL Server Integration Services (SSIS).
• Experience troubleshooting SQL Agent jobs, batch processing, ETL pipelines, and complex process dependencies.
• Ability to analyze unfamiliar legacy code and quickly understand complex business processing logic.
• Strong production troubleshooting and root-cause-analysis skills.
• Experience supporting high-volume, mission-critical production systems where processing accuracy and recoverability are essential.

Preferred Skills

• PowerShell and automation experience.
• SQL Server Profiler, Extended Events, Query Store, and other SQL Server diagnostic tools.
• Experience with very large databases and high-volume batch processing.
• Performance tuning of ETL and data-intensive applications.
• Git and Azure DevOps experience.
• Experience supporting financial processing, reconciliation, settlement, billing, payments, rebates, or other calculation-intensive applications.
• Experience working within production change-management and incident-management processes in a regulated financial institution.

About NTT DATA:

NTT DATA is a $30 billion trusted global innovator of business and technology services. We serve 75% of the Fortune Global 100 and are committed to helping clients innovate, optimize and transform for long term success. As a Global Top Employer, we have diverse experts in more than 50 countries and a robust partner ecosystem of established and start-up companies. Our services include business and technology consulting, data and artificial intelligence, industry solutions, as well as the development, implementation and management of applications, infrastructure and connectivity. We are one of the leading providers of digital and AI infrastructure in the world. NTT DATA is a part of NTT Group, which invests over $3.6 billion each year in R&D to help organizations and society move confidently and sustainably into the digital future. Visit us at us.nttdata.com


NTT DATA endeavors to make https://us.nttdata.com accessible to any and all users. If you would like to contact us regarding the accessibility of our website or need assistance completing the application process, please contact us at https://us.nttdata.com/en/contact-us. This contact information is for accommodation requests only and cannot be used to inquire about the status of applications. NTT DATA is an equal opportunity employer. Qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability or protected veteran status. For our EEO Policy Statement, please click here. If you'd like more information on your EEO rights under the law, please click here. For Pay Transparency information, please click here.