SQL Server Architect

About the role

Cedar Gate Technologies, an IQVIA business, is looking for a SQL Server Architect to act as the technical authority for a mission-critical healthcare SaaS platform used by U.S. healthcare organizations. The role suits senior SQL Server professionals with extensive experience in large-scale production environments and complex T-SQL codebases. It is not a traditional SQL developer, reporting analyst, ETL developer or database administrator role.

Key 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 with Software Development, Product, Delivery and Quality Assurance teams on application enhancements and production operations.
• Perform code reviews and guide database design, coding standards and SQL Server development best practices.
• Troubleshoot performance issues using SQL Server profiling, monitoring and diagnostic tools.
• Translate business and product requirements into scalable technical solutions and research emerging technologies for platform improvements.
• Create and maintain technical documentation, operational procedures, development standards and knowledge-base content.
• Communicate technical designs, recommendations and risks to stakeholders, leadership and clients.

Required profile

• 8+ years of hands-on experience supporting SQL Server in enterprise production environments.
• Expert experience in large, complex T-SQL codebases with business-critical functionality in stored procedures and database objects.
• Ability to read and understand C# or VB.NET application code.
• Proven experience conducting code reviews and establishing database development standards.
• Strong verbal and written communication skills, including with clients and senior stakeholders.
• U.S. resident only; hybrid (3 days in office, 2 remote) in Houston, TX or Greenwich, CT, or remote within the U.S.

Required skills

• SQL Server architecture, query optimization, indexing strategies and execution plan analysis.
• Performance tuning and debugging of SQL Server applications.
• Use of SQL Server monitoring, profiling and diagnostic tools.
• Preferred: healthcare SaaS, payer, claims processing or revenue cycle experience, and experience modernizing legacy SQL Server applications.

The potential base pay range is $75,500 to $188,800 per year, depending on qualifications, location and schedule.