Technical Manager

HCL Technologies Limited; Chennai District; On-site; INR 1,200,000 - 2,000,000; Full time

Job summary

HCLTech is seeking a hands-on BAU Support Manager / Senior SQL Developer to lead stability, troubleshooting, and enhancement of data integration and reporting solutions across DEV, UAT, and PROD environments.

The role requires strong SQL Server 2019 and SSIS 2019 development skills, with experience coordinating with production support teams, incident management in JIRA, and thorough documentation in Confluence.

Qualifications

• Advanced SQL development and troubleshooting in SQL Server 2019.
• SSIS 2019 package design, scripting, deployment support, and error handling.
• Hands-on BAU support for critical data integration systems across DEV/UAT/PROD.

Responsibilities

• Lead and coordinate BAU support across data integration and reporting platforms.
• Investigate and resolve complex incidents across SQL Server, SSIS, and data transformations.
• Maintain runbooks, knowledge articles, and documentation in Confluence.

Skills

SQL Server 2019

SSIS 2019

BAU Support

JIRA

Tools

JIRA

Confluence

Job description

Key Responsibilities

• Lead and coordinate BAU support activities across data integration and reporting platforms.
• Investigate, troubleshoot, and resolve complex incidents across SQL Server, SSIS, source data, transformation logic, and downstream outputs.
• Perform root cause analysis and implement robust, permanent fixes rather than short-term workarounds.
• Manage support queues, defects, incidents, and enhancement requests through JIRA.
• Maintain clear support documentation, technical notes, runbooks, and knowledge articles in Confluence.
• Work closely with separate Production support teams to diagnose issues, coordinate releases, and restore service.
• Communicate issue status, impact, resolution options, and progress clearly to technical and non-technical stakeholders.
• Design, develop, maintain, and troubleshoot SQL Server 2019 database components, including complex T‑SQL scripts, stored procedures, views, functions, and SQL Agent jobs.
• Tune queries and stored procedures for performance, reliability, and maintainability.
• Support controlled deployments and fixes across DEV, UAT, and PROD environments.
• Design, build, enhance, and troubleshoot SSIS 2019 packages and ETL workflows.
• Develop and maintain package scripting, expressions, transformations, connection managers, and error handling.
• Diagnose package failures, data load errors, scheduling issues, performance bottlenecks, and environment-specific failures.
• Improve existing ETL processes through automation, validation, monitoring, and operational hardening.
• Operate effectively across distributed DEV, UAT, and PROD environments.
• Ensure defects, fixes, releases, and operational processes are documented and traceable in Confluence.
• Use own initiative to identify improvement opportunities, design practical solutions, and reduce recurring BAU issues.

Required Skills & Experience

• SQL Server 2019 – Advanced SQL development, complex T‑SQL scripting, stored procedure creation, troubleshooting, query tuning, and performance optimization.
• SSIS 2019 – Advanced package design, development, scripting, troubleshooting, deployment support, transformations, and error handling.
• BAU Support – Hands‑on support of critical systems ingesting CSV, Excel, and SQL data sources and transforming data using SSIS and SQL.
• Experience supporting distributed DEV, UAT, and PROD environments, including models where PROD support is owned by a separate team.
• JIRA – Workflow management for incidents, defects, and enhancement requests.

About the Role

BAU Support Manager / Senior SQL Developer. A hands‑on BAU support and SQL/SSIS technical leadership role responsible for the stability, troubleshooting, enhancement, and documentation of critical data integration systems across DEV, UAT, and PROD environments.

We are seeking an experienced BAU Support Manager / Senior SQL Developer to lead the support, maintenance, troubleshooting, and enhancement of critical data integration and reporting solutions.

The successful candidate will combine strong hands‑on SQL Server 2019 and SSIS 2019 development skills with the ability to manage business‑as‑usual support activity, diagnose complex issues, and work effectively across distributed environments where Production is owned and supported by a separate team outside the development lab.

Company Culture

At HCLTech, you'll supercharge your potential. You'll find your career. And you'll find your spark. All at a place that knows that helping its customers stay on top starts by putting its people first.

HCLTech is a global technology company, home to more than 223,000 people across 60 countries, delivering industry‑leading capabilities centered around digital, engineering, cloud and AI, powered by a broad portfolio of technology services and products. We work with clients across all major verticals, providing industry solutions for Financial Services, Manufacturing, Life Sciences and Healthcare, Technology and Services, Telecom and Media, Retail and CPG, and Public Services. Consolidated revenues as of 12 months ending June 2026 totalled $14.8billion.