Programmer Analyst

Job Title Programmer Analyst Urgent Yes- Location Jackson, MS  Remote Option Onsite required Immigration USC/H1B Hours 40 Hours per week-Only Project Start 04/27/2026 or TBD by Client Duration 18 Months Work Schedule M to F-8:00 AM to 5:00 PM CST Salary/Rate- Prefer W-2, 1099, C2C Last 5 Digit -SSN-Req.-   On-Call Required   Travel Not Required Client Direct Criminal Background Check/ Drug Screen Requirement Standard Background Check                                                   DESCRIPTION:   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.