MS SQL Server Database Architect (CDC Expertise) - Remote

Job Title: MS SQL Server Database Architect (CDC Expertise)
Client: Providence Health Care
Location: Remote

Position Overview:

The MS SQL Server Database Architect will proactively lead the design and implementation of Change Data Capture (CDC) processes between the TriZetto Facets database and the Abacus Insights platform. This role will involve designing an efficient data pipeline, ensuring data synchronization, efficient and accurate data replication, and supporting data integrity and performance optimization throughout the integration. Experience with TriZetto Facets and the Abacus Insights platform is a strong plus.

Key Responsibilities:
 Proactive Leadership: Guide the CDC integration, understanding where the issues are and propose potential solutions, and then take positive and proactive steps to keep it operational and efficient.
 Architect and Design Data Flow: Design and implement a robust architecture for Change Data Capture (CDC) to enable data synchronization between the TriZetto Facets database and the Abacus Insights data platform.
 Implement CDC: Lead the setup and configuration of CDC within MS SQL Server to ensure efficient and accurate data replication, capturing inserts, updates, and deletes from the Facets database. Understand the impacts of upgrades, data refreshes, patching and other activities on the health of the data integration.
 Facets & Abacus Integration: Look at the data ecosystem holistically to maximize the efficiency of the AbacPHP data partnership and minimize maintenance. Collaborate with internal teams and external partners to ensure seamless CDC integration between Facets and the Abacus Insights data platform, leveraging the strengths of both systems.
 Data Quality & Integrity: Implement monitoring and validation mechanisms to ensure high-quality and consistent data across systems.
 Optimize Performance: Tune the CDC process for optimal performance, minimizing resource usage and ensuring data integrity throughout the pipeline.
 Documentation & Best Practices: Create detailed technical documentation on the CDC architecture and data flow processes. Establish and enforce best practices for future CDC implementations and system scalability.
 Troubleshooting & Support: Quickly identify and resolve any technical issues during the CDC implementation and post-launch to ensure ongoing functionality.
 Training and Knowledge Transfer: Provide training and guidance to internal teams to ensure they are well-versed in CDC technology and processes.

Required Qualifications:

 Education:
o Bachelor’s degree in Computer Science, Information Systems, or a related field.
o Master’s degree is a plus.

 Technical Skills:
o Extensive experience with MS SQL Server, including hands-on expertise in configuring and managing Change Data Capture (CDC).
o Strong understanding of SQL Server database architecture, performance tuning, and optimization.
o Proficiency in integrating MS SQL Server with data platforms such as Abacus Insights or similar solutions.
o Knowledge of ETL processes, data replication, and data migration strategies.

 Experience:
o 5+ years of experience as a database architect with a focus on MS SQL Server and CDC implementation.
o Experience in healthcare or insurance-related data systems, especially with Facets, is a strong advantage.
o Experience with the Abacus Insights platform is a plus.

 Soft Skills:
o Ability to think beyond the database, with excellent communication and collaboration skills and the ability to translate technical concepts to non-technical stakeholders.
o Strong analytical and problem-solving abilities, with the ability to look at the data ecosystem holistically.