SQL Database Developer

Job not on LinkedIn

🔥 20 minutes ago

🇺🇸 United States – Remote

⏳ Contract/Temporary

🟠 Senior

🔴 Lead

🔙 Backend Engineer

🦅 H1B Visa Sponsor

This company has sponsored H1B visas in the past.

Apply Now

Find Similar Remote Jobs

Set Up Email Alert For New Jobs

📊 Check your resume score for this job

Improve your chances of getting an interview by checking your resume score before you apply.

Upload Resume

ProArch

WebsiteLinkedInAll Job Openings

201 - 500 employees

💼 Consulting

🏥 Healthcare

🏭 Manufacturing

Consulting • Healthcare • Manufacturing

ProArch is a technology company that specializes in providing digital engineering, cloud services, data and AI solutions, and cybersecurity measures. They help businesses unleash their full potential by modernizing operations, protecting assets, and delivering data-driven insights. ProArch works closely with clients to eliminate roadblocks to growth and aligns advanced technology solutions with business goals to empower organizational success. As an award-winning Microsoft Gold Partner, they offer a wide range of services including AI consulting, software development, quality assurance, infrastructure management, governance, risk, and compliance solutions, and operational technology services. Their expertise extends to industries such as credit unions, power generation, and manufacturing, providing tailored solutions to meet each sector's unique challenges.

📋 Description

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

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