NTT Data

Global IT services and consulting provider.

Support Tech Lead

Database AdministrationUpdated on Nov 14

Full-timeHyderabad, Telangana, IndiaNo salary listedIn-person

About the Job

Requirements

7 to 9 years of total IT experience, including at least 4 years specializing in MS SQL Server administration or development and SSIS production support.
Deep proficiency in T-SQL programming, stored procedures, triggers, indexing strategies, and query performance tuning.
Expert capability in designing, deploying, and troubleshooting SQL Server Integration Services packages.
Hands-on experience with SQL Server Management Studio, SQL Server Agent, and performance monitoring tools.
Basic to intermediate proficiency in PowerShell or Python for automation tasks.
Experience managing on-call support rotations or incident queues.

Responsibilities

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

We are looking for 7 to 9 yrs of experienced and hands-on SSIS and SQL Server Support Tech Lead 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

Required Qualifications & Skills

Experience: 7 to 9 years of total IT experience, with at least 4+ years specializing in MS SQL Server administration/development and SSIS production support.
SQL Server Expertise: Deep proficiency in T-SQL programming, stored procedures, triggers, indexing strategies, and query performance tuning.
SSIS Proficiency: Expert-level capability in designing, deploying, and troubleshooting SQL Server Integration Services (SSIS) packages.
Monitoring & Tooling: Hands-on experience with SQL Server Management Studio (SSMS), SQL Server Agent, and performance monitoring tools.
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

About the Company

NTT Data

Global IT services and consulting provider.

NTT DATA is a global IT and business services provider that helps organizations run and transform their technology and operations. It delivers consulting, industry solutions, cloud migration, cybersecurity, data analytics, and managed services to modernize systems and processes. It differentiates itself through its large scale, deep sector expertise in banking, healthcare, manufacturing, public sector, and automotive, and its broad ecosystem of partners with Microsoft, SAP, AWS, and Salesforce. Its goal is to help large enterprises digitally transform and optimize operations at scale using cloud-native approaches and secure IT environments.

Company size: 10,001+
Company stage: IPO
Headquarters: Tokyo, Japan
Founded: 1988

Recently Posted Jobs

Explore more opportunities at NTT Data

See more jobs