Oracle/SQL Programmer @ Jackson, MS for 24 months

Job Title: Programmer Analyst

Contract
Jackson, MS

Summary

We are seeking a skilled Programmer Analyst with strong experience in enterprise software development, SQL/Oracle programming, and cloud-based modernization initiatives. The ideal candidate will review, refactor, and migrate legacy application logic including PL/SQL code, stored procedures, and Crystal Reports into a modern AWS-based architecture. This role involves understanding existing business logic, documenting current workflows, and collaborating with both internal teams and a third- party vendor. They will support the redesign of core application functionality, including modules such as records, classification and sentence computation, to ensure accurate operation within the updated system.

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.

·         Beginner: 1-2 years                                          Intermediate: 3-5 years Advanced: 5-7 years  SME: 7+ years
Skill Set	Skill Level (See key code above)	Required/Preferred	Notes
Operating Systems
SQL/ORACLE Programmer	SME	Required	Able to write, review SQL and PL-SQL code
Business Analyst	Advanced	Required	Able to review SQL/PLSQL code, business rules, MS Code for sentencing rules