Production/Application support engineer with over 4 years of relevant experience.Following ITIL processes. extensive experience of handling Incidents, Major-Incidents(MIM) & Problems at Production environment. aslo having sound knowledge on service request-management, SLA & KPI management. having hands-on experience in SQL and Unix. a team player and a highly motivated individual willing to learn new technologies and methods. able to adapt to different work culture and always ready to accept new challenges.
Overview
3
3
years of professional experience
Work History
Application/Senior Production Support Engineer
Magnibot Technology solutions Pvt Ltd
Bangalore
07.2021 - Current
Worked as a Production Support Engineer
Individul Contributor (L2/L1.5/L1)
Followed ITIL process to solve Incidents and Manage Problems (P1, P2, P3 Tickets)
Having Experience of Handling Incidents & Major Incidents (MIM), Problems RC
Wrote SQL queries to troubleshoot and resolve data discrepancies and performance issues
Utilized SQL for data extraction, transformation, and loading (ETL) processes, ensuring data integrity and accuracy
Performed database performance tuning and optimization using SQL scripts and queries
Generated reports and dashboards using SQL queries to provide insights into incident trends and system performance
Conducted SQL-based audits to ensure compliance with data governance policies
Updated and created incident tickets in the Service Now Ticketing Tool application
Identified defects within, worked with vendor and project management team on a code changes and new fix in upcoming Release
This resulted increased efficiency in batch processing with no errors or transmissions missed and thus reduced the number of incidents
Provided technical/functional support to programmers
Ensured SLAs were met
Reduced processing time by analyzing Job schedules and implementing appropriate modifications
Established runbooks for each exercise to assure that the failover procedures were accurate and repeatable and that the associated risks were minimized
Provided data to clients using SQL queries
Handled and assisted in the resolution of high priority production issues by reviewing large server logs
Provided 24/7 support for web and client-based applications, file and data feeds, and batch processes to prevent impact to the business
Regularly consulted with team members, development, database admin, networking, and system admin groups to improve system
Used monitoring technologies to monitor batch processes (CONTROL-M, Autosys)
Development and System Test implementing Production Support workarounds until code fixes could be deployed
Root Cause Analysis(RCA) for incidents involving team's supported applications.
Education
B.Tech - Electronics & Communication Engineering
Narula Institute Of Technology (WBUT)
Kolkata, India
Diploma Engineering - Electronics & Communication Engineering
West Bengal University Of Technical Education
Kolkata, India
10TH -
Dr. Shyamaprasad Mukherjee Institute
Kolkata, India
Skills
SQL
PLSQL
Unix
Shell Scripting
Control-M
Splunk
Service-Now
ITIL
JIRA
Batch Monitoring
Incident Management
Problem Management
Change Management
Service Request Management
Release Management
SAL’s & KPI’s Management
L1/L15/L2 Support
Timeline
Application/Senior Production Support Engineer
Magnibot Technology solutions Pvt Ltd
07.2021 - Current
B.Tech - Electronics & Communication Engineering
Narula Institute Of Technology (WBUT)
Diploma Engineering - Electronics & Communication Engineering
Senior Account Manager at Magnibot Technology Solutions India Private LimitedSenior Account Manager at Magnibot Technology Solutions India Private Limited