SQL Server Architect

IQVIA Argentina; Greenwich (CT); Hybrid; USD 76,000 - 189,000; Full time

Job summary

Cedar Gate Technologies, an IQVIA business, is seeking a Senior SQL Server Architect to lead the technical direction of a mission-critical healthcare SaaS platform. The role demands extensive experience with enterprise SQL Server, complex T-SQL, and production support across large data environments.

The ideal candidate will drive scalable technical solutions, collaborate with cross-functional teams, and advance platform modernization while maintaining strong communication with stakeholders in a

Qualifications

• 8+ years of hands-on SQL Server in enterprise production environments.
• Expert-level experience with large, complex T-SQL codebases and stored procedures.
• Strong SQL Server architecture, query optimization, indexing, and performance tuning.
• Experience debugging, troubleshooting, and supporting business-critical SQL Server applications.
• Able to read/understand application code in C# or VB.NET.
• Experience leading database architecture and establishing development standards.
• Healthcare SaaS platforms experience is highly preferred.

Responsibilities

• Serve as the primary technical owner for a large-scale SQL Server environment.
• Analyze, maintain, and enhance complex T-SQL procedures, views, and DB objects with critical logic.
• Develop architectural designs to improve scalability, performance, and reliability.
• Collaborate with Development, Product, Delivery, and QA teams to support enhancements and production operations.
• Perform code reviews and guide on database design and best practices.
• Troubleshoot performance issues using profiling and diagnostic tools.
• Translate business requirements into scalable technical solutions.
• Document technical designs, standards, and procedures.

Skills

SQL Server

T-SQL

Performance tuning

Code reviews

C# / VB.NET

Healthcare SaaS

Architecture

Debugging

Communication

Tools

SQL Server Monitoring

Profiling tools

Diagnostic tools

Job description

Greenwich, United States of America | Full time | Hybrid | R1548883

Cedar Gate Technologies, an IQVIA business, enables payers, providers, employers, and service administrators to excel at value-based care with a unified technology and services platform delivering analytics, care, and payment technology on a single data management foundation. At Cedar Gate, you’ll be part of a collaborative, innovative environment where great ideas thrive. We invest deeply in our people through ongoing training, comprehensive benefits, and a strong culture of teamwork, offering the chance to grow your skills while contributing to high impact initiatives for some of the world's most dynamic companies.

Position Summary

Cedar Gate Technologies, an IQVIA business, is seeking a SQL Server Architect to serve as the technical authority for a mission-critical healthcare SaaS platform used by U. S. healthcare organizations. This role is intended for senior-level SQL Server professionals who have significant experience supporting large-scale production environments and complex T-SQL codebases where substantial business logic resides within the database layer.

As a Senior SQL Server Architect, you will be responsible for the design, performance, stability, and ongoing evolution of a mature healthcare technology platform that processes high volumes of transactional data and supports critical client operations. You will work closely with software developers, quality engineers, and business stakeholders to maintain and enhance a large SQL Server codebase while helping shape future architectural direction.

This is not a traditional SQL Developer, Reporting Analyst, ETL Developer, or Database Administrator role. Candidates who have not worked extensively with enterprise-scale SQL Server applications, complex stored procedure-driven business logic, and production software platforms may not find this position aligned with their experience.

You’ll be joining a team responsible for a mature healthcare SaaS platform where SQL Server plays a central role in application functionality and business processing. This position is best suited for an architect-level SQL Server professional who enjoys solving complex technical challenges, improving large production systems, and influencing the future direction of healthcare technology solutions.

• Serve as the primary technical owner and subject matter expert for a large-scale SQL Server environment supporting a healthcare SaaS application.
• Analyze, maintain, and enhance complex T-SQL stored procedures, functions, views, and database objects containing critical business and healthcare workflow logic.
• Develop architectural recommendations and detailed technical designs that improve scalability, performance, maintainability, and reliability.
• Partner closely with Software Development, Product, Delivery, and Quality Assurance teams to support ongoing application enhancements and production operations.
• Perform code reviews and provide guidance on database design, coding standards, and SQL Server development best practices.
• Troubleshoot and resolve complex application and database performance issues using SQL Server profiling, monitoring, and diagnostic tools.
• Evaluate business and product requirements and translate them into scalable technical solutions.
• Research emerging technologies and provide recommendations regarding platform improvements and modernization opportunities.
• Create and maintain technical documentation, operational procedures, development standards, and knowledge-base content.
• Drive continuous improvement of database architecture, engineering processes, and development practices.
• Effectively communicate technical designs, recommendations, and risks to internal stakeholders, leadership, and clients.

Job Location

Prefer Houston, TX – Hybrid or Greenwich, CT – Hybrid; and

Will also consider those within the United States – Remote

Work Arrangement

Hybrid (3 days in office, 2 remote)

U.S. residents only; work must be performed within the United States.

Experience / Qualifications

