[Hiring] SSIS and SQL Server Support Tech Lead @NTT DATA Services

Role Description

We are currently seeking a SSIS and SQL Server Support Tech Lead to join our team in Addison, Texas (US-TX), United States (US). We are looking for an experienced professional to manage, optimize, and troubleshoot our core database and data integration environments. In this role, you will lead a team of support and database engineers, handle critical production incidents, optimize slow-running queries, and ensure high availability of our MS SQL Server and SSIS infrastructure.

Key Responsibilities

• Production Support & Incident Management: Lead the triage, troubleshooting, and resolution of critical production issues related to SQL Server databases, jobs, and SSIS package failures.
• ETL & SSIS Optimization: Monitor, review, and fine-tune SSIS packages to improve execution performance, error handling, and logging mechanisms.
• Database Performance Tuning: Analyze and optimize complex T-SQL queries, stored procedures, indexes, and execution plans to reduce server load and latency.
• Technical Leadership: Guide and mentor junior and mid-level support engineers, conduct code/script reviews, and establish operational best practices.
• Automation & Maintenance: Implement proactive maintenance routines, index rebuilding strategies, database backups/restores, and automation scripts using PowerShell or SQL Agent.
• Collaboration: Coordinate with cross-functional development, infrastructure, and business stakeholder teams during root cause analysis (RCA) and deployment cycles.

Qualifications

• 9+ years of total IT experience, with at least 4+ years specializing in MS SQL Server administration/development and SSIS production support.
• 5+ years of experience using SQL Server - Deep proficiency in T-SQL programming, stored procedures, triggers, indexing strategies, and query performance tuning.
• 5+ years of experience using SSIS - Expert-level capability in designing, deploying, and troubleshooting SQL Server Integration Services (SSIS) packages.
• 5+ years of experience Monitoring & Tooling - Hands-on experience with SQL Server Management Studio (SSMS), SQL Server Agent, and performance monitoring tools.
• 5+ years of experience Scripting: Basic to intermediate proficiency in PowerShell or Python for automation tasks.
• Soft Skills: Strong analytical mindset, excellent client/stakeholder communication, and experience managing on-call support rotations or incident queues.

Requirements

• Strong analytical mindset.
• Excellent client/stakeholder communication.
• Experience managing on-call support rotations or incident queues.

Benefits

• Medical, dental, and vision insurance with an employer contribution.
• Flexible spending or health savings account.
• Life and AD&D insurance.
• Short and long term disability coverage.
• Paid time off.
• Employee assistance program.
• Participation in a 401k program with company match.
• Additional voluntary or legally required benefits.