Job ID: JOB_ID_6040
Job Title: MS SQL Server Database Architect
We are seeking a highly skilled and experienced MS SQL Server Database Architect with a strong focus on Change Data Capture (CDC) implementation. This is a 100% remote, contract-to-hire position with an initial duration of 6-12 months. The ideal candidate will have extensive experience in designing, implementing, and managing complex SQL Server environments, with a particular emphasis on healthcare or insurance-related data systems.
Required Qualifications:
- Education: Bachelors degree in Computer Science, Information Systems, or a related field. A Masters 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.
About the Role:
As a MS SQL Server Database Architect, you will be responsible for the overall design, development, and maintenance of our SQL Server databases. You will play a critical role in ensuring data integrity, performance, and security. Your expertise in CDC will be crucial for enabling real-time data synchronization and supporting various business intelligence and analytics initiatives. You will work closely with development teams, data engineers, and business stakeholders to understand data requirements and translate them into robust database solutions.
Key Responsibilities:
- Design and implement scalable and high-performance MS SQL Server database solutions.
- Configure, manage, and monitor Change Data Capture (CDC) for various data sources.
- Optimize database performance through query tuning, indexing strategies, and server configuration.
- Collaborate with application developers to ensure efficient database utilization and integration.
- Develop and maintain ETL processes for data ingestion, transformation, and loading.
- Ensure data security and compliance with relevant regulations.
- Troubleshoot and resolve database-related issues.
- Document database architecture, configurations, and processes.
- Stay up-to-date with the latest SQL Server features and best practices.
Why Join Us?
This is an excellent opportunity to work on challenging projects in a remote setting. You will have the chance to leverage your expertise in MS SQL Server and CDC to make a significant impact. We offer a competitive compensation package and a collaborative work environment.
Special Requirements
100% REMOTE, 6-12 months contract, Healthcare or insurance-related data systems experience is a strong advantage, Facets experience is a strong advantage, Abacus Insights platform experience is a plus.
Compensation & Location
Salary: $120,000 – $160,000 per year (Estimated)
Location: Remote
Recruiter / Company – Contact Information
Email: ruiter.surya.rci@gmail.com
Recruiter Notice:
To remove this job posting, please send an email from
ruiter.surya.rci@gmail.com with the subject:
DELETE_JOB_ID_6040