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

    Related jobs
    Application Support Engineer

    Application Support Engineer

    Partner One CapitalIN
    Remote
    Quick Apply
    Cincom Systems is a global leader in enterprise software solutions, delivering innovative and customer-centric products across multiple industries. We are looking for someone to join our Cincom CONT...Show moreLast updated: 30+ days ago
    • Promoted
    Production Support Engineer

    Production Support Engineer

    TechVeritoPune, Maharashtra, India
    Production support with aptitude to learn Java coding.Show moreLast updated: 2 days ago
    Production Support Engineer - Technical and Business Application Support

    Production Support Engineer - Technical and Business Application Support

    SYNECHRONINDIA
    We are seeking a skilled Production Support Engineer with at least 7 years of experience in software development and production support to join our team. If you have a strong analytical mindset and ...Show moreLast updated: 30+ days ago
    L2 support

    L2 support

    Zensar TechnologiesPune, Maharashtra, India
    Remote
    Troubleshoot application issues, perform root cause analysis, and ensure resolution within agreed SLAs.Support users (clinical and administrative) with application usage, configurations, and minor ...Show moreLast updated: 20 days ago
    L2 Support Engineer

    L2 Support Engineer

    Screen Magic Mobile Media Pvt. Ltd.Pune, Maharashtra, IN
    Quick Apply
    Job Summary We are seeking a motivated and detail-oriented L2 Technical Support Engineer to join our dynamic customer support team. In this role, you will provide advanced technical assistance to cu...Show moreLast updated: 30+ days ago
    L2 Application Support Engineers​

    L2 Application Support Engineers​

    Clover Infotech Private LimitedPune
    Responsible for the day-to-day maintenance of the application systems in operation, including tasks related to identifying and troubleshooting application issues and issues resolution or escalation...Show moreLast updated: 30+ days ago
    L2 Application Support Engineer - MuleSoft

    L2 Application Support Engineer - MuleSoft

    StratacentPune, Maharashtra
    Business Title : L2 Application Support Engineer - MuleSoft.The ideal candidate should have a strong background in operations, troubleshooting, and support in these areas.As a Level 2 Support & ...Show moreLast updated: 7 days ago
    Production Support (SQL) - IT

    Production Support (SQL) - IT

    FlexINDIA
    Flex is the diversified manufacturing partner of choice that helps market-leading brands design, build and deliver innovative products that improve the world. We believe in the power of diversity an...Show moreLast updated: 30+ days ago
    • Promoted
    Fulcrum Digital - L2 DevOps / Production Support Engineer

    Fulcrum Digital - L2 DevOps / Production Support Engineer

    Fulcrum digitalPune
    DevOps / Production Support Engineer (L2) Experience Level : 7+ Years Location : Noida, Uttar Pradesh, India&...Show moreLast updated: 30+ days ago
    • New!
    L2 Support Engineer (Back Office Operations & Enterprise Application Support)

    L2 Support Engineer (Back Office Operations & Enterprise Application Support)

    SynechronPune, Hinjewadi
    Synechron is seeking a skilled L2 Support Engineer to join our Enterprise Delivery Support Team.This role is pivotal in providing advanced back-office operational and application support, ensuring ...Show moreLast updated: 3 hours ago
    • Promoted
    Production Support Engineer

    Production Support Engineer

    Concentrix CatalystPune, IN
    Remote (may need to travel to nearby Concentrix office as per business need).Key Duties and Responsibilities.Support and Maintain Applications : Provide ongoing support and maintenance for applicati...Show moreLast updated: 2 days ago
    • Promoted
    Production Support Engineer

    Production Support Engineer

    MajescoPune, IN
    Job Title : Application / Production Support Engineer.Shift Timing : 5PM to 2AM (IST).Application Support Analyst will be responsible for Triaging the cases in L2 Production support and take care of an...Show moreLast updated: 24 days ago
    • Promoted
    TCS Walkin Drive for Unix & SQL - Production Support

    TCS Walkin Drive for Unix & SQL - Production Support

    Tata Consultancy ServicesPune, Maharashtra, India
    Saturday Walkin Drive 14th June 25.Unix & SQL - Production Support.Good Knowledge in Unix,SQL and PL / QSL.Good Experience In production support Environment. Able to provide Application team support f...Show moreLast updated: 29 days ago
    • Promoted
    Production Support Engineer - SQL

    Production Support Engineer - SQL

    ENERGY EXEMPLAR INDIA PRIVATE LIMITEDPune
    About the Position : This role provides frontline support for consultants and customers using the Adapt2 ISO product, managing tier 3 triage for shadow settlements a...Show moreLast updated: 5 days ago
    L2 Lead Technical Application Support, Associate

    L2 Lead Technical Application Support, Associate

    F337 Deutsche India Private Limited, Pune BranchMargarpatta, Pune
    Our organization within Deutsche Bank is Compliance Production Services.We are responsible for providing technical L2 application support for business applications. The Compliance line of business h...Show moreLast updated: 30+ days ago
    • Promoted
    SQL Server - SSIS / Azure Databricks

    SQL Server - SSIS / Azure Databricks

    Techmynd ConsultingPune
    SQL Server -SSIS, ADF Location : Pune (Hybrid) Experience : 5-8 Years Must-Have : - SQL Server, Performance tunin...Show moreLast updated: 12 days ago
    • Promoted
    L2 - Technical Support Analyst (Healthcare)

    L2 - Technical Support Analyst (Healthcare)

    vueverse.Pune, IN
    L2 Technical Support Specialist.In this role, you will provide advanced (L2) technical and functional support for critical clinical applications, primarily used in diagnostic imaging, radiology wor...Show moreLast updated: 18 days ago
    SOC L2 / L3 Support

    SOC L2 / L3 Support

    Persistent SystemsPune, Maharashtra, India
    As a SOC Level 2 Analyst, you will play a crucial role in monitoring, analyzing, and responding to security incidents and threats within our organization's environment. You will work closely with SO...Show moreLast updated: 2 days ago