About the role

  • Programmer Analyst skilled in enterprise software development and AWS migration for the Mississippi Department of Corrections. Engaging in modernization initiatives and collaboration with internal teams and vendors.

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

Requirements

  • Strong experience in enterprise software development
  • SQL/Oracle programming expertise
  • Cloud-based modernization initiatives knowledge
  • Business Analyst skills to review SQL/PLSQL code
  • 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
  • Familiarity with legacy front-end technologies (DHTML, HTML/JavaScript forms)
  • Experience with task schedulers for data automation
  • Experience with AWS database and reporting services is preferred
  • Knowledge of BI/reporting tools such as Power BI or AWS Quicksight is preferred
  • Scripting experience (Python, PowerShell) is preferred
  • Experience with Offender Management or enterprise justice systems is preferred
  • Experience working with external vendor teams on modernization projects is preferred
  • Comfortable reporting onsite as needed

Benefits

  • Flexible work from home options

Job title

Programmer Analyst

Job type

Experience level

Mid levelSenior

Salary

Not specified

Degree requirement

Bachelor's Degree

Location requirements

Report this job

See something inaccurate? Let us know and we'll update the listing.

Report job