SQL Database Developer

6 days, 1 hour ago
Contract
Lead
Data Science and Analytics
ProArch

ProArch

At ProArch, we help our clients accelerate growth and mitigate risk with IT services, cybersecurity services, application development, cloud computing, and data analytics. ProArch was founded on the belief that a future where change is ‘business as usu...

Internet Software & Services
251-1K
Founded 2006

Description

  • Design, develop, and maintain complex SQL Server databases for enterprise healthcare applications.
  • Create and optimize schemas, tables, indexes, views, stored procedures, functions, and triggers.
  • Develop scalable data models for patient, provider, care management, clinical, and operational workflows.
  • Analyze and resolve database performance bottlenecks and optimize T-SQL queries and stored procedures.
  • Design indexing and execution-plan strategies to improve application response times and support SLAs.
  • Assess database scalability needs and implement partitioning, archiving, caching, and lifecycle strategies.
  • Collaborate with technical architects, application teams, API teams, and integration teams on database solutions.
  • Support healthcare interoperability initiatives, including FHIR-based data structures and ETL processes.
  • Design reporting databases, operational data stores, SQL reporting solutions, and data extracts.
  • Implement database security controls, access management, encryption, and compliance with HIPAA and data privacy requirements.

Requirements

  • 8+ years of SQL Server development experience.
  • 5+ years of experience working on enterprise-scale applications.
  • Experience supporting systems with high transaction volumes and large datasets.
  • Proven experience in database performance tuning and optimization.
  • Experience working closely with application development teams.
  • Hands-on experience with Microsoft SQL Server 2016/2019/2022.
  • Strong T-SQL programming experience with stored procedures, views, triggers, and functions.
  • Experience with query optimization, index tuning, execution plan analysis, locking and blocking analysis, and deadlock resolution.
  • Experience with database performance monitoring, partitioning, capacity planning, and high availability/disaster recovery.
  • Experience with SSIS, ETL development, REST API data integrations, data migration strategies, CI/CD for database deployments, SSRS, Power BI, operational reporting, and data warehousing concepts.
  • Preferred: healthcare industry experience.
  • Preferred: knowledge of HL7 and FHIR standards.
  • Preferred: experience with EHR/EMR platforms.
  • Preferred: expertise in Azure SQL and cloud database architectures.
  • Preferred: experience supporting care management, population health, or patient engagement platforms.
  • Preferred: familiarity with Azure Data Factory and modern data platform technologies.

Interested in this position?

Apply directly on the company website

Apply Now

Similar Roles

Snowflake Data Consultant - Higher Education

Attain Partners 251-1K Media

Attain Partners is hiring a Snowflake Contractor to support its higher education data warehouse environment with ongoing technical support, architecture guidance, and development work as the platform expands.

Snowflake SQL Tableau
1 day, 1 hour ago

2026-1616 Oracle EBS Technical Consultant

Highstreet IT 51-250 Internet Software & Services

Oracle EBS Technical Consultant at an enterprise-focused organization, responsible for building, customizing, and supporting Oracle E-Business Suite technical solutions and related integrations.

Agile REST API Scrum SQL
3 days, 2 hours ago

Data Governance Lead - Remote in Colorado

Trace3 1K-5K Internet Software & Services

Trace3 is hiring a Data Governance Lead to develop and roll out an enterprise-wide governance framework for a remote Colorado project focused on compliance, stewardship, and accountability.

HIPAA
4 days, 1 hour ago

Senior, Database Engineer, Fixed Term - Toronto

DEPT® 1K-5K Media

DEPT® is seeking a Senior Database Engineer for a 3-month contract in Ontario to remediate and harden a MySQL-based production platform for a global financial news and data client.

MySQL
5 days, 1 hour ago

You're on a roll! Sign up now to keep applying.

Sign Up

Already have an account? Log in

Used by 14,729+ remote workers