Oracle SQL developer

Company: PROLIM Corporation
Location: Bellevue
Posted on: May 7, 2025

Job Description:

Job Description:

Do not wait to apply after reading this description a high application volume is expected for this opportunity.

We are actively seeking a skilled Oracle SQL Developer for a 6-month contract role in Bellevue, WA. The ideal candidate will play a lead role in Oracle-to-Azure SQL / MS SQL migration projects, database optimization, and automation.

This position requires strong technical capabilities in PL/SQL, Oracle GoldenGate, Azure Data Factory, SSIS, and scripting languages like Python, PowerShell, and SQL. The candidate should have proven experience in designing and executing complex database solutions in enterprise environments.

Responsibilities & Required Skills:

Design and implement OLTP peer-to-peer replication for real-time data synchronization


Lead end-to-end Oracle-to-Azure SQL / MS SQL migrations, with a focus on automation and minimal downtime


Automate schema conversion, data migration, and validation workflows


Perform comprehensive Oracle database assessments, including schemas, stored procedures, indexes, partitions, and performance tuning.


Convert PL/SQL code to optimized T-SQL for Azure/MS SQL platforms


Utilize tools such as Oracle GoldenGate, Azure Data Factory, SSIS, Azure DMS, DMA, and SSMA for seamless migrations


Build scalable, high-availability database architectures in Azure SQL (PaaS) and MS SQL (IaaS/on-prem)


Optimize post-migration performance via query tuning, indexing strategies, and partitioning


Collaborate with application teams to ensure full compatibility and reduce production downtime


Ensure compliance with High Availability (HA) and Disaster Recovery (DR) standards to maintain system uptime, data integrity, and business continuity


Proactively identify risks and provide actionable mitigation strategies


Excellent problem-solving skills and the ability to work in a fast-paced, delivery-focused environment

Keywords: PROLIM Corporation, Seattle , Oracle SQL developer, IT / Software / Systems , Bellevue, Washington