BAU Support Manager / Senior SQL Developer Job Specification Role summary: 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.
About the Role 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.
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.
- Create, optimise, and support complex T‑SQL scripts, stored procedures, views, functions, and SQL Agent jobs.
- Investigate data quality, reconciliation, performance, locking, failure, and integrity issues.
- 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.
- Support systems that ingest data from CSV files, Excel files, SQL Server databases, and other structured sources.
- 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.
- Work within a support model where Production is owned and supported by a separate team outside the lab.
- Ensure defects, fixes, releases, and operational processes are documented and traceable.
- Use Confluence to maintain clear technical documentation, support procedures, known issues, and operational runbooks.
- Use own initiative to identify improvement opportunities, design practical solutions, and reduce recurring BAU issues.
Required Skills & Experience Area Requirement Level SQL Server 2019 Advanced SQL development, complex T‑SQL scripting, stored procedure creation, troubleshooting, query tuning, and performance optimization. Advanced SSIS 2019 Package design, development, scripting, troubleshooting, deployment support, transformations, and error handling. Advanced BAU Support Hands‑on support of critical systems ingesting CSV, Excel, and SQL data sources and transforming data using SSIS and SQL. Essential Environments Experience supporting distributed DEV, UAT, and PROD environments, including models where PROD support is owned by a sepa
BAU Support Manager / Senior SQL Developer Job Specification Role summary: 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. About the Role 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. Key Responsibilities BAU Support & Incident Management 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. SQL Server 2019 Development Design, develop, maintain, and troubleshoot SQL Server 2019 database components. Create, optimise, and support complex T‑SQL scripts, stored procedures, views, functions, and SQL Agent jobs. Investigate data quality, reconciliation, performance, locking, failure, and integrity issues. Tune queries and stored procedures for performance, reliability, and maintainability. Support controlled deployments and fixes across DEV, UAT, and PROD environments. SSIS 2019 Development & Troubleshooting Design, build, enhance, and troubleshoot SSIS 2019 packages and ETL workflows. Support systems that ingest data from CSV files, Excel files, SQL Server databases, and other structured sources. 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. Environment, Governance & Documentation Operate effectively across distributed DEV, UAT, and PROD environments. Work within a support model where Production is owned and supported by a separate team outside the lab. Ensure defects, fixes, releases, and operational processes are documented and traceable. Use Confluence to maintain clear technical documentation, support procedures, known issues, and operational runbooks. Use own initiative to identify improvement opportunities, design practical solutions, and reduce recurring BAU issues. Required Skills & Experience Area Requirement Level SQL Server 2019 Advanced SQL development, complex T‑SQL scripting, stored procedure creation, troubleshooting, query tuning, and performance optimization. Advanced SSIS 2019 Package design, development, scripting, troubleshooting, deployment support, transformations, and error handling. Advanced BAU Support Hands‑on support of critical systems ingesting CSV, Excel, and SQL data sources and transforming data using SSIS and SQL. Essential Environments Experience supporting distributed DEV, UAT, and PROD environments, including models where PROD support is owned by a sepa
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 2026totaled $14.8billion.
#J-18808-Ljbffr
Microsoft Power BI Technical Specialist in London employer: HCL Technologies Limited
HCL Technologies Limited is an exceptional employer located in the vibrant City of London, offering a dynamic work culture that prioritises employee growth and development. With a strong focus on customer service excellence and operational efficiency, employees benefit from comprehensive training programs and opportunities to enhance their skills while contributing to meaningful projects. The collaborative environment fosters innovation and teamwork, making it an ideal place for those seeking a rewarding career in program and project management.
