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