We are looking for a hands-on engineer to assess and optimize a healthcare payers claims batch workplace. The role involves reviewing Tidal-orchestrated jobs, .NET/C# applications, and SQL Server stored procedures to establish a performance baseline and create an evidence-based remediation roadmap.
Key Responsibilities
- Trace batch jobs to their stored procedures, steps, and dependencies.
- Build a job procedure step lineage map.
- Diagnose performance issues using Query Store, DMVs, execution plans, scheduler history, and Splunk.
- Use AI/LLM tools to accelerate code and stored-procedure reviews, while independently validating all findings.
- Recommend whether jobs should be retained, tuned, consolidated, or retired.
- Develop a performance baseline, hotspot inventory, remediation backlog, and 1218-month roadmap.
Mandatory Skills
- 5+ years of experience in .NET/C# and SQL Server.
- Strong experience with stored-procedure-heavy applications.
- Hands-on experience with Tidal, Control-M, AutoSys, or a similar batch scheduler.
- Expertise in SQL Server Query Store, DMVs, and execution-plan analysis.
- Practical experience using GitHub Copilot, Claude, ChatGPT, or similar AI tools in engineering workflows.
- Comfortable working with complex legacy systems, limited documentation, and large batch environments.
Preferred Skills
- US Healthcare Payer or Claims experience.
- Experience with Splunk or similar observability tools.
- Knowledge of rules engines or event-driven processing.
- Familiarity with Microsoft Azure.
Locations: Bangalore / Hyderabad / Pune / Chennai / Vadodara
Shift: 2 PM to 11 PM IST
Work Mode: Hybrid
Notice Period: Immediate Joiners or serving notice period less than 30 days