Seeking a seasoned Support Tech Lead with 7-9 years of extensive experience in SSIS and SQL Server. This crucial role involves overseeing, optimizing, and resolving issues within our core database and data integration systems. You will guide a dedicated team of support and database engineers, take charge of high-priority production incidents, fine-tune performance of complex queries, and ensure the continuous availability of our MS SQL Server and SSIS infrastructure.

Lead the comprehensive management of production support and incident response for SQL Server databases, jobs, and SSIS packages.

Optimize ETL processes by monitoring, analyzing, and enhancing SSIS package performance, error handling, and logging.

Conduct in-depth analysis and tuning of T-SQL queries, stored procedures, indexes, and execution plans to minimize server load and improve responsiveness.

Provide technical direction and mentorship to junior engineers, conduct thorough code reviews, and champion the adoption of best operational practices.

Develop and implement proactive maintenance strategies, including index rebuilding, backup/restore procedures, and automation using scripting languages.

A minimum of 7 to 9 years in IT, with over 4 years focused on MS SQL Server administration/development and SSIS production support.

Demonstrated deep expertise in T-SQL, stored procedures, triggers, indexing strategies, and performance tuning.

Advanced capabilities in designing, deploying, and troubleshooting SQL Server Integration Services (SSIS) packages.

Proven experience with SQL Server Management Studio (SSMS), SQL Server Agent, and performance monitoring tools.

Proficiency in PowerShell or Python for scripting and automation tasks.

Strong analytical abilities, effective communication with stakeholders, and experience managing on-call schedules or incident queues.