ProArch - SQL Database Developer

Database Developer is needed in Atlanta, United States.

Client: ProArch

Location: Atlanta, GA

Contract: Contract

Job Description

The role involves designing, developing, and maintaining complex SQL Server databases that support enterprise healthcare applications. Key responsibilities include database design and development, performance optimization, scalability and capacity planning, healthcare data integrations, reporting and analytics, and ensuring data security and compliance.

Requirements

Required Qualifications

• 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.
• Proficient in Microsoft SQL Server 2016/2019/2022, T-SQL programming, stored procedures, views, triggers, functions, query optimization, and index tuning.
• Experience with database performance monitoring, scalability, execution plan analysis, database partitioning, index strategy design, locking and blocking analysis, deadlock resolution, capacity planning, and high availability/disaster recovery.
• Development and integration experience with SQL Server Integration Services (SSIS), ETL development, REST API data integrations, and data migration strategies.
• CI/CD for database deployments, SQL Reporting Services (SSRS), Power BI, operational reporting, and 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

• Complete a database health and performance assessment within the first 90 days.
• 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.