Job description

Database Migration Specialist (Oracle to Azure SQL/MS SQL) Database Migration Specialist (Oracle to Azure SQL/MS SQL) 1 day ago Be among the first 25 applicants Macpower Digital Assets Edge formerly MDA Edge provided pay range This range is provided by Macpower Digital Assets Edge formerly MDA Edge. Your actual pay will be based on your skills and experience talk with your recruiter to learn more. Base pay range $65.00/hr - $65.00/hr 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. • 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. Preferred Qualifications • 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. Seniority level • Seniority level Mid-Senior level Employment type • Employment type Contract Job function • Job function Information Technology • Industries Staffing and Recruiting Referrals increase your chances of interviewing at Macpower Digital Assets Edge formerly MDA Edge by 2x Sign in to set job alerts for Database Specialist roles. Bellevue, WA $87,000.00-$111,000.00 4 days ago Indiana, United States $86,600.00-$132,600.00 2 weeks ago Database Admin, R2L, R2L Preconstruction & Construction Bellevue, WA $99,500.00-$185,000.00 2 weeks ago Seattle, WA $70,000.00-$150,000.00 2 days ago Bellevue, WA $86,600.00-$132,600.00 1 month ago Database Administrator - Cloud Data Warehousing Seattle, WA $177,688.00-$341,734.00 5 days ago Seattle, WA $78,825.00-$126,120.00 2 weeks ago Database Administrator - Cloud Data Warehousing Seattle, WA $9,800.00-$10,400.00 1 month ago Bellevue, WA $73,000.00-$93,000.00 2 weeks ago Redmond, WA $122,500.00-$145,000.00 1 week ago Bellevue, WA $118,900.00-$205,600.00 4 days ago Seattle, WA $118,900.00-$205,600.00 4 days ago Seattle, WA $180,000.00-$260,000.00 3 days ago Bellevue, WA $118,900.00-$205,600.00 1 day ago Systems and Data Analyst (System/Application Analysis) Greater Seattle Area $69,744.00-$93,804.00 1 week ago Bellevue, WA $91,200.00-$185,000.00 1 week ago Seattle, WA $125,700.00-$188,600.00 4 days ago Bellevue, WA $105,000.00-$195,000.00 2 weeks ago Bellevue, WA $118,900.00-$205,600.00 2 weeks ago Seattle, WA $12,325.00-$13,750.00 4 days ago Seattle, WA $118,900.00-$205,600.00 2 weeks ago Bellevue, WA $91,200.00-$185,000.00 3 days ago Were unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI. #

Requirements