Programmer Analyst (Project – Data Conversion)

Job Post: Programmer Analyst (Project – Data Conversion)

Job Code: MS 151867
Client Job ID: MS 151867
Job Title: Programmer Analyst (Project – Data Conversion) – Onsite as needed
Location: Jackson, Mississippi (Remote allowed but must report onsite as needed)
Duration: 1 year 6 months 16 days (Approx. 24 months)
Work Hours: 8 AM – 5 PM (40 hrs/week)
Background Check: Standard
Occasional Travel Required

Client:

State of Mississippi – Department of Corrections (MDOC)
Project: Programmer Business Analyst – Data Conversion

Must be willing to report onsite occasionally to meet with user groups. Do NOT submit candidates unwilling to report onsite as needed.

Primary Skills:

Crystal Reports

Converting legacy DHTML-based UI forms

ETL & database conversion

Oracle PL/SQL (rewrite & optimize packages)

AWS-based architecture

Job Description:

The Mississippi Department of Corrections (MDOC) is seeking an experienced Programmer Analyst to support a large-scale modernization project. The candidate will be responsible for reviewing, refactoring, and migrating legacy application logic—including PL/SQL code, stored procedures, business rules, and Crystal Reports—into a modern AWS-based platform.

This role requires strong technical expertise in enterprise application development, data conversion, ETL processes, and legacy system documentation. You will collaborate with internal teams and third-party vendors to ensure accurate migration of mission-critical features such as records management, classification, and sentence computation.

Key Responsibilities:

Review and document existing architecture, workflows, data models, and stored procedures.

Rewrite and optimize Oracle PL/SQL packages, triggers, views, and functions for cloud migration.

Migrate legacy Crystal Reports to an AWS-compatible reporting solution.

Perform ETL activities: extract, map, validate, and transform data for database conversion.

Analyze, document, and refactor core logic modules (e.g., sentence computation).

Convert legacy DHTML-based UI forms into modern equivalents.

Document scheduled jobs and backend automated processes.

Work with external vendors to clarify requirements and support migration efforts.

Required Technical Skills:

Expert-level Oracle PL/SQL (procedures, functions, triggers, packages, views)

Advanced SQL with query performance optimization

Hands-on ETL/data migration experience

Ability to interpret undocumented legacy logic

Familiarity with DHTML/legacy frontend technologies

Experience with scheduled job automation

Preferred Qualifications:

Experience with AWS reporting and database services

BI/reporting tools (Power BI, AWS Quicksight)

Scripting (Python, PowerShell)

Background in Offender Management / Justice Systems

• Vendor collaboration on modernization projects

Skills required:

SQL/Oracle Programmer – 7+ years (Required): Able to write and review SQL & PL/SQL code.

Business Analyst – 5–7 years (Required): Able to analyze SQL/PLSQL, business rules, and user requirements.

Oracle DB – 5–7 years (Required): —

SQL – 5–7 years (Preferred): —