> Markdown version of [/jobs/ext/4589913-senior-facets-technical-consultant-batch-database-performance](https://www.wearedevelopers.com/jobs/ext/4589913-senior-facets-technical-consultant-batch-database-performance). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md).

---

# Senior Facets Technical Consultant - Batch & Database Performance

- **Company:** ICONMA LLC
- **Location:** Stoutsville, OH, United States
- **Experience:** Expert
- **Contract:** Permanent contract
- **Skills:** .NET Framework, Batch Processing, Information Technology Consulting, Databases, Microsoft SQL Server, Networx, Performance Tuning, Regression Testing, Standard Sql, SQL Stored Procedures, SQL Databases, SQL Server Integration Services, Transact-SQL, Scripting, Enterprise Software Applications, Performance Testing, Grafana, Parallel Computation, Database Performance, Indexer, Information Technology, Performance Monitor, Sql Tuning
- **Published:** November 5, 2026
- **Apply:** https://www.careerbuilder.com/job-details/senior-facets-technical-consultant-batch-database-performance-stoutsville-oh--cadc56a1-a903-443b-9db4-cd9bfa90ea2a

## About the Role

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

## Description

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.