Overview
Remote
Depends on Experience
Contract - Independent
Contract - W2
Contract - 12 Month(s)
Skills
(SQL Server / Azure SQL / EAV Optimization)
Job Details
Hi,
Hope you are doing well!
Greeting from Lightning Minds
This is Rakesh with Lightning Minds. We Lightning Minds is a global staff augmentation firm providing a wide-range of talent on-demand and total workforce solutions. We have an immediate opening for the below position with one of our premium clients.
Senior Database Engineer (SQL Server /
Azure SQL / EAV Optimization)
Location: Remote or Hybrid
Department: Engineering Platform & Data
Role Overview
We are seeking an experienced Senior Database Engineer to lead the design, optimization, and
performance engineering of our database systems supporting a large, data-intensive healthcare
application.
This role requires deep expertise in:
SQL Server & Azure SQL
EAV (Entity Attribute Value) schemas and hybrid relational/EAV models
JSON-based schema design
Query optimization, indexing, and performance tuning
Scalability and cost optimization in the cloud
You will be responsible for ensuring our data architecture supports flexibility, scalability, and
high performance while maintaining the integrity and reliability required in cancer registry
workflows and regulated healthcare environments.
Key Responsibilities
Database Design & Architecture
Lead the design and evolution of SQL Server / Azure SQL database schemas for a
complex, high-volume healthcare system.
Architect and optimize:
oEAV (Entity Attribute Value) structures
oHybrid relational + EAV schemas
oJSON-based flexible schemas
Ensure schema designs balance flexibility, query performance, storage efficiency, and
cost.
Develop versioned, scalable database architectures aligned with application and platform
modernization initiatives.
Performance Optimization & Query Tuning
Perform deep-dive analysis and tuning for:
oSQL queries
oStored procedures
oFunctions
oTriggers
oIndexing strategies
Diagnose and resolve performance bottlenecks using:
oQuery Store
oExecution plans
oProfiling tools
oIndex and statistics analysis
Implement best practices for:
oIndexing
oPartitioning
oCaching
oTable design
oQuery optimization
Scalability & Cost Optimization
Design for optimal performance and scale in Azure SQL, focusing on:
oDTU vs vCore decisions
oElastic pools
oPartitioning and sharding strategies
oOffloading heavy queries
Recommend and implement strategies to reduce:
oRead/write latency
oStorage costs
oCompute consumption
oOver-indexing and unnecessary I/O
Work closely with engineering leadership to align database architecture with business
SLAs and budget constraints.
Data Quality, Integrity & Reliability
Develop and maintain data quality validation frameworks.
Implement robust standards for:
oReferential integrity
oConstraints and rules
oAuditing and logging
oBackup/restore and high-availability configurations
Support migration and data transformation activities (e.g., Metriq RI migrations).
DevOps, Automation & CI/CD Integration
Build database automation workflows for:
oSchema deployment
oMigrations
oData movement
oRollback strategies
Use tools such as:
oAzure DevOps
oGitHub Actions
oSQLCMD
oDACPAC/BACPAC
oFlyway or Liquibase (nice-to-have)
Ensure database changes are versioned, tested, and deployed reliably.
Monitoring, Observability & Troubleshooting
Implement and optimize monitoring using:
oAzure Monitor
oSQL Insights
oLog Analytics
oDMVs
Build alerts and dashboards for:
oQuery latency
oDeadlocks
oBlocking
oResource utilization
oCapacity forecasting
Lead root-cause analysis for critical production issues.
Required Skills & Qualifications
Core Database Skills
7 10+ years of hands-on SQL Server / Azure SQL engineering experience.
Expertise in:
oEAV schema design and optimization
oHybrid relational EAV architectures
oJSON schema support in SQL Server
Deep understanding of:
oQuery optimizer behavior
oExecution plans
oIndexing strategies
oNormalization/denormalization
oTable partitioning
Azure Database Expertise
Experience with Azure SQL:
oCompute tiers
oElastic pools
oGeo-replication
oScaling strategies
oMonitoring and diagnostics
Understanding of cost models and optimization levers.
Performance & Optimization
Proven track record of tuning large, complex, query-heavy production systems.
Strong experience resolving:
oSlow queries
oBlocking/deadlocks
oMemory pressure
oI/O bottlenecks
oConcurrency issues
DevOps & Automation
Experience with:
oCI/CD for SQL
oInfrastructure-as-Code for database resources
oDeployment pipelines in Azure DevOps
Familiarity with source-controlled schema management.
Soft Skills
Excellent analytical and problem-solving skills.
Strong communication and documentation skills.
Ability to collaborate with backend engineers, QA, DevOps, and architects.
Ability to operate in fast-paced, mission-critical environments.
Preferred Qualifications
Experience in healthcare, oncology, cancer registry, or regulated systems.
Background in modernizing legacy databases into scalable architectures.
Knowledge of:
oAzure Data Factory
oAzure Service Bus
oEvent-driven data pipelines
Familiarity with microservices patterns and database-per-service design.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.