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