Greetings from TCS!!!

TCS presents an excellent opportunity for Database Architect

Role: Database Architect

Experience range: 8-14 Years

Location: Chennai

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.

Positive 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 & Responsibilities- 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.

1. Define availability, backup, disaster recovery, retention, monitoring, patching, and operational runbooks.
2. Lead design reviews, migrations, CI/CD, releases, documentation, and cross-team coordination.

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

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