Senior Oracle PL/SQL Programmer Analyst (AWS Modernization)( 151864)

Overview

Remote
Depends on Experience
Accepts corp to corp applications
Contract - W2
Contract - 12 Month(s)
No Travel Required
Able to Provide Sponsorship

Skills

Python or PowerShell.

Job Details

Senior Oracle PL/SQL Programmer Analyst (AWS Modernization)( 151864)

Location: Jackson, MS-

Duration: Long-Term Contract

Can work remote but will be required to report onsite on occasion to meet with user groups. Do NOT submit anyone unwilling to report onsite as needed.

Job Summary

We are seeking an experienced Senior PL/SQL Programmer Analyst to support a large-scale modernization initiative involving the migration of legacy enterprise applications to an AWS cloud-based environment. The ideal candidate will have deep expertise in Oracle PL/SQL, strong analytical skills for understanding undocumented legacy code, and hands-on experience with data migration, ETL workflows, and report transformation.

This role requires close collaboration with internal development teams and an external vendor to redesign and refactor critical business modules including records, classification, and sentence computation to ensure accuracy and reliability in the modernized system.

Key Responsibilities

  • Analyze, understand, and document existing legacy application architecture, workflows, data models, and stored procedures.
  • Review, refactor, and optimize Oracle PL/SQL packages, procedures, functions, triggers, and views for cloud migration.
  • Migrate Crystal Reports to modern reporting platforms compatible with AWS.
  • Support ETL activities, including extracting, mapping, validating, and transforming data for system conversion.
  • Analyze and document complex logic modules such as sentence computation and related core functions.
  • Convert legacy DHTML-based UI forms into modern user interface components as part of system redesign.
  • Identify, document, and assist in rebuilding backend automation tasks and scheduled jobs.
  • Collaborate with a third-party vendor to clarify requirements and support modernization tasks.
  • Participate in technical reviews and provide recommendations for system optimization, performance, and best practices.

Required Technical Skills

  • Expert proficiency in Oracle PL/SQL (packages, functions, procedures, triggers, views).
  • Strong SQL experience with query optimization and performance tuning.
  • Hands-on experience with data migration, ETL workflows, and schema transformation.
  • Ability to interpret, understand, and refactor undocumented legacy application logic.
  • Familiarity with legacy UI formats (DHTML, HTML/JavaScript forms).
  • Experience with job schedulers and automation processes.

Preferred Qualifications

  • Experience with AWS databases (Aurora, RDS) and reporting services.
  • Experience with BI/reporting tools such as Power BI or AWS QuickSight.
  • Scripting skills: Python or PowerShell.
  • Experience with Offender Management Systems, justice or corrections systems.
  • Experience collaborating with external vendors or modernization solution partners.

Soft Skills & Competencies

  • Strong analytical and problem-solving abilities.
  • Excellent communication skills written and verbal.
  • Ability to work independently as well as part of a team.
  • Strong attention to detail and documentation discipline.
  • Ability to manage time, priorities, and deliverables in a fast-paced environment.

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.