Oracle PL/SQL Programmer Analyst - Data Conversion

Jobs via Dice โ€ข United State
Relocation
This Job is No Longer Active This position is no longer accepting applications
AI Summary

Review and optimize Oracle PL/SQL code, migrate legacy applications to cloud environment, and extract and transform data for ETL and database conversion activities.

Key Highlights
Review and document existing application architecture, data models, workflows, and stored procedures
Rewrite and optimize Oracle PL/SQL packages, functions, triggers, and views for migration to a cloud environment
Migrate legacy Crystal Reports to a modern reporting platform compatible with AWS
Key Responsibilities
Review and document existing application architecture, data models, workflows, and stored procedures
Rewrite and optimize Oracle PL/SQL packages, functions, triggers, and views for migration to a cloud environment
Migrate legacy Crystal Reports to a modern reporting platform compatible with AWS
Extract, map, validate, and transform data to support ETL and database conversion activities
Analyze, document, and refactor core logic modules such as sentence computation
Convert legacy DHTML-based UI forms to modern formats as part of system redesign
Understand and document scheduled jobs and backend automation processes
Technical Skills Required
Expert knowledge of Oracle PL/SQL (procedures, functions, triggers, packages, views) Strong SQL expertise including query optimization and performance tuning Experience with data migration, ETL workflows, and schema transformation
Nice to Have
Experience with AWS database and reporting services
Knowledge of BI/reporting tools such as Power BI or AWS QuickSight
Scripting experience (Python, PowerShell)
Experience with Offender Management or enterprise justice systems
Experience working with external vendor teams on modernization projects

Job Description


Dice is the leading career destination for tech experts at every stage of their careers. Our client, Info Origin Inc., is seeking the following. Apply via Dice today!

Position Title: Oracle PL/SQL /Programmer Analyst - Data Conversion (Onsite โ€“ Relocation is fine)

Location: Jackson, MS

Position Type: Onsite (Long Term Contract)

Interview Process: Video Only

Key Responsibilities

  • Review and document existing application architecture, data models, workflows, and stored procedures.
  • Rewrite and optimize Oracle PL/SQL packages, functions, triggers, and views for migration to a cloud environment.
  • Migrate legacy Crystal Reports to a modern reporting platform compatible with AWS.
  • Extract, map, validate, and transform data to support ETL and database conversion activities.
  • Analyze, document, and refactor core logic modules such as sentence computation.
  • Convert legacy DHTML-based UI forms to modern formats as part of system redesign.
  • Understand and document scheduled jobs and backend automation processes.
  • Collaborate with a third-party vendor to clarify requirements and support modernization efforts.

Required Technical Skills

  • Expert knowledge of Oracle PL/SQL (procedures, functions, triggers, packages, views).
  • Strong SQL expertise including query optimization and performance tuning.
  • Experience with data migration, ETL workflows, and schema transformation.
  • Ability to understand logic from legacy applications and undocumented code.
  • Familiarity with legacy front-end technologies (DHTML, HTML/JavaScript forms).
  • Experience with task schedulers for data automation.

Preferred Qualifications

  • Experience with AWS database and reporting services.
  • Knowledge of BI/reporting tools such as Power BI or AWS QuickSight.
  • Scripting experience (Python, PowerShell).
  • Experience with Offender Management or enterprise justice systems.
  • Experience working with external vendor teams on modernization projects.

Similar Jobs

Explore other opportunities that match your interests

Embedded Software Engineer II (P2)

Programming
โ€ข
42m ago

Premium Job

Sign up is free! Login or Sign up to view full details.

โ€ขโ€ขโ€ขโ€ขโ€ขโ€ข โ€ขโ€ขโ€ขโ€ขโ€ขโ€ข โ€ขโ€ขโ€ขโ€ขโ€ขโ€ข
Job Type โ€ขโ€ขโ€ขโ€ขโ€ขโ€ข
Experience Level โ€ขโ€ขโ€ขโ€ขโ€ขโ€ข

raytheon australia

United State

Senior Software Engineer - C/C++

Programming
โ€ข
45m ago

Premium Job

Sign up is free! Login or Sign up to view full details.

โ€ขโ€ขโ€ขโ€ขโ€ขโ€ข โ€ขโ€ขโ€ขโ€ขโ€ขโ€ข โ€ขโ€ขโ€ขโ€ขโ€ขโ€ข
Job Type โ€ขโ€ขโ€ขโ€ขโ€ขโ€ข
Experience Level โ€ขโ€ขโ€ขโ€ขโ€ขโ€ข

raytheon australia

United State

Operations Analysis Engineer (Principal Engineer Level) - Military Systems Modeling and Simulation

Programming
โ€ข
50m ago

Premium Job

Sign up is free! Login or Sign up to view full details.

โ€ขโ€ขโ€ขโ€ขโ€ขโ€ข โ€ขโ€ขโ€ขโ€ขโ€ขโ€ข โ€ขโ€ขโ€ขโ€ขโ€ขโ€ข
Job Type โ€ขโ€ขโ€ขโ€ขโ€ขโ€ข
Experience Level โ€ขโ€ขโ€ขโ€ขโ€ขโ€ข

Northrop Grumman

United State

Subscribe our newsletter

New Things Will Always Update Regularly