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, back

📌 Database Architect (Bengaluru)
🏢 Tata Consultancy Services
📍 Bengaluru