• 8+ years of hands‑on experience supporting SQL Server in enterprise production environments.
• Expert‑level experience working within large, complex T‑SQL codebases where business‑critical functionality is implemented through stored procedures and database objects.
• Strong expertise in SQL Server architecture, query optimization, indexing strategies, execution plan analysis, and performance tuning.
• Extensive experience debugging, troubleshooting, and supporting business‑critical SQL Server applications.
• Hands‑on experience using SQL Server monitoring, profiling, and diagnostic tools to identify and resolve performance issues.
• Demonstrated ability to evaluate existing database architectures and develop scalable, maintainable technical solutions.
• Ability to read and understand application code written in C# or VB.NET to support troubleshooting and cross‑functional collaboration.
• Proven experience conducting code reviews and establishing database development standards and best practices.
• Strong verbal and written communication skills, including the ability to participate in technical discussions with clients and senior stakeholders.
• Experience supporting healthcare technology platforms, healthcare SaaS applications, payer organizations, payment integrity solutions, claims processing systems, value‑based care platforms, or revenue cycle solutions is highly preferred.
• Experience serving as the lead database architect or primary database technical owner for a commercial software product is considered a significant advantage.
• Familiarity with healthcare data models, healthcare operational workflows, and high‑volume transactional processing systems is desirable.
• Experience modernizing legacy SQL Server applications and reducing technical debt within mature platforms would be an asset.
• To be eligible for this position, you must reside in the same country where the job is located.

IQVIA is a leading global provider of clinical research services, commercial insights and healthcare intelligence to the life sciences and healthcare industries. We create intelligent connections to accelerate the development and commercialization of innovative medical treatments to help improve patient outcomes and population health worldwide. Learn more at https://jobs.iqvia.com

IQVIA is proud to be an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, status as a protected veteran, or any other status protected by applicable law. https://jobs.iqvia.com/eoe

IQVIA is committed to integrity in our hiring process and maintains a zero tolerance policy for candidate fraud. All information and credentials submitted in your application must be truthful and complete. Any false statements, misrepresentations, or material omissions during the recruitment process will result in immediate disqualification of your application, or termination of employment if discovered later, in accordance with applicable law. We appreciate your honesty and professionalism.

The potential base pay range for this role, when annualized, is $75,500.00 - $188,800.00. The actual base pay offered may vary based on a number of factors including job‑related qualifications such as knowledge, skills, education, and experience; location; and/or schedule (full or part‑time). Dependent on the position offered, incentive plans, bonuses, and/or other forms of compensation may be offered, in addition to a range of health and welfare and/or other benefits.

About Cedar Gate Technologies

Cedar Gate Technologies, an IQVIA business, enables payers, providers, employers, and service administrators to excel at value‑based care with a unified technology and services platform delivering analytics, care, and payment technology on a single data management foundation. At Cedar Gate, you’ll be part of a collaborative, innovative environment where great ideas thrive. We invest deeply in our people through ongoing training, comprehensive benefits, and a strong culture of teamwork, offering the chance to grow your skills while contributing to high impact initiatives for some of the world's most dynamic companies.

Position Summary

Cedar Gate Technologies, an IQVIA business, is seeking a SQL Server Architect to serve as the technical authority for a mission‑critical healthcare SaaS platform used by U. S. healthcare organizations. This role is intended for senior‑level SQL Server professionals who have significant experience supporting large‑scale production environments and complex T‑SQL codebases where substantial business logic resides within the database layer.

As a Senior SQL Server Architect, you will be responsible for the design, performance, stability, and ongoing evolution of a mature healthcare technology platform that processes high volumes of transactional data and supports critical client operations. You will work closely with software developers, quality engineers, and business stakeholders to maintain and enhance a large SQL Server codebase while helping shape future architectural direction.

This is not a traditional SQL Developer, Reporting Analyst, ETL Developer, or Database Administrator role. Candidates who have not worked extensively with enterprise‑scale SQL Server applications, complex stored procedure‑driven business logic, and production software platforms may not find this position aligned with their experience.

You’ll be joining a team responsible for a mature healthcare SaaS platform where SQL Server plays a central role in application functionality and business processing. This position is best suited for an architect‑level SQL Server professional who enjoys solving complex technical challenges, improving large production systems, and influencing the future direction of healthcare technology solutions.

Roles & Responsibilities

• Serve as the primary technical owner and subject matter expert for a large‑scale SQL Server environment supporting a healthcare SaaS application.
• Analyze, maintain, and enhance complex T‑SQL stored procedures, functions, views, and database objects containing critical business and healthcare workflow logic.
• Develop architectural recommendations and detailed technical designs that improve scalability, performance, maintainability, and reliability.
• Partner closely with Software Development, Product, Delivery, and Quality Assurance teams to support ongoing application enhancements and production operations.
• Perform code reviews and provide guidance on database design, coding standards, and SQL Server development best practices.
• Troubleshoot and resolve complex application and database performance issues using SQL Server profiling, monitoring, and diagnostic tools.
• Evaluate business and product requirements and translate them into scalable technical solutions.
• Research emerging technologies and provide recommendations regarding platform improvements and modernization opportunities.
• Create and maintain technical documentation, operational procedures, development standards, and knowledge‑base content.
• Drive continuous improvement of database architecture, engineering processes, and development practices.
• Effectively communicate technical designs, recommendations, and risks to internal stakeholders, leadership, and clients.

Job Location

