SSIS and SQL Server Support Tech Lead

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 failuresETL & 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 Required Qualifications & Skills 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 queuesNTT DATA provides a reasonable range of compensation for U.S.-based positions. The starting pay range for this remote role is $$92,160.00 to $138,240.00. This range reflects the minimum and maximum target compensation for the position across all US locations. Actual compensation will depend on a number of factors, including the candidate's actual work location, relevant experience, technical skills, and other qualifications. This position may also be eligible for incentive compensation based on individual and/or company performance. This position is eligible for company benefits including 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, participation in a 401k program with company match, and additional voluntary or legally required benefits