Oracle PL/SQL Programmer Analyst - Data Conversion

Jobs via Dice United State
Relocation
Apply
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

Visa Sponsorship Relocation Remote
Job Type Full-time
Experience Level Mid-Senior level

bessemer venture partners indi...

United State

Modeling and Simulation Engineer

Programming
2h ago

Premium Job

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

•••••• •••••• ••••••
Job Type ••••••
Experience Level ••••••

Idaho National Laboratory

United State
Visa Sponsorship Relocation Remote
Job Type Full-time
Experience Level Mid-Senior level

WebCreek

United State

Subscribe our newsletter

New Things Will Always Update Regularly