Senior Facets Performance Engineer: Batch & SQL Tuning

TechDigital Group; Georgia; Hybrid; USD 130,000 - 170,000; Full time

Job summary

TechDigital Group seeks 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 focuses on reducing batch windows, resolving bottlenecks, improving efficiency, and strengthening production stability, monitoring, and recovery across Claims, Payments, XC, and Pre/Post-Adjudication.

Qualifications

• 10+ years in enterprise application development, production support, database engineering, or performance optimization with strong Facets experience.
• Hands-on knowledge of Facets batch streams (BINB, 837I, CLMU, CKMM, 835) and restart/recovery processes.
• Deep understanding of Facets architecture, job streams, dependencies, scheduling, and performance optimization.
• Strong SQL Server skills: T-SQL, stored procedures, indexing, Query Store, wait stats, deadlock analysis.

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, and I/O bottlenecks.
• Recommend improvements to batch sequencing, parallel processing, workload distribution, and batch-window reduction.
• Perform root-cause analysis of recurring batch failures and propose restart/recovery procedures and runbooks.
• 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, monitoring, and environment comparisons.
• Document findings, risks, recommendations, and a prioritized roadmap.

Skills

Facets

SQL

.NET

SSIS

BINB

837I

CKMM

Batch processing

Tools

Microsoft SQL Server

Job description

TechDigital Group seeks 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 focuses on reducing batch windows, resolving bottlenecks, improving efficiency, and strengthening production stability, monitoring, and recovery across Claims, Payments, XC, and Pre/Post-Adjudication.