Senior Facets Technical Consultant - Batch & Database Performance

Our client, an IT Services and Consulting company, is looking for a Senior Facets Technical Consultant - Batch & Database Performance for their Remote location., * We are seeking an experienced TriZetto Facets Technical Consultant to lead performance analysis and optimization of high-volume Facets batch processing and Microsoft SQL Server workloads.

• The role will focus on reducing batch processing windows, resolving application and database bottlenecks, improving workload efficiency, and strengthening production stability, monitoring, and recovery.
• Analyze and optimize Facets batch jobs, SQL queries, scripts, and stored procedures.
• Perform batch runtime, dependency, criticalpath, workload, and throughput analysis to identify optimization opportunities.
• Diagnose SQL Server performance issues, including locking, blocking, deadlocks, wait statistics, indexing, CPU, memory, and I/O bottlenecks.
• Recommend improvements to batch sequencing, parallel processing, workload distribution, SQL performance, and batchwindow reduction.
• Perform rootcause analysis of recurring batch failures and recommend restart/recovery procedures, operational runbooks, monitoring, and automation improvements.
• Analyze performance across Claims, Payments, XC, and Pre/PostAdjudication processing.
• Establish performance baselines and validate optimization recommendations through performance and regression testing.
• Support capacity planning, workload forecasting, performance monitoring, and environment comparisons.
• Document findings, risks, recommendations, and a prioritized performance improvement roadmap.

Technical Consulting, Technical Consulting, Information Technology Consulting, Performance Analysis, Microsoft SQL Server, Performance Tuning/Optimization, Production Control, Analysis Skills, Scripting (Scripting Languages), SQL (Structured Query Language), * Must Have’s:

• Facets
• SQL
• .Net
• SSIS
• 10+ years of experience in enterprise application development, production support, database engineering, or performance optimization, with strong handson TriZetto Facets experience.
• Must have strong handson knowledge of BINB, 837I, CLMU, CKMM, 835, and BOTB batch streams, including execution flows, dependencies, failure analysis, restart/recovery, and performance optimization.
• Deep understanding of Facets batch architecture, job streams, dependencies, sequencing, scheduling, and restart/recovery processes.
• Strong handson experience with Microsoft SQL Server, TSQL, stored procedures, and SQL performance tuning.
• Experience with execution plans, Query Store, DMVs, indexing, wait statistics, locking/blocking, and deadlock analysis.
• Proven experience troubleshooting and optimizing highvolume, performancesensitive production batch workloads.
• Good understanding of healthcare payer processing, particularly Claims, Providers, Payments, and adjudication processes.
• Strong rootcause analysis, problemsolving, technical documentation, and stakeholder communication skills.
• Ability to collaborate across application, database, infrastructure, testing, and production support teams.
• Preferred Qualifications:
• Experience with NetworX, PBA, Facets Workflow, XC/extract processing, or related Facets components.
• Experience with enterprise batch schedulers, monitoring, and observability tools.
• Experience with performance testing, capacity analysis, workload forecasting, and operational automation.
• Experience supporting and optimizing largescale healthcare payer production environments.
• Years of Experience: 11.00 Years of Experience