Vijay Kumar
Sr. Support Engineer
Bengaluru
Summary
10.6 years of experience in Production or Application support role. Proficiency in SQL querying. Experience with Postman tool for API testing. Strong understanding of AWS S3 services and Azure Monitoring. Experience with MS SQL profiler for troubleshooting. Perform root cause analysis using logs, database and product knowledge.
Overview
11
11
years of professional experience
Work History
Sr. Support Engineer
HealthAsyst Pvt. Ltd.
03.2022 - 03.2025
- Troubleshoot the Production issues by analyzing DB data using SQL query language and product knowledge and by analyzing application and IIS logs.
- Deployment of production changes (Java script changes, dll files and store procedure) and validating post deployment.
- Reproduce the production issues in the local environment and raise a bug and assign it to the respective QA or Development team.
- Using Postman for API testing and troubleshooting a production issue.
- Working closely with Development team and perform root cause analysis.
- Use to Debug the store procedure to troubleshoot the reported production issue.
- SQL DB Maintenance- Archiving old and unwanted data , deleting of Application DB logs which was captured to troubleshoot ongoing production issues or which was added for information purpose. Monitoring daily SQL server agent jobs and use to take necessary actions if any jobs were failed or running for a long time.
- Windows Sever Maintenance- Maintaining sufficient Disk space, Memory and CPU uses. Cleaning up old and unwanted IIS log files.
- Using SQL queries sharing the required data to the business team or other stake holders (Which are not available in report section of UI or it is in the development phase)
Operations Engineer
Wall Street English India Pvt. Ltd.
12.2019 - 02.2022
- Using SQL queries (views, temp tables, joins, date functions etc.) for debugging and analyzing data to troubleshoot the received incidents.
- Use to share the requested data from database to the business team using SQL queries.
- Create, update, resolve and keeping a track of ongoing incident or service request using Jira ticketing tool.
- We use to troubleshoot the incident received and for the critical issue or request we use to coordinate with Developers, QA and Project team and getting it done.
- Once the issue will be prioritized by product team then Interacting with respective developers or QA until the issue is fully resolved and providing the required logs/data for debugging.
Techops Engineer
Lynk Logistics Ltd.
02.2018 - 11.2019
- Using SQL queries to troubleshoot L2 & L3 queries.
- Writing SP to create SQL server agent jobs to share required data to business team on scheduled basis.
- Creating and monitoring deadlock alert and forwarding it to the owner of the SP.
- Using Graylog, S3 bucket to check application logs in order to troubleshoot application related issues.
- Monitoring AWS dashboard and reaching out to concerned if it crosses the defined threshold.
- Acknowledgement and action on P1 issues within 10 min.
- Create, update, resolve and close escalated trouble tickets using Freshdesk ticketing tool.
- Interacting with developers until the issue is fully resolved and providing the required logs/data for debugging.
- Supporting the training and mentoring of new hires and creating SOP's.
Executive Support L2
Sify Technologies Ltd.
06.2014 - 01.2018
- Writing SQL queries to collect or analyze the data for debugging the issue and sharing the RCA to the stake holder.
- For critical issues we use to escalate it to next level team and helping them with required data for analyzing the RCA and sharing the details of bug.
- Takes accountability and drives resolution by working with personnel from various teams to coordinate efforts and provide resolution to customer in a timely manner.
- Accurately assesses the customer's product issue or problem
- Conveys users feedback to Development Team
- Manages the identification and resolution of application and service issues and any other questions that may arise.
- Ensures team is properly trained when existing products are upgraded, or new products are released.
- Ensures performance of the technical support group is within established Service Level Agreement (SLA) with the customers
- Ensures the team is trained and familiar with the Standard Operating Procedures (SOPs) and any updates or changes.
- Performs employee evaluations; gives employee feedback and coaching to develop and improve performance.
Education
B.Tech - Computer Science and Engineering
Konark Institute of Science And Technology
Bhubaneswar01.2013
Skills
SQL (DQL, DML DDL & TCL)
Cte, Views, Triggers, Indexing, Cursor, Store Procedure
SSMS
SQL Profiler
MS SQL Server
Postman
Windows Server
AWS S3 service and Dashboard
Azure Monitor
Ticketing Tool: Jira, CRM and CA Service desk-tools, Freshdesk ticketing and Zendesk
Timeline
Sr. Support Engineer
HealthAsyst Pvt. Ltd.
03.2022 - 03.2025
Operations Engineer
Wall Street English India Pvt. Ltd.
12.2019 - 02.2022
Techops Engineer
Lynk Logistics Ltd.
02.2018 - 11.2019
Executive Support L2
Sify Technologies Ltd.
06.2014 - 01.2018
B.Tech - Computer Science and Engineering
Konark Institute of Science And Technology