Database Migration Specialist (Oracle to Azure)

At the top of the resume, please include the candidate\'s current location. If the candidate is not local, clearly state whether they are willing to relocate and work onsite five days a week. Applications missing this information will be rejected.

Role Description & Required/Preferred Skills:

• Design and implement OLTP peer-to-peer replication strategies for seamless data synchronization.

• Architect and optimize data warehouse solutions to align with business intelligence needs.

• Automate large-scale database migrations to minimize downtime and accelerate the transition.

• Own and lead end-to-end Oracle-to-Azure SQL / MS SQL migrations, ensuring high efficiency, automation, and minimal downtime.

• Develop and implement automation frameworks to streamline schema conversion, data migration, and validation.

• Leverage Oracle GoldenGate, Azure Data Factory, SSIS, and automation scripts (Python, PowerShell, SQL) to optimize data replication and migration.

• Perform in-depth Oracle database assessments, covering schemas, stored procedures, PL/SQL, indexes, triggers, partitions, and performance tuning strategies.

• 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.

• Analyze and mitigate compatibility issues between Oracle and target SQL platforms.

• Architect 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. Skills : Oracle To Azure SQL/MS SQL Migrations, Oracle GoldenGate, Azure Data Factory, SSIS, DMA, SSMA, And Azure DMS, Python, PowerShell, SQL, Azure PaaS.

Contract