Prefer Houston, TX – Hybrid or Greenwich, CT – Hybrid; and

Will also consider those within the United States – Remote

Work Arrangement

Hybrid (3 days in office, 2 remote)

U.S. residents only; work must be performed within the United States.

Experience / Qualifications

• 8+ years of hands‑on experience supporting SQL Server in enterprise production environments.
• Expert‑level experience working within large, complex T‑SQL codebases where business‑critical functionality is implemented through stored procedures and database objects.
• Strong expertise in SQL Server architecture, query optimization, indexing strategies, execution plan analysis, and performance tuning.
• Extensive experience debugging, troubleshooting, and supporting business‑critical SQL Server applications.
• Hands‑on experience using SQL Server monitoring, profiling, and diagnostic tools to identify and resolve performance issues.
• Demonstrated ability to evaluate existing database architectures and develop scalable, maintainable technical solutions.
• Ability to read and understand application code written in C# or VB.NET to support troubleshooting and cross‑functional collaboration.
• Proven experience conducting code reviews and establishing database development standards and best practices.
• Strong verbal and written communication skills, including the ability to participate in technical discussions with clients and senior stakeholders.
• Experience supporting healthcare technology platforms, healthcare SaaS applications, payer organizations, payment integrity solutions, claims processing systems, value‑based care platforms, or revenue cycle solutions is highly preferred.
• Experience serving as the lead database architect or primary database technical owner for a commercial software product is considered a significant advantage.
• Familiarity with healthcare data models, healthcare operational workflows, and high‑volume transactional processing systems is desirable.
• Experience modernizing legacy SQL Server applications and reducing technical debt within mature platforms would be an asset.
• To be eligible for this position, you must reside in the same country where the job is located.

IQVIA is a leading global provider of clinical research services, commercial insights and healthcare intelligence to the life sciences and healthcare industries. We create intelligent connections to accelerate the development and commercialization of innovative medical treatments to help improve patient outcomes and population health worldwide. Learn more at https://jobs.iqvia.com

IQVIA is proud to be an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, status as a protected veteran, or any other status protected by applicable law. https://jobs.iqvia.com/eoe

IQVIA is committed to integrity in our hiring process and maintains a zero tolerance policy for candidate fraud. All information and credentials submitted in your application must be truthful and complete. Any false statements, misrepresentations, or material omissions during the recruitment process will result in immediate disqualification of your application, or termination of employment if discovered later, in accordance with applicable law. We appreciate your honesty and professionalism.

The potential base pay range for this role, when annualized, is $75,500.00 - $188,800.00. The actual base pay offered may vary based on a number of factors including job‑related qualifications such as knowledge, skills, education, and experience; location; and/or schedule (full or part‑time). Dependent on the position offered, incentive plans, bonuses, and/or other forms of compensation may be offered, in addition to a range of health and welfare and/or other benefits.

Where you'll work

Hybrid

You’ll split your time between home and the office, giving you the flexibility to focus where you work best while still building strong in‑person connections with your team. This model combines the autonomy of remote work with the collaboration, energy and resources of an office environment.

Where you'll make an impact

Cedar Gate Technologies

At Cedar Gate Technologies, an IQVIA business, you’ll help transform healthcare through advanced analytics and value‑based care solutions. You’ll work with cutting‑edge data platforms and insights to help healthcare organizations improve outcomes, reduce costs and deliver more effective, patient‑centered care.

"I like that we’re different. I like that we’re a unique organization unlike any other. I like to think of us as the intelligence company for life sciences and healthcare. I do believe there’s nothing else like this organization in the world. So if you like something that’s different and interesting, you’re going to like IQVIA. If you like an organization that has a variety of opportunities, from IT to big data to AI to finance to HR, there are so many opportunities to have an impact."

"The culture in IQVIA is to be constantly looking at how we can do things better to help our customers, to bring life‑changing medicines to patients and also to be a part in designing and developing and implementing these solutions. And so I think it’s a great place to join because there is that organizational focus and commitment in driving forward the innovation and just the ability, I think, to work with cross‑functional teams who are all excited to be working in these areas. It’s a fantastic opportunity."

"First of all, we are humans, we have some moments in our lives that are so very important and we need to respect. And something I also always love about IQVIA was that my leaders and people with which I have been working, they always respected a lot as well our personal lives. I never miss a parents’ meeting of my kids, and this is something that we shouldn’t be giving for granted."

Senior Director Global Site Activation

"I like that we’re different. I like that we’re a unique organization unlike any other. I like to think of us as the intelligence company for life sciences and healthcare. I do believe there’s nothing else like this organization in the world. So if you like something that’s different and interesting, you’re going to like IQVIA. If you like an organization that has a variety of opportunities, from IT to big data to AI to finance to HR, there are so many opportunities to have an impact."

Culture

Culture at IQVIA is built on a shared belief: that when people are empowered with better data, smarter technology and deeper expertise, they can change what’s possible for patients. Across every team and every corner of the globe, you’ll find colleagues who genuinely care — about the mission and about each other. That’s what makes this a place where people tend to stay, grow and do the best work of their careers.

Greenwich, United States of America | Hybrid