MS SQL Server Database Architect (CDC expertise)

MBI Digital Corp; United States; Remote; USD 108,000 - 181,000; Full time

Job summary

A leading company is seeking an MS SQL Server Database Architect with strong CDC expertise. This remote role involves designing data pipelines and ensuring data integrity between systems. Ideal candidates will have extensive experience with MS SQL Server and knowledge of healthcare data systems. Join a dynamic team and contribute to innovative data solutions.

Qualifications

• 5+ years of experience as a database architect focusing on MS SQL Server and CDC.
• Extensive experience with MS SQL Server and CDC configuration.

Responsibilities

• Design and implement CDC architecture for data synchronization.
• Lead CDC setup and configuration within MS SQL Server.

Skills

Communication

Problem Solving

Education

Bachelor’s degree in Computer Science

Master’s degree

Tools

MS SQL Server

Abacus Insights

Job description

MS SQL Server Database Architect (CDC expertise)

MS SQL Server Database Architect (CDC expertise)

Get AI-powered advice on this job and more exclusive features.

Direct message the job poster from MBI Digital Corp

MBI Digital is looking for an MS SQL Server Database Architect with total work experience of 10+ yrs and minimum 5+ yrs of related experience as a database architect with a focus on MS SQL Server and CDC implementation.

The candidate will play a pivotal role in designing and implementing 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, and supporting data integrity and performance optimization throughout the integration. Experience with TriZetto Facets and the Abacus Insights platform is a strong plus.

This is a 100% remote opportunity with 6 months project engagement with possibility of extension. The candidate should be willing to work in the Pacific time zone.

Job Responsibilities:

• 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.
• Facets & Abacus Integration: 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:
• Bachelor’s degree in Computer Science, Information Systems, or a related field.
• Master’s degree is a plus.
• Technical Skills:
• Extensive experience with MS SQL Server, including hands-on expertise in configuring and managing Change Data Capture (CDC).
• Strong understanding of SQL Server database architecture, performance tuning, and optimization.
• Proficiency in integrating MS SQL Server with data platforms such as Abacus Insights or similar solutions.
• Knowledge of ETL processes, data replication, and data migration strategies.
• Experience:
• 5+ years of experience as a database architect with a focus on MS SQL Server and CDC implementation.
• Experience in healthcare or insurance-related data systems, especially with Facets, is a strong advantage.
• Experience with the Abacus Insights platform is a plus.
• Soft Skills:
• Excellent communication and collaboration skills, with the ability to translate technical concepts to non-technical stakeholders.
• Strong analytical and problem-solving abilities, with a keen attention to detail.

Seniority level

• Seniority level

  Mid-Senior level

Employment type

• Employment type

  Full-time

Job function

• Job function

  Information Technology

Referrals increase your chances of interviewing at MBI Digital Corp by 2x

Get notified about new Database Architect jobs in United States.

United States $108,100.00-$180,600.00 5 days ago

United States $120,000.00-$160,000.00 5 days ago

National Harbor, MD $140,000.00-$240,000.00 1 week ago

Georgia, United States $144,900.00-$144,900.00 1 week ago

New York, NY $140,000.00-$160,000.00 4 months ago

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.