> Markdown version of [/jobs/ext/4650121-senior-sql-server-ssis-application-engineer](https://www.wearedevelopers.com/jobs/ext/4650121-senior-sql-server-ssis-application-engineer). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md).

---

# Senior SQL Server / SSIS Application Engineer

- **Company:** VDart, Inc.
- **Location:** Milwaukee, WI, United States
- **Experience:** Expert
- **Contract:** Temporary contract
- **Skills:** Microsoft Azure, Batch Processing, Big Data, Profiling, Extract Transform Load (ETL), Software Debugging, Disaster Recovery, Systems Analysis, Microsoft SQL Server, Performance Tuning, Windows PowerShell, Query Optimization, SQL Stored Procedures, SQL Databases, SQL Server Agent, SQL Server Integration Services, Data Streaming, Transact-SQL, Data Logging, Diagnostic Tools, Database Optimization, Git, Code Restructuring
- **Published:** November 9, 2026
- **Apply:** https://www.careerjet.com/jobad/us431a9bac0953198441a64fbd792a275a

## About the Role

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

## Description

* 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., * 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.