# SQL Database Developer

> ProArch · Atlanta, United States (Remote) · Contract · Posted 2026-07-29

**Salary:** USD 130,000–150,000

**Workplace:** remote

**Department:** Sushma Delivery

## Description

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.

## Apply

[Apply at ProArch](https://apply.workable.com/proarch-3/j/8A26983DDB/apply)

---
Powered by [Workable](https://www.workable.com)