Senior SQL Server / SSIS Application Engineer

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

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