# SQL Server Architect

**Company**: Cedar Gate Technologies, an IQVIA business
**Location**: Houston, TX
**Work arrangement**: hybrid
**Experience**: senior
**Job type**: full-time
**Salary**: $75,500.00 - $188,800.00
**Category**: Engineering
**Industry**: Healthcare

**Apply**: https://iqvia.wd1.myworkdayjobs.com/en-US/IQVIA/job/Houston-Texas-United-States-of-America/SQL-Server-Architect_R1548883?utm_source=yubhub.co&utm_medium=jobs_feed&utm_campaign=apply
**Canonical**: https://yubhub.co/jobs/job_2f14ee83-1ae

## Description

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.

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.

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.

Requirements:

- 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.

Benefits:

- Comprehensive benefits package

- Ongoing training and development opportunities

- Collaborative and innovative work environment

## Skills

### Required
- SQL Server
- T-SQL
- database architecture
- query optimization
- performance tuning

### Nice to have
- healthcare technology platforms
- healthcare SaaS applications
- payer organizations
- payment integrity solutions
- claims processing systems
- value-based care platforms
- revenue cycle solutions

---

Source: [Apply at iqvia.wd1.myworkdayjobs.com](https://iqvia.wd1.myworkdayjobs.com/en-US/IQVIA/job/Houston-Texas-United-States-of-America/SQL-Server-Architect_R1548883?utm_source=yubhub.co&utm_medium=jobs_feed&utm_campaign=apply)