Skip to main content
Loading
loadingbar
Loading, Please wait..!!

Senior Sql Server Ssis Application Engineer

  • Senior Sql Server Ssis Application Engineer job type Posted on: Nov 06, 2026
  • Senior Sql Server Ssis Application Engineer experience level VDart Inc
  • Senior Sql Server Ssis Application Engineer employment type Milwaukee, Wisconsin
  • Senior Sql Server Ssis Application Engineer employment type Onsite
  • Senior Sql Server Ssis Application Engineer salary CTC

Point Apply Here APPLY LATER

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 →

Job Title :

Senior Sql Server Ssis Application Engineer

Job Type :

Contract

Job Location :

Milwaukee Wisconsin United States

Remote :

No

Jobcon Logo 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.

Jobcon Logo Position Details

Posted:

Nov 06, 2026

Reference Number:

102331-5195

Employment:

CTC

City:

Milwaukee

Job Origin:

CIEPAL_ORGANIC_FEED

Share this job:

  • linkedin

Jobcon Logo
A job sourcing event
In Dallas Fort Worth
Aug 19, 2017 9am-6pm
All job seekers welcome!

Senior Sql Server Ssis Application Engineer    Apply

Click on the below icons to share this job to Linkedin, Twitter!

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.

Loading
Please wait..!!