First seen by Alion on Nov 21, 2026.
L2 Application Support – Roles & Responsibilities
Profile Summary
Experienced L2 Application Support professional with expertise in application monitoring, production support, data patching, SQL queries, and advanced Excel. Skilled in incident management, troubleshooting application issues, root cause analysis, and ensuring SLA compliance. Experienced in coordinating with L1, L3, development, and business teams to ensure smooth application operations and minimal business disruption.
Key Responsibilities1. Application Support (L2)
Provide L2 support for production applications and resolve functional and technical issues.
Troubleshoot application errors, data discrepancies, and system performance issues.
Analyze application logs and identify recurring issues.
Coordinate with L3/development teams for complex technical issues.
2. SQL & Data Patching
Write and execute SQL queries for data validation and troubleshooting.
Perform data analysis using SELECT, JOIN, UPDATE, and other SQL queries.
Perform data corrections and data patching based on approved business requests.
Validate database records before and after data patching.
Ensure data accuracy and maintain proper documentation and audit trails.
3. Excel & Data Analysis
Use MS Excel for data validation, reconciliation, and reporting.
Work with VLOOKUP, XLOOKUP, Pivot Tables, IF conditions, and formulas.
Analyze large datasets and identify data mismatches.
Prepare daily, weekly, and monthly operational reports.
4. Incident Management
Manage incidents through ticketing tools such as ServiceNow, Jira, or similar platforms.
Perform initial investigation, troubleshooting, and incident resolution.
Prioritize incidents based on business impact and severity.
Perform root cause analysis (RCA) for recurring incidents.
Ensure timely incident updates and resolution.
5. SLA Management
Ensure incidents and service requests are resolved within defined SLAs.
Monitor response and resolution timelines.
Escalate critical and high-priority incidents within agreed timelines.
Track SLA breaches and prepare performance reports.
Participate in daily operations calls and service review meetings.
Skills
data quality audits, Troubleshooting, Patching of Databases, Data Analysis, resolve incident tickets, Investigation, Root Cause Analysis, General Queries, JIRA, RCA, Application Support, Incident Handling, ServiceNow, SQL Development, Platforms, Incident Management

