Database Migration Specialist (Oracle to Azure SQL / MS SQL)

Job Overview : We are looking for an experienced Database Migration Architect with deep expertise in end-to-end Oracle to Azure SQL / MS SQL migrations . The ideal candidate should have strong hands-on experience in automation, replication strategies, performance tuning, and high-availability database solutions .

Key Responsibilities :

• Design and implement OLTP peer-to-peer replication strategies for seamless data synchronization.
• rchitect and optimize data warehouse solutions to align with business intelligence needs.
• utomate large-scale database migrations to minimize downtime and accelerate transitions.
• Lead Oracle-to-Azure SQL / MS SQL migrations , ensuring high efficiency and automation.
• Develop and implement automation frameworks for schema conversion, data migration, and validation.
• Utilize Oracle GoldenGate, Azure Data Factory, SSIS, Python, PowerShell, and SQL for data replication and migration.
• Perform in-depth Oracle database assessments , covering schemas, stored procedures, PL / SQL, indexes, triggers, partitions, and performance tuning.
• Convert Oracle PL / SQL to T-SQL , optimizing for performance on the target SQL platform.
• Use Microsoft DMA, SSMA, Azure DMS , or other proven solutions to streamline migrations.
• nalyze and mitigate compatibility issues between Oracle and target SQL platforms.
• rchitect scalable, high-availability database solutions in Azure SQL (PaaS) and MS SQL (IaaS / on-prem) .
• Optimize post-migration performance through indexing strategies, partitioning, query tuning, and workload balancing.
• Ensure compliance with security, governance, and disaster recovery (HA / DR) requirements .
• Collaborate with application teams to ensure compatibility and minimal downtime.
• Identify and address risks proactively , providing clear recommendations and roadmaps.
• Work in a fast-paced, problem-solving environment , proactively driving execution while keeping leadership updated.

Must-Have Skills :

Preferred Qualifications :