Database Architect

Database Architect - 8 to 14 years of experience - PAN India
Responsibilities
Design end-to-end database architecture for transactional, integration, reporting, and analytics workloads.
Define data models, schema standards, keys, constraints, indexing, partitioning, and lifecycle controls.
Architect scalable Azure SQL and SQL Server solutions with suitable sizing, connectivity, and topology.
Design reusable Azure Data Factory ETL/ELT frameworks with incremental loads, CDC, reconciliation, recovery, and error handling.
Drive performance through workload analysis, indexing, query tuning, deadlock resolution, and capacity planning.
Implement database security and compliance using Entra ID, RBAC, encryption, auditing, and privileged-access controls.
Define availability, backup, disaster recovery, retention, monitoring, patching, and operational runbooks.
Lead design reviews, migrations, CI/CD, releases, documentation, and cross-team coordination.
Required Skills
Azure SQL, SQL Server, T-SQL, data modelling, ETL/ELT, Azure Data Factory, data warehousing, ADLS Gen2, performance tuning, HA/DR, security and CI/CD
Must-Have Hands-on expertise in Azure SQL Database, Managed Instance, and SQL Server architecture, administration, and engineering.
Database design and modelling, including normalized, dimensional, star/snowflake schemas, facts, dimensions, and slowly changing dimensions.
Advanced T-SQL, procedures, functions, execution plans, indexing, partitioning, statistics, concurrency analysis, and query optimization.
Azure Data Factory ETL/ELT architecture, including parameterized pipelines, runtimes, triggers, dependencies, incremental loads, CDC, retries, and recovery.
Data warehouse and lake integration using ADLS Gen2, Parquet/Delta formats, partitioning, and curated layers.
Database security with Entra ID, RBAC, managed identities, private endpoints, encryption, masking, auditing, Key Vault, and least privilege.
High availability, backup/restore, disaster recovery, archival, retention, capacity planning, monitoring, and production support.
Database DevOps with source control, schema versioning, automated deployment, validation, rollback, and controlled promotion across environments.
Good to have skills
Experience with Microsoft Fabric, Synapse, Databricks, Delta Lake, Purview, and Lakehouse patterns.
Experience in database migration and modernization using Azure DMS, DMA, or similar tools.
Knowledge of Power BI models, API data access, Redis caching, and event-driven integration.
Azure data certifications and experience in FinOps, governance, lineage, and security reviews.

Work arrangement
No