Database Migration Architect

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 and re-platforming initiatives from VMware-based environments to Azure, while working closely with application teams across Java, Python, .NET, React, and Node.js ecosystems. This role requires deep database knowledge, cloud architecture expertise, and a strong understanding of how databases integrate with modern distributed applications.

Key Responsibilities

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.

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.

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.

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.

Performance Optimization & Tuning

• Analyze and optimize query performance and execution plans.

• Conduct workload assessments and capacity planning.

• Implement monitoring and tuning using Azure tools.

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.

DevOps & Automation

• Automate database deployments using CI/CD pipelines.

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

• Enable automated backups, patching, and scaling.

Monitoring & Operations

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

• Define SLAs, SLOs, and alerting mechanisms.

• Support production environments and troubleshoot issues.

Stakeholder Collaboration

• Work with architects, developers, and business stakeholders.

• Provide technical guidance and mentorship.

• Translate business requirements into database solutions.

Job Requirements:

• Bachelor's or Master's degree in Computer Science, Engineering, or related field.
• 8–12+ years of experience in database engineering/architecture.
• 4+ years in cloud database migration roles.
• 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 modeling, 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.
• Key Competencies: Database Migration Strategy, Azure Managed Databases,Performance Tuning & Optimization,Cloud Re-Platforming (VMware to Azure), Application-Database Integration
• 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).