Talent.com
This job offer is not available in your country.
Application Support / Production Support L2 Professional - SQL & SSIS

Application Support / Production Support L2 Professional - SQL & SSIS

Innova ESIPune
30+ days ago
Job description

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)

    Create a job alert for this search

    Application Support • Pune