Oracle Database Developer PL/SQL & Legacy System Migration

Overview

On Site
Depends on Experience
Full Time

Skills

Legacy Systems
Migration
Oracle
Oracle Development
PL/SQL
Database
Database Performance Tuning
Data Migration

Job Details

Job Title: Oracle Database Developer PL/SQL & Legacy System Migration
Location: Rockville, MD
Job Type: Full-Time/Contract
Experience: 6+ years in Oracle development and migration projects

Job Description:

  • Design and develop complex PL/SQL procedures, functions, packages, and triggers.

  • Perform legacy data migration to Oracle databases from flat files, Access, or mainframe systems.

  • Analyze existing legacy databases and reverse-engineer schema and logic.

  • Optimize and refactor legacy code into efficient Oracle PL/SQL.

  • Collaborate with business analysts to understand legacy system functionality.

  • Work with ETL tools to extract, transform, and load data into Oracle.

  • Ensure data accuracy, completeness, and consistency post-migration.

  • Conduct performance tuning and database optimization.

  • Assist in data validation, audit checks, and reconciliation processes.

  • Support UAT and production migration efforts with thorough testing and documentation.

  • Create technical documentation for new and migrated components.

Skills: Oracle 12c/19c, PL/SQL, Legacy Systems, Data Migration, SQL Loader, ETL

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.