WeAreDevelopers Logo WeAreDevelopers
Sign in
For You LIVE
Back

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

Macpower Digital Assets Edge LLC
Bellevue, WA, United States
18 days ago
Apply on www.thejobnetwork.com
Prepare application

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience level
Expert
Experience required
10 years minimum
Working hours
Regular working hours
Job source
www.thejobnetwork.com

Tech stack

Microsoft Azure Data Transmissions Data Migration Data Synchronization Disaster Recovery Infrastructure as a Service (IaaS) Python (Programming Language) Microsoft SQL Server SQL Azure Online Transaction Processing Oracle Databases Oracle (Applications)
+18 more
Oracle SQL Developer Peer-To-Peer (P2P) Platform as a Service (PAAS) Performance Tuning Windows PowerShell Query Optimization SQL Stored Procedures PL-SQL SQL Databases SQL Server Integration Services Transact-SQL Scripting Azure Data Factory Database Optimization Database Migration Information Technology Database Replication Azure Service Fabric

Job description

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

Requirements

  • 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., * Bachelor’s or Master’s degree in Computer Science, IT, or a related field.
  • 10 years of experience in database migration and optimization.
  • Strong analytical and problem-solving skills.

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on www.thejobnetwork.com
Prepare application

Good distractions

Loading talks and stories from around this role…