Programmer Analyst

We have a 2-year 100% remote Programmer Analyst contract in Jackson MS. The anticipated start date is immediate.

Our client is 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.

Minimum Qualifications

A minimum of 5 years of experience in the following:

• 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.

Desirable 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.

Minimum Application Requirements

Your application will be disqualified if you do not meet all these minimum application requirements.

• Must meet or exceed the Minimum Qualifications.
• Must be a current resident of the United States.
• Must have current work authorization for the United States.
• Must be a direct hire.

Make sure to check your junk/spam folders as we will use email to reach out to you.