Highlights
Job Description: a { text-decoration: none; color: #464feb; } tr th, tr td { border: 1px solid #e6e6e6; } tr th { background-color: #f5f5f5; } Job Summary 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. Our client is an American multinational information technology services and consulting company and is a leading provider of information technology, consulting, and business process outsourcing services, dedicated helping the world's leading companies build stronger businesses.
Numbers & Facts
| Location | NULL, NULL (Remote) |
| Industry | Computer/IT Services |
| Salary | $58.92 |
| Company Size | 100 to 499 employees |
| Year Founded | 2009 |
| Website | http://www.tekwissen.com/ |
Description
Overview:
TekWissen is a global workforce management provider headquartered in Ann Arbor, Michigan that offers strategic talent solutions to our clients world-wide. Our client is an American multinational information technology services and consulting company and is a leading provider of information technology, consulting, and business process outsourcing services, dedicated helping the world's leading companies build stronger businesses.
Job Title: Senior Facets Technical Consultant
Location: Remote
Duration: 6 Months
Job Type: Temporary Assignment
Work Type: Remote
Job Description:
a { text-decoration: none; color: #464feb; } tr th, tr td { border: 1px solid #e6e6e6; } tr th { background-color: #f5f5f5; }
Job Summary
- 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, 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, SQL performance, and batch-window reduction.
- Perform root-cause analysis of recurring batch failures and recommend restart/recovery procedures, operational runbooks, monitoring, and automation improvements.
- Analyze performance across Claims, Payments, XC, and Pre/Post-Adjudication 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.
- 10+ years of experience in enterprise application development, production support, database engineering, or performance optimization, with strong hands-on TriZetto Facets experience.
- Must have strong hands-on 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 hands-on experience with Microsoft SQL Server, T-SQL, 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 high-volume, performance-sensitive production batch workloads.
- Good understanding of healthcare payer processing, particularly Claims, Providers, Payments, and adjudication processes.
- Strong root-cause analysis, problem-solving, technical documentation, and stakeholder communication skills.
- Ability to collaborate across application, database, infrastructure, testing, and production support teams.
- 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 large-scale healthcare payer production environments.
- 11.00 Years of Experience
About Company
WE THE TEKWISSEN PEOPLE
TekWissen offers you a broader portfolio of services, industry-leading solutions, and the meaningful innovations that give you greater flexibility and speed to respond to market dynamics, reduced costs and risk to improve enterprise performance, and increased productivity to enable growth.
To keep pace with global market demands, TekWissen keeps its finger on the pulse of change. Our organized approach to guiding a project from its inception to closure. Managing projects is becoming more and more important as we enter the digital era. To cope with the pace that this transition demands, a method is required to manage projects so they can yield quality work, while incorporating efficient use of time and resources.
Project involves identifying which quality standards are relevant to the project and determining how to satisfy them.
It is important to perform quality planning during the Planning Process and should be done alongside the other project planning processes because changes in the quality will likely require changes in the other planning processes, or the desired product quality may require a detailed risk analysis of an identified problem. It is important to remember that quality should be planned, designed, then built in, not added on after the fact.
Capabilities and accomplishments in one TekWissen business enhance the opportunity for success in the others. Put simply, TekWissen's unique combination of attributes promotes success.