Job Description

SQL Server Production Support Engineer (SQL Server + SSIS)

/n

Location: Bangalore / WFO

/n

Experience: 5-12 Years

/n

Employment Type: Full-Time

/n

NP_ Immediate

/n

We are looking for a strong SQL Server & SSIS professional with hands-on L1, L2, and L3 Production Support experience. This role is primarily focused on supporting critical production applications and ETL processes, with a mix of development and enhancement activities.

/n

Role Split

/n

75% Production Support

/n

25% Development & Enhancements

/n

Key Responsibilities

/n

/n
- Provide L1/L2/L3 support for SQL Server databases and SSIS applications.
/n
- Troubleshoot production incidents, ETL failures, data load issues, and performance bottlenecks.
/n
- Analyze and resolve SQL query, stored procedure, function, trigger, and database-related issues.
/n
- Perform Root Cause Analysis (RCA) and implement preventive measures.
/n
- Monitor SQL Server jobs, ETL processes, and production environments.
/n
- Coordinate with business and technical teams to resolve issues within SLA timelines.
/n




- Support deployments, releases, and post-release validations.
/n
- Enhance and optimize existing SQL code and SSIS packages.
/n

/n

Required Skills

/n

/n
- Robust experience in Microsoft SQL Server
/n
- Hands-on experience with SSIS (SQL Server Integration Services)
/n
- Experience in L1/L2/L3 Production Support
/n
- SQL Query Troubleshooting & Performance Tuning
/n
- Stored Procedures, Functions, Views, Triggers
/n
- Incident Management & Root Cause Analysis
/n
- ETL Support and Failure Analysis
/n
- SQL Server Agent Jobs monitoring/support
/n
- ServiceNow, Jira, or similar ticketing tools
/n

/n

Good to Have

/n

/n
- Exposure to Power BI (approximately 10% of the role)
/n
- Data Warehousing concepts
/n
- Release and Deployment support
/n
- Basic PowerShell/Scripting knowledge
/n

/n

Preferred Background

/n

We are specifically looking for candidates from:

/n

/n
- SQL Support Engine

📌 SQL Server Production Support Engineer (Bengaluru)
🏢 Sonata Software
📍 Bengaluru