Database Architect

About the Role\n\nWe are seeking an experienced DatabaseAdministrator (DBA) with strong expertise in Azure SQL and SQL Server to manageand optimize the data layer for enterprise web applications. The ideal candidate will be responsible for end-to-end database ownership, including schema design,migration management, performance optimization, indexing strategies, security compliance, and batch pipeline support.\nThis role requires close collaboration with backend engineers, data engineers, and product stakeholders to ensure scalable, secure, and high-performing database systems that support both transactional and reporting workloads.\nRoles & Responsibilities:\nSchema Design& Database Architecture\nDesign and maintain scalable database schemas supporting both OLTP workloads and analytical/reporting workloads.\nDevelop optimized structures for time-series compliance and reporting data, enabling efficient range-based querying.\nImplement snapshot and fact-table patterns to support dashboard reporting and trend analysis.\nEnsure schema extensibility for future AI/LLM-based quality scoring implementations, including semi-structured data handling using JSON or normalized models.\nBuild scalable data models for clinician, site, compliance, and document-related analytics.\nMigration Management\nDevelop and maintain immutable sequential migration scripts using DbUp.\nEnsure migration consistency and idempotent deployments across development, staging, and production environments.\nMaintain clean migration history and version control best practices.\nPerformance Optimization & Indexing\nDesign and optimize indexes for high-volume dashboard and reporting queries. Define and implement partitioning strategies for large append-heavy tables.\nWrite and optimize stored procedures, views, and database objects supporting API and reporting layers.