SQL Production Support Engineer
First seen by Alion on Sep 8, 2026.
Position Overview :
Zelis is seeking a skilled SQL Production Support Engineer to support mission-critical healthcare and payments applications.
The role focuses on production support, SQL server operations, incident management, and system reliability, ensuring high availability and performance of enterprise platforms.
Key Responsibilities :
- Provide L2/L3 production support for business-critical applications and databases.
- Monitor, troubleshoot, and resolve production incidents related to SQL Server, application jobs, and data issues.
- Perform advanced SQL analysis, including query optimization, deadlock analysis, and performance tuning.
- Execute root cause analysis (RCA) for production issues and implement preventive measures.
- Support batch jobs, ETL processes, stored procedures, and scheduled SQL tasks.
- Work closely with application, DevOps, DB, and infrastructure teams during incidents and deployments.
- Manage on-call support, incident escalation, and communication with stakeholders.
- Ensure adherence to SLA, compliance, and operational best practices.
- Participate in release support, change management, and production deployments.
- Create and maintain runbooks, SOPs, and operational documentation.
Required Skills & Qualifications :
- 4+ years of experience in Production Support / IT Operations roles.
- Strong hands-on experience with Microsoft SQL Server (queries, joins, indexing, execution plans).
- Proficient in writing and optimizing complex SQL queries, stored procedures, and functions.
- Solid understanding of database performance tuning, locking, blocking, and deadlocks.
- Experience with incident management tools (ServiceNow or equivalent).
- Knowledge of monitoring tools and log analysis.
- Understanding of batch processing, data integrity, and transactional systems.
- Ability to work in shift-based and on-call environments.
- Strong analytical, troubleshooting, and communication skills.
Good to Have:
- Experience supporting payments, healthcare, or financial systems.
- Exposure to ETL tools, SSIS, or data pipelines.
- Basic understanding of .NET applications, APIs, and microservices.
- Familiarity with Azure SQL / cloud-based database environments.
- Knowledge of ITIL processes and change management practices.
Commitment to Diversity, Equity, Inclusion, and Belonging :
At Zelis, we champion diversity, equity, inclusion, and belonging in all aspects of our operations.
We embrace the power of diversity and create an environment where people can bring their authentic and best selves to work.
We know that a sense of belonging is key not only to your success at Zelis, but also to your ability to bring your best each day.
Skills
IT Operations, SQL, Technical Support, Production Support, ETL, Database Performance Tuning, Incident Management, Monitoring Tools, ITIL, Azure SQL