18 Nov
|
Ascendion
|
Hyderabad
18 Nov
Ascendion
Hyderabad
Job Summary
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.
Solid 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
📌 Net Developer Us Healthcare Claims + Job Scheduling Tidal/autosys Hyderabad
🏢 Ascendion
📍 Hyderabad