Database Architect

Tata Consultancy Services Limited

Pune District, Chennai, Bengaluru

Remote

INR 3,000,000 - 6,000,000

Full time

14 days+

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

Tata Consultancy Services Limited in Pan India is seeking a seasoned Database Architect with 10-15 years of experience to design and oversee Azure SQL/SQL Server architectures for transactional, reporting, and analytics workloads. The role focuses on scalable data platforms, security, and data governance across the Azure stack.

You will define data models, optimize performance, drive CI/CD for database deployments, and lead cross-team design reviews, migrations, and DR planning.

Qualifications

  • Solid experience designing end-to-end database architectures for transactional and analytics workloads.
  • Proficient in Azure SQL and SQL Server with advanced T-SQL and indexing.
  • Experience with Azure Data Factory ETL/ELT pipelines and data warehousing.
  • Strong knowledge of security, identity, and data protection (Entra ID, RBAC, Key Vault).

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.

Skills

Azure SQL
SQL Server
T-SQL
Data modeling
ETL/ELT
Azure Data Factory
Data warehousing
Performance tuning
HA/DR
Security & CI/CD

Tools

Microsoft Fabric
Synapse
Databricks
Delta Lake
Purview

Job description

Role- Database Architect
Desired Experience Range- 10-15 Years
Location- Pan India
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.
Required Technical Skill Set-

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

Good-to-Have
  • 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.
Roles & REsponsibilies-
  1. Design end-to-end database architecture for transactional, integration, reporting, and analytics workloads.
  2. Define data models, schema standards, keys, constraints, indexing, partitioning, and lifecycle controls.
  3. Architect scalable Azure SQL and SQL Server solutions with suitable sizing, connectivity, and topology.
  4. Design reusable Azure Data Factory ETL/ELT frameworks with incremental loads, CDC, reconciliation, recovery, and error handling.
  5. Drive performance through workload analysis, indexing, query tuning, deadlock resolution, and capacity planning.
  6. Implement database security and compliance using Entra ID, RBAC, encryption, auditing, and privileged-access controls.
  7. Define availability, backup, disaster recovery, retention, monitoring, patching, and operational runbooks.
  8. Lead design reviews, migrations, CI/CD, releases, documentation, and cross-team coordination.
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Database Engineer
Database Engineer

Harbinger Systems • Pune District

Hybrid
INR 1,500,000 - 2,300,000
Azure Data Architect/Team Lead
Azure Data Architect/Team Lead

Tata Consultancy Services Limited • Hyderabad, Chennai, Bengaluru

On-site
INR 4,000,000 - 7,000,000
Data Architect (SQL)
Data Architect (SQL)

InfoBeans • Indore District, Pune District

On-site
INR 2,000,000 - 3,200,000
Data Architect
Data Architect

Optimus Information Inc. • Dadri

On-site
INR 3,500,000 - 5,500,000
Azure Associate Architect ( 10+ years )
Azure Associate Architect ( 10+ years )

Data Semantics • Bengaluru

On-site
INR 1,500,000 - 2,500,000
Engineer III - Azure SQL Cloud Database Engineer
Engineer III - Azure SQL Cloud Database Engineer

Wipfli India • Bengaluru

Hybrid
INR 4,000,000 - 6,000,000
Azure Data Architect
Azure Data Architect

WinWire • Bengaluru

On-site
INR 2,000,000 - 3,000,000
Azure Databricks Sr. Architect
Azure Databricks Sr. Architect

Birlasoft • Pune District

On-site
INR 1,200,000 - 1,600,000
Data Architect
Data Architect

OSBIndia Private Limited • Bengaluru

On-site
INR 1,200,000 - 1,800,000
Azure Data Architect
Azure Data Architect

Valuelabs • Hyderabad

On-site
INR 1,500,000 - 2,000,000