Key Responsibilities
Database Design & Development
- Design, develop, and maintain complex SQL Server databases supporting enterprise healthcare applications.
- Create and optimize database schemas, tables, indexes, views, stored procedures, functions, and triggers.
- Develop scalable data models supporting patient, provider, care management, clinical, and operational workflows.
- Ensure database structures support evolving business and regulatory requirements.
Performance Optimization
- Analyze and resolve database performance bottlenecks.
- Optimize complex T-SQL queries and stored procedures.
- Design indexing strategies to improve application response times.
- Perform execution plan analysis and SQL code optimization.
- Monitor database performance and proactively identify areas for improvement.
- Support high-volume transactional workloads while maintaining performance SLAs.
Scalability & Capacity Planning
- Assess current database limitations and recommend scalability improvements.
- Design solutions capable of supporting increased user concurrency and transaction volumes.
- Implement partitioning, archiving, caching, and data lifecycle strategies.
- Optimize database architecture for future platform growth and new feature rollouts.
- Collaborate with Technical Architects to define long-term database modernization strategies.
Healthcare Data & Integrations
- Support healthcare interoperability initiatives using FHIR standards.
- Develop and optimize ETL processes for healthcare data exchange.
- Design database structures supporting FHIR resources and healthcare integrations.
- Work with API and integration teams to ensure efficient data access patterns.
- Ensure compliance with healthcare data governance and security requirements.
Reporting & Analytics
- Design and optimize reporting databases and operational data stores.
- Develop SQL-based reporting solutions and data extracts.
- Support Power BI and enterprise reporting initiatives.
- Create scalable reporting mechanisms that minimize application performance impact.
Data Security & Compliance
- Implement database security best practices.
- Manage data access controls and encryption strategies.
- Ensure compliance with HIPAA and healthcare data privacy regulations.
- Participate in audits and compliance reviews.
Requirements
Required Qualifications
Experience
- 8+ years of SQL Server development experience.
- 5+ years working on enterprise-scale applications.
- Experience supporting systems with high transaction volumes and large datasets.
- Proven track record of database performance tuning and optimization.
- Experience working closely with application development teams.
- Microsoft SQL Server 2016/2019/2022
- T-SQL Programming
- Stored Procedures
- Views
- Triggers
- Functions
- Query Optimization
- Index Tuning
- Database Performance Monitoring
- Performance & Scalability
- Execution Plan Analysis
- Database Partitioning
- Index Strategy Design
- Locking and Blocking Analysis
- Deadlock Resolution
- Capacity Planning
- High Availability and Disaster Recovery
- Development & Integration
- SQL Server Integration Services (SSIS)
- ETL Development
- REST API Data Integrations
- Data Migration Strategies
- CI/CD for Database Deployments
- SQL Reporting Services (SSRS)
- Power BI
- Operational Reporting
- Data Warehousing Concepts
Preferred Qualifications
- Healthcare industry experience.
- Knowledge of HL7 and FHIR standards.
- Experience with Electronic Health Record (EHR/EMR) platforms.
- Expertise in Azure SQL and cloud database architectures.
- Experience supporting care management, population health, or patient engagement platforms.
- Familiarity with Azure Data Factory and modern data platform technologies.
Key Deliverables
- During the first 90 days, the successful candidate will:
- Complete a database health and performance assessment.
- Identify and resolve critical performance bottlenecks.
- Optimize high-impact stored procedures and queries.
- Establish database monitoring and performance baselines.
- Create a database scalability roadmap.
- Implement indexing and data access optimization strategies.
- Support new healthcare integration and reporting initiatives.
- Improve data quality and reliability across the platform.
Success Metrics
- Reduction in database response times.
- Improved application performance and user experience.
- Increased concurrent user capacity.
- Reduction in production database incidents.
- Faster reporting and analytics execution.
- Improved scalability to support future platform growth.
- High data quality, security, and system reliability.
