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
- Strong 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 Engineer
n
- SQL Server Production Support Engineer
n
- Database Support Engineer
n
- SSIS Developer with Production Support experience
n
- SQL Developer with strong Support experience
n
- ETL Support Engineer
n

n

Power BI-centric profiles are not preferred unless they have robust SQL Server and SSIS Production Support experience.

n

If interested, please share your updated resume along with:

n

n
- Total Experience
n
- Relevant SQL Server Experience
n
- Relevant SSIS Experience
n
- Production Support Experience (L1/L2/L3)
n
- Current Location
n
- Notice Period
n

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