Database SME - Azure Cloud (PostgreSQL, MySQL, MongoDB Migration)

Job Title:

Skills needed Mongo & PostreSQL

Work Type

Project Background:

Role Overview:

Key Responsibilities:

Discovery & Assessment
• Conduct discovery of the existing on-premises PostgreSQL, MySQL, and MongoDB environments.• Evaluate schema designs, data volumes, configuration, performance characteristics, and HA/DR setups.• Assess compatibility of source DBs with Azure managed offerings (Azure PostgreSQL, Azure SQL MI, Cosmos DB).• Participate in creating inventory, complexity mapping, and readiness reports.Design & Planning• Define target architecture for each database platform on Azure, considering:o Performance (vCores, IOPS, throughput)o Availability Zones / Geo-replicationo Backup, retention, recoveryo Access control, firewall, identity integration (AAD where applicable)• Recommend appropriate Azure services:o Azure PostgreSQL Flexible Servero Azure SQL Managed Instance (for workloads needing SQL Server compatibility)o Cosmos DB with MongoDB API for NoSQL workloads• Document migration design plans including rollback strategy and DR configuration.

Migration Execution

• 8+ years of experience in relational and NoSQL database administration and architecture.• Minimum 3+ years of experience with Azure-managed database services, including:o Azure PostgreSQL (Single Server/Flexible Server)o Azure SQL Managed Instanceo Cosmos DB (MongoDB API or Core SQL)• Proven track record of migrating PostgreSQL, MySQL, and MongoDB from on-prem to Azure.• Expertise in schema conversion, replication strategies, data migration tools, and cutover planning.• Strong understanding of HA/DR patterns, backup and retention policies in Azure.• Deep troubleshooting knowledge including query optimization, slow queries, index design, and IOPS analysis.• Experience working with Azure-native monitoring tools (Azure Monitor, Metrics, Alerts, Logs).

  Nice to Have:

• Experience with DevOps-based database deployment using Azure DevOps Pipelines or GitHub Actions
  • Hands-on experience with Terraform or Bicep for provisioning managed databases• Familiarity with CI/CD for DB schema deployment, versioning tools (e.g., Flyway, Liquibase)• Knowledge of hybrid connectivity (ExpressRoute, VPN) for online migrations• Microsoft certification: DP-300 (Administering Relational Databases on Azure)