Application Support / Production Support L2 Professional - SQL & SSIS

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 :

ref : hirist.tech)