DB Architect

🚨 We’re Hiring: DB Architect | Chennai | UK Shift | C2C | Immediate Joiners Preferred

We are looking for an experienced DB Architect / Database Administrator to own the complete data layer for enterprise healthcare web applications — from schema design and migration management to indexing strategy and batch pipeline support.

Location: Chennai

Shift: UK Shift | 1:30 PM – 10:30 PM IST

Experience: 8–10 Years

Employment: C2C | Full-time Contract

Joining: Immediate or within 15 Days Preferred

Key Responsibilities

• Schema Design & Architecture Design and maintain schemas for both OLTP and reporting workloads 
• Create scalable time-series compliance data models for healthcare analytics 
• Implement snapshot and fact table patterns for trend dashboards 
• Ensure extensible schema design for future AI/LLM implementations 
• Define strategy for JSON storage vs normalization 

Migration Management 

• Write and maintain immutable, sequential migration scripts using DbUp 
• Ensure clean, idempotent migration history across all environments 

Performance & Indexing 

• Design optimized indexes for high-volume reporting and dashboard queries 
• Define partitioning strategies for large, append-heavy tables 
• Develop and optimize stored procedures and views for performance 

Batch Pipeline Support 

• Design schemas supporting idempotent batch jobs and upsert logic 
• Implement watermarking and run-tracking tables for data pipelines 
• Collaborate with data engineering teams for schema validation 

Compliance & Security 

• Implement HIPAA-compliant database practices for PHI data 
• Maintain audit trail tables and detailed access logging 
• Enforce encryption at rest and minimum-necessary access principles 

Must-Have Skills

• Technical Expertise Azure SQL / SQL Server 
• Database Architecture & Schema Design 
• Performance Tuning, Indexing & Partitioning Strategies 
• Stored Procedures & Views 
• DbUp / Flyway Migration Tools 
• Time-Series & Fact Table Modeling, JSON Column Handling 
• Batch Pipeline Support & Upsert Logic 

Healthcare Domain 

• HIPAA Compliance & PHI Data Handling 
• Audit Logging & Security Standards 

Preferred Skills

• Dimensional Modeling | Star/Snowflake
• Schema 
• EHR Integration Experience 
• AI/LLM Data Modeling Exposure 
• Healthcare or Health-Tech Industry Experience 

Education

Bachelor’s Degree in Computer Science, Information Systems, or equivalent experience.

• #DBArchitect #AzureSQL #SQLServer #HealthcareIT #ChennaiJobs #UKShift #Hiring #ImmediateJoiner