Database Sme Azure Cloud (postgresql, Mysql, Mongodb Migration)
- Calsoft
- 10 - 14 years
- Noida, Gurugram
- 5 months ago
- Email to a friend
- Report this job
Job Description
Role Overview:
We are seeking an experienced Database SME with deep technical expertise in relational and NoSQL databases, who will lead and support the migration of on-prem PostgreSQL, MySQL, and MongoDB workloads to Azure-native managed database services. The candidate should have experience in end-to-end database migration lifecycle, from assessment, compatibility checks, performance tuning, HA/DR design to validation and cutover.
________________________________________
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-replication
o Backup, retention, recovery
o Access control, firewall, identity integration (AAD where applicable)
Recommend appropriate Azure services:
o Azure PostgreSQL Flexible Server
o 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
Perform or support schema migration using tools like Azure DMS, pg_dump/pg_restore, mysqldump, mongoexport/import, custom scripts.
Conduct data transfer in phased or cutover model (offline/online replication).
Validate data integrity, consistency, and performance post-migration.
Support database performance tuning and troubleshooting during and post-migration.
Operationalization & Handover
Implement and test backup, restore, and HA/DR configurations for managed databases.
Configure monitoring and alerting using Azure Monitor, Log Analytics, and diagnostic settings.
Develop runbooks, tuning guidelines, and capacity plans.
Conduct knowledge transfer sessions with the client's operations team.
________________________________________
Required Skills & Experience:
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 Instance
o 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)
Job Classification
Industry: IT Services & ConsultingFunctional Area / Department: Engineering - Software & QARole Category: DBA / Data warehousingRole: Database Developer / EngineerEmployement Type: Full timeContact Details:
Company: CalsoftLocation(s): Noida, Gurugram
Keyskills: Azure Cloud Postgresql Migration MongoDB MySQL
Similar positions
Calsoft
2COMS Consulting Pvt. Ltd. is a Recruitment and staffing solutions company established in 1999 in Kolkata with branches in Pune, Hyderabad & Bhubaneshwar. 2COMS focuses on verticals like KPO, BPO, IT, Insurance, Banking.
Job Listings
We are in open beta version of website, please let us know if any issues, at: info(at)indigojobs.in