Database Migration Architect
ExternalPrepare for this interview
EliteAI-generated questions, company research, and talking points tailored to this role
About the role
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).
Your Match
How well this role fits your profile.
Company Intel
What employees say
Worked at PURVIEW ASIA PACIFIC PTE. LTD.? Share your experience