Loading, Please wait..!!
Senior Sql Server Ssis Application Engineer
-
Posted on: Nov 06, 2026
-
Milwaukee, Wisconsin
-
Onsite
-
CTC
Curious about compensation?
Explore the historical salary trends, average pay, and estimated compensation for Senior Sql Server Ssis Application Engineer roles in Wisconsin.
View Salary Guide →Find your match !
Job Title :
Senior Sql Server Ssis Application Engineer
Job Type :
Contract
Job Location :
Milwaukee Wisconsin United States
Remote :
No
Job Description :
Role: Senior SQL Server / SSIS Application Engineer
Work Location: Minnesota, MN or Milwaukee, WI (Onsite)
Type: Contract
Role Summary
- We are 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.
- Ideal Candidate
- A senior engineer who is comfortable being handed a complex, poorly documented production process and answering:
- "Why is this failing or running slowly, what is the root cause, and how do we fix it without introducing unacceptable production risk?"
- The ideal candidate combines deep T-SQL and SSIS development expertise with strong production troubleshooting, performance engineering, and legacy-system analysis skills.
Position Details
Posted:
Nov 06, 2026
Reference Number:
102331-5195
Employment:
CTC
City:
Milwaukee
Job Origin:
CIEPAL_ORGANIC_FEED
Share this job:
Please wait..!!

