Database Engineer

Tata Consultancy Services; Pune District; On-site; INR 1,800,000 - 3,200,000; Full time

Job summary

Tata Consultancy Services in India is seeking an experienced Azure Database Engineer to migrate, modernize, and optimize on-prem databases to Azure data platforms such as Azure SQL and Managed Instance. You will focus on assessment, schema conversion, data movement, and security configurations to support migrations.

Collaborate with application teams and cloud architects to deliver cloud-ready database solutions, ensuring performance, resilience, and scalability across environments.

Qualifications

• Strong hands on experience with SQL Server, tuning and indexing.
• Experience migrating on prem databases to Azure SQL/Managed Instance.
• Solid understanding of database architecture, normalization, indexing strategies, and query optimization.
• Hands on data migration tools (DMS, SSIS, BACPAC, native backups).
• Knowledge of HA/DR concepts (Always On, failover groups, geo replication).
• Familiarity with Azure networking, identity, and security for DB connectivity.
• Experience with IaC for DB provisioning (ARM, Bicep, Terraform).
• Troubleshooting skills across SQL, performance, and cloud connectivity.
• Excellent communication and documentation for cross-team collaboration.
• Experience with Azure PostgreSQL/MySQL or Cosmos DB is a plus.
• Knowledge of ETL/ELT tools for data integration.
• Exposure to DevOps CI/CD for DB deployments.
• Understanding of data governance and cataloging tools.
• Experience with monitoring tools (Azure Monitor, Log Analytics, Query Store).
• Azure certifications (DP-300, DP-203) are desirable.

Responsibilities

• Assess on-prem databases for migration readiness and cloud suitability.
• Design and implement migration plans using Azure SQL, Managed Instance, or other Azure DB services.
• Perform schema conversion, data movement, and validation using Azure Migrate, DMS, SSIS, or scripts.
• Optimize database performance through indexing, query tuning, partitioning, and resource configuration.
• Implement backup, restore, HA/DR, and security configurations aligned with Azure best practices.
• Troubleshoot database issues, connectivity problems, and performance bottlenecks.
• Collaborate with application and data teams to ensure compatibility and validation post-migration.
• Automate deployment and configuration using ARM/Bicep/Terraform and CI/CD pipelines.
• Maintain documentation for database architecture, migration steps, and operational procedures.
• Support cutover activities, data reconciliation, and production readiness for migration waves.

Skills

SQL Server

Azure SQL

Managed Instance

Azure DB services

Performance tuning

Indexing

Query optimization

DMS

SSIS

BACPAC

Backups

HA/DR

Security

Azure networking

Identity

IaC

ARM/Bicep

Terraform

CI/CD

Documentation

ETL/ELT

Azure Monitor

DP-300

DP-203

Education

Bachelor’s degree in a relevant field

Tools

DMS

SSIS

BACPAC

ARM

Bicep

Terraform

CI/CD

Azure Monitor

Job description

Role Summary

The Azure Database Engineer is responsible for migrating, modernizing, and optimizing on premises databases into Azure database platforms such as Azure SQL, Azure SQL Managed Instance, and Azure PostgreSQL/MySQL (as applicable). The role focuses on assessment, schema conversion, data migration, performance tuning, and ensuring secure, resilient, and scalable database operations in Azure. The engineer collaborates with application teams, data engineers, and cloud architects to deliver high quality, cloud ready database solutions that support the overall migration program.

Experience: 8+ Years

Location- Bangalore , Chennai, Pune

Key Responsibilities

• Assess on‑prem databases (SQL Server, Oracle, PostgreSQL, etc.) for migration readiness and cloud suitability.
• Design and implement migration plans using Azure SQL, Managed Instance, or other Azure database services.
• Perform schema conversion, data movement, and validation using Azure Migrate, DMS, SSIS, or custom scripts.
• Optimize database performance through indexing, query tuning, partitioning, and resource configuration.
• Implement backup, restore, HA/DR, and security configurations aligned with Azure best practices.
• Troubleshoot database issues, connectivity problems, and performance bottlenecks across environments.
• Collaborate with application and data teams to ensure compatibility and functional validation post-migration.
• Automate deployment and configuration using ARM/Bicep/Terraform and CI/CD pipelines.
• Maintain documentation for database architecture, migration steps, and operational procedures.
• Support cutover activities, data reconciliation, and production readiness for migration waves.

Required Skills

• Strong hands on experience with SQL Server (queries, stored procedures, indexing, performance tuning).
• Experience migrating on prem databases to Azure SQL, Managed Instance, or equivalent Azure DB services.
• Solid understanding of database architecture, normalization, indexing strategies, and query optimization.
• Hands on experience with data migration tools (DMS, SSIS, BACPAC, native backups, scripts).
• Knowledge of HA/DR concepts (Always On, failover groups, geo replication).
• Familiarity with Azure networking, identity, and security for database connectivity.
• Experience with Infrastructure as Code (ARM, Bicep, Terraform) for DB provisioning.
• Strong troubleshooting skills across SQL, performance, and cloud connectivity.
• Excellent communication and documentation skills for cross team collaboration.
• Experience with Azure PostgreSQL, MySQL, or Cosmos DB.
• Knowledge of ETL/ELT tools (ADF, Databricks) for end‑to‑end data integration.
• Exposure to DevOps practices and CI/CD for database deployments.
• Understanding of data governance, lineage, and cataloging tools.
• Experience with monitoring tools (Azure Monitor, Log Analytics, Query Store).
• Azure certifications (DP‑300, DP‑203, or Architect‑level certifications).