SQL Server Architect
iqvia · Houston
Job description
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.
- Experience with healthcare technology platforms, SaaS applications, payer organizations, claims processing or revenue cycle solutions is highly preferred; experience as lead database architect for a commercial software product is a significant advantage.
- Must reside in the same country as the job location; U.S. residents only, working within the United States.
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.
- Strong verbal and written communication with clients and senior stakeholders.
Location: hybrid (3 days in office, 2 remote) in Houston, TX or Greenwich, CT, or remote for U.S. candidates. Base pay range of $75,500 to $188,800 annually, depending on qualifications and location.
Questions fréquentes
Why are you reporting this job?
Explore further
Salaries, guides and searches in the United States.
Salaries by job title
- Delivery Specialist 330
- Line Cook 264
- Restaurant Host 251
- Dishwasher 241
- Shift Supervisor 226
- Parts Specialist 208
- Retail Service Specialist 176
- Server - Red Robin 140
Apply in 30 seconds
Enter your email to apply. An account will be created automatically.
By continuing, you accept our terms of use.
Already have an account? Login
A question about this job?
Ask it here: you will get the full job summary by e-mail, right away.
Published 1 week ago
Expires 1 month from now
13 views · 0 interested
Boost your chances
Upload your CV — we will match you with relevant openings.
Analyzing your CV...
iqvia
Houston