Application Support L2 / Production Support L2
We are seeking a skilled Application Support L2 / Production Support L2 professional with strong expertise in SQL, T-SQL, SSIS, and SQL Server.
In this role, you will be responsible for providing second-level support for applications and production systems, troubleshooting issues, performing root cause analysis (RCA), and ensuring the seamless operation of our critical systems.
The ideal candidate will have a solid understanding of SQL Server, ETL processes, and AWS, along with strong debugging and communication skills. You will work closely with cross-functional teams to maintain system stability and ensure efficient resolution of production issues.
Key Responsibilities :
- Application / Production Support : Provide L2 support for mission-critical applications, resolving production issues in a timely manner. Ensure high availability and optimal performance of applications.
- Administer SQL Server environments, manage SQL Jobs, and monitor SQL Agent Jobs to ensure smooth operation.
- Handle ETL processes using SSIS (SQL Server Integration Services) for data transformation, migration, and integration.
- Troubleshoot and identify the root cause of production incidents / issues in applications and services.
- Collaborate with development and infrastructure teams to resolve issues and implement permanent fixes.
- AWS : Utilize AWS services to support and troubleshoot cloud-based applications and systems. Provide support for applications hosted on AWS cloud infrastructure.
- Handle and resolve incidents through ServiceNow or other ticketing systems.
- Prioritize and manage multiple support tickets while maintaining proper documentation of issue resolution steps and outcomes.
- Provide clear and concise documentation for application issues, including known errors and troubleshooting steps.
- Collaborate with other teams (development, infrastructure, etc.) for issue resolution and process improvements.
- Maintain strong communication with stakeholders to ensure timely resolution of issues and adherence to SLAs.
- Monitor system health, perform proactive checks, and identify potential risks that could lead to production issues.
- Implement and improve monitoring tools and practices for efficient system health tracking.
Required Skills & Qualifications :
Strong experience in T-SQL, SQL Server, and SQL Server Agent Job monitoring.Experience with SQL Server Integration Services (SSIS) for creating, managing, and debugging ETL processes.AWS : Familiarity with AWS cloud services (EC2, RDS, S3, Lambda, etc.) for supporting cloud-based applications.Minimum 3 years of experience in application / production support (L2), with proven experience in incident resolution and root cause analysis (RCA).Hands-on experience with ServiceNow or similar ticket management systems.Strong debugging skills, with the ability to analyze and resolve complex issues independently.Excellent verbal and written communication skills, with the ability to document troubleshooting steps and solutions effectively.Strong attention to detail, especially in documentation and issue resolution processes.ref : hirist.tech)