Database Migration Architect

Database Migration & Modernization:

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

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

Performance Optimization & Tuning:

• Analyze and optimize query performance and execution plans.

Security & Compliance:

• Implement database security best practices.

DevOps & Automation:

• Automate database deployments using CI/CD pipelines. Implement Infrastructure as Code (Terraform, ARM, Bicep).

Monitoring & Operations:

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

Stakeholder Collaboraton:

• Work with architects, developers and business stakeholders.

Job Requirements:

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

• 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).