Database Architect

Tata Consultancy Services; Bengaluru; On-site; INR 1,200,000 - 2,200,000; Full time

Job summary

Tata Consultancy Services seeks a Database Architect with 8 to 14 years of experience for PAN India operations. You will design end-to-end database architectures for transactional, integration, reporting, and analytics workloads, defining data models, keys, and retention strategies to ensure scalable, secure, and compliant solutions.

You will lead CI/CD, migrations, and cross-team coordination while optimizing performance, availability, and disaster recovery across Azure SQL and SQL Server

Qualifications

• Hands-on expertise in Azure SQL Database, Managed Instance, and SQL Server architecture.
• Ability to design data models and schema standards for OLTP/OLAP workloads.
• Experience with ETL/ELT and Azure Data Factory pipelines.
• Knowledge of data warehousing concepts, star/snowflake schemas, and slowly changing dimensions.
• Proficiency in performance tuning, indexing, and query optimization.
• Security and compliance using Entra ID, RBAC, encryption, auditing, and privileged access controls.

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 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.

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

Tools

Azure Data Factory

ADLS Gen2

Parquet/Delta formats

Power BI

Azure SQL Database

Managed Instance

SQL Server

Job description

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.