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

Key Responsibilities

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

Must-Have Skills

• Expertise in end-to-end Oracle to Azure SQL/MS SQL migrations.
• Strong hands-on experience with Oracle GoldenGate, Azure Data Factory, SSIS, DMA, SSMA, and Azure DMS.
• Proficiency in automation scripting (Python, PowerShell, SQL) for schema conversion, data transfer, and validation.
• Strong skills in performance tuning, replication strategies, and high availability database solutions in Azure PaaS and on-prem environments.