Azure - Database Migration Architect

Job Description

Database Migration Architect- Azure Managed Databases (MSSQL, MySQL, PostgreSQL)

Summary

This role is ideal for a database expert passionate about cloud transformation and modernization, with the ability to bridge the gap between data platforms and application ecosystems while driving enterprise-scale Azure migrations.

Overview

We are looking for an experienced Database Migration Architect with strong expertise in migrating on-premises databases (MSSQL, MySQL, PostgreSQL) to Azure managed database services. The ideal candidate will lead end-to-end database modernization andre-platforming initiatives from VMware-based environments to Azure, while working closely with application teams across Java, Python, .NET, React, andNode.js ecosystems.

This role requires deep database knowledge, cloud architecture expertise, and a strong understanding ofhow databases integrate with modern distributed applications.

Key Responsibilities

1. Database Migration &Modernization

. Lead migration of on-prem databases (SQL Server, MySQL, PostgreSQL) to Azure:

◦ Azure SQL Database / Managed Instance

◦ Azure Database for MySQL

◦ Azure Database for PostgreSQL

. Define migration strategies: lift-and-shift, re-platform, refactor.

. Use tools such as Azure Database Migration Service (DMS), Azure Migrate, and native replication tools.

. Ensure data integrity, minimal downtime, and performance stability during migration.

2. Re-Platforming from VMware to Azure

. Design and execute database migration from VMware-hosted environments to Azure managed services.

. Assess existing infrastructure and recommend optimal Azure database platforms.

. Eliminate legacy dependencies and modernize database deployments.

3. Database Architecture& Design

. Design scalable, highly available, and resilient database architectures in Azure.

. Implement HA/DR strategies(geo-replication, failover groups, backups).

. Optimize schema design, indexing, partitioning, and query performance.

4. Application Integration Understanding

. Collaborate with application teams using:

◦ Java (Spring Boot)

◦ Python (Django, Flask, FastAPI)

◦ .NET / ASP.NET

◦ Node.js

◦ React (frontend integration awareness)

. Ensure seamless database integration with microservices and APIs.

. Optimize database interactions for application performance.

5. Performance Optimization& Tuning

. Analyze and optimize query performance and execution plans.

. Conduct workload assessments and capacity planning.

. Implement monitoring and tuning using Azure tools.

6. Security & Compliance

. Implement database security best practices:

◦ Encryption (TDE, SSL)

◦ Role-based access control(RBAC)

◦ Data masking and auditing

. Ensure compliance with enterprise and regulatory standards.

7. DevOps & Automation

. Automate database deployments using CI/CD pipelines.

. Implement Infrastructure as Code (Terraform, ARM, Bicep).

. Enable automated backups, patching, and scaling.

8. Monitoring &Operations

. Set up monitoring using Azure Monitor, Log Analytics, Application Insights.

. Define SLAs, SLOs, and alerting mechanisms.

. Support production environments and troubleshoot issues.

9. Stakeholder Collaboration

. Work with architects, developers, and business stakeholders.

. Provide technical guidance and mentorship.

. Translate business requirements into database solutions.

Required Skills &Experience

Core Database Expertise

. Strong hands-on experience with:

◦ Microsoft SQL Server (on-prem & Azure)

◦ MySQL

◦ PostgreSQL

. Experience in database migration and modernization projects.

. Deep understanding of data modelling, indexing, and query optimization.

Azure Expertise

. Experience with:

◦ Azure SQL Database & Managed Instance

◦ Azure Database for MySQL/PostgreSQL

◦ Azure Database Migration Service (DMS)

. Knowledge of Azure networking (VNet, Private Endpoints).

Migration &Re-Platforming

. Proven experience migrating databases from VMware/on-prem to Azure.

. Experience in handling large-scale and mission-critical databases.

Application Awareness

. Understanding of application stacks:

◦ Java, Python, .NET

◦ Node.js, React

. Ability to optimize database usage patterns for applications.

DevOps & Automation

. Experience with CI/CD tools(Azure DevOps, GitHub Actions).

. Scripting (PowerShell, Bash, Python).

Preferred Qualifications

. Azure certifications (e.g., Azure Database Administrator Associate, Azure Solutions Architect Expert).

. Experience with data migration strategies for zero/near-zero downtime.

. Knowledge of data warehousing and analytics (Synapse, Data Factory).

. Familiarity with NoSQL databases (Cosmos DB, MongoDB).

Soft Skills

. Strong problem-solving and analytical skills.

. Excellent communication and stakeholder engagement.

. Ability to work in cross-functional and distributed teams.

Education

. Bachelor's or Master's degree in Computer Science, Engineering, or related field.

Experience Level

. 8-12+ years of experience in database engineering/architecture.

. 4+ years in cloud database migration roles.

Key Competencies

. Database Migration Strategy

. Azure Managed Databases

. Performance Tuning &Optimization

. Cloud Re-Platforming(VMware to Azure)

. Application-Database Integration