About this role
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).
Also in Software Engineering
A*STAR RESEARCH ENTITIES
PERSOL SINGAPORE PTE. LTD.
PERSOL SINGAPORE PTE. LTD.