Senior Production Support Engineer

Experience: 7+ Years

Location: [Location / Remote]

Employment Type: Full-Time

Job Summary

We are looking for a Senior Production Support Engineer with strong experience in application production support, SQL/SQL Server, troubleshooting, log analysis, and customer-facing support. The ideal candidate will be responsible for diagnosing production issues, analyzing application and SQL Server logs, coordinating with development teams, and ensuring timely resolution of critical customer issues.

Key Responsibilities

- Provide L2/L3 production support for business-critical applications and services.
- Monitor applications and proactively identify production issues, failures, and performance problems.
- Troubleshoot application issues by analyzing SQL queries, database behavior, application logs, and SQL Server logs.
- Write and execute complex SQL queries for troubleshooting, data validation, root-cause analysis, and issue resolution.
- Analyze SQL Server logs, application logs, error messages, stack traces, and system alerts to identify the root cause of incidents.
- Understand how applications are developed and work closely with developers, QA, DevOps, and database teams to resolve technical issues.
- Investigate production incidents from identification through resolution and provide clear RCA (Root Cause Analysis).
- Handle customer-reported technical issues and provide timely, professional communication and status updates.
- Participate in customer calls to understand issues, explain technical findings, and communicate resolution timelines.
- Coordinate with development teams for application defects, enhancements, and permanent fixes.
- Perform impact analysis and recommend appropriate workarounds or permanent solutions.
- Maintain incident, problem, and knowledge-management documentation.
- Participate in production deployments, release validation, and post-deployment monitoring.
- Support critical/high-priority incidents and participate in on-call/after-hours support when required.




- Identify recurring issues and recommend improvements to application stability, monitoring, and support processes.

Required Skills
- 10+ years of experience in Production/Application Support.
- Strong hands-on experience with SQL and Microsoft SQL Server.
- Robust understanding of SQL queries, joins, stored procedures, indexing, transactions, and database troubleshooting.
- Experience analyzing SQL Server logs and application/server logs.
- Strong troubleshooting and analytical skills with the ability to identify root causes from limited information.
- Good understanding of application development concepts, SDLC, APIs, and application architecture.
- Ability to understand how applications are developed and work effectively with software development teams.
- Experience working with production incidents, problem management, RCA, and escalation processes.
- Strong customer-facing and communication skills.
- Ability to explain technical issues clearly to both technical and non-technical stakeholders.
- Experience working with ticketing/ITSM tools such as ServiceNow, Jira, or similar platforms.

Preferred Skills
- Experience supporting web-based or enterprise applications.
- Knowledge of REST APIs and integration troubleshooting.
- Experience with application monitoring tools such as Splunk, Dynatrace, AppDynamics, Datadog, or similar.
- Basic understanding of Linux/Unix commands and server troubleshooting.
- Exposure to cloud environments such as Azure or AWS.
- Knowledge of incident management frameworks such as ITIL.

Ideal Candidate Profile The ideal candidate is a strong production support professional who can independently troubleshoot complex application issues, work extensively with SQL/SQL Server and logs, understand application behavior, and communicate confidently with customers and internal technical teams.

Key Skills:

Production Support | L2/L3 Support | SQL | SQL Server | Log Analysis | Application Troubleshooting | RCA | Incident Management | Customer Facing | Application Development Understanding | API Troubleshooting | ITIL

📌 Senior Production Support Engineer (India)
🏢 Collaborative Mind
📍 India