Senior Facets Performance Lead: Batch & SQL Optimizer

TechDigital Group; Hartford (CT); On-site; USD 140,000 - 190,000; Full time

Job summary

TechDigital Group is seeking an experienced TriZetto Facets Technical Consultant to lead performance analysis and optimization of Facets batch processing and Microsoft SQL Server workloads. The role focuses on reducing batch windows, resolving bottlenecks, improving workload efficiency, and strengthening production stability, monitoring, and recovery.

This position requires deep Facets expertise, strong SQL skills, and proven ability to collaborate with cross-functional teams across application,

Qualifications

• 10+ years in enterprise application development, production support, database engineering, or performance optimization with strong TriZetto Facets experience.
• Hands-on knowledge of BINB, 837I, CLMU, CKMM, 835, and BOTB batch streams, including execution flows, dependencies, restart/recovery and performance tuning.
• Deep understanding of Facets batch architecture, job streams, scheduling, sequencing and restart/recovery processes.
• Strong experience with Microsoft SQL Server, T-SQL, stored procedures, and SQL performance tuning.

Responsibilities

• Analyze and optimize Facets batch jobs, SQL queries, scripts, and stored procedures.
• Perform batch runtime, dependency, critical-path, 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, and SQL performance.
• Perform root-cause analysis of recurring batch failures and recommend restart/recovery procedures and monitoring improvements.
• Analyze performance across Claims, Payments, XC, and Pre/Post-Adjudication processing.
• Establish baselines and validate optimization through performance and regression testing.
• Support capacity planning, workload forecasting, and environment comparisons.
• Document findings, risks, recommendations, and a prioritized performance roadmap.

Skills

TriZetto Facets

Facets batch streams

SQL Server / T-SQL

Query Store / DMVs

Batch optimization

Root-cause analysis

Stakeholder communication

Batch scheduling

Performance tuning

Tools

NetworX

PBA

Facets Workflow

XC/extract processing

Observability tools

Enterprise batch schedulers

Job description

TechDigital Group is seeking an experienced TriZetto Facets Technical Consultant to lead performance analysis and optimization of Facets batch processing and Microsoft SQL Server workloads. The role focuses on reducing batch windows, resolving bottlenecks, improving workload efficiency, and strengthening production stability, monitoring, and recovery.

This position requires deep Facets expertise, strong SQL skills, and proven ability to collaborate with cross-functional teams across application,