Project Description:
The role involves providing production support for enterprise applications with a focus on SSIS, SQL, and automation. You will work closely with technical and business teams to ensure smooth operations, timely issue resolution, and continuous improvement of support processes. The position requires hands-on experience with ITIL practices, strong problem-solving skills, and the ability to operate in rotational shifts except for night shifts.
Responsibilities
- :Provide L1, L2, and L3 production support across assigned applications, with primary ownership of SSIS-based solution
- sAct as the primary SSIS developer responsible for design, development, enhancement, and stabilization of SSIS packages in productio
- nManage incidents, problems, and changes in line with ITIL processes, with a strong focus on permanent resolutio
- nPerform daily monitoring and proactively address application, data, or job failure
- sAnalyse root causes of recurring issues and implement long-term fixes within SSIS and related data workflow
- sDesign, optimize, and maintain Control-M job schedules integrated with SSIS and SQL-based workflow
- sEnsure high availability, performance, and reliability of SSIS packages through effective error handling and performance tunin
- gCoordinate closely with development, data, and business teams to deliver enhancements and resolve issue
- sCreate Python scripts to automate repetitive or manual support activities related to data and batch processin
- gBuild automation solutions that reduce operational effort and improve overall support efficienc
- yUse Excel Macros or VBA where required for operational automation or reporting need
- sCommunicate clearly with stakeholders and provide regular updates on incidents, fixes, and improvement
s
Mandatory Skills Descriptio
- n:5+ years of hands-on experience in a technology support or development role with a strong and dedicated focus on SS
- ISProven, end-to-end development experience in designing, building, enhancing, maintaining, and troubleshooting SSIS packag
- esDemonstrated ability to independently deliver SSIS solutions for complex production environmen
- tsStrong experience providing production support for SSIS-based systems with a developer-led problem-solving approa
- chGood understanding of ITIL processes, including incident, problem, change, and escalation manageme
- ntHands-on experience with Control-M scheduling and solid understanding of SQL Server and relational database concep
- tsStrong skills in SSIS performance tuning, error handling, logging, and deployment practic
- esPython scripting experience for automation of operational and support activiti
- esStrong analytical skills with clear ownership and accountability for delivery and stabili
- tyGood communication and collaboration skills for working with business users and technical tea
- msWillingness to work in rotational shifts, excluding night shif
ts
Nice-to-Have Skills Descripti
- on:Experience in Excel Macros or VBA for automation and reporti
- ng.Exposure to continuous improvement practices within production suppo
rt.
