Seeking a Programmer Analyst to review, refactor, and migrate legacy application logic including PL/SQL code, stored procedures, and Crystal Reports into a modern AWS-based architecture. Additionally:
- 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.
- 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
Skills
Required/Preferred
Years
Candidate Experience
Expert knowledge of Oracle PL/SQL (procedures, functions, triggers, packages, views).
Required
7+
Strong SQL expertise including query optimization and performance tuning.
Required
7+
Experience with data migration, ETL workflows, and schema transformation.
Required
7+
Ability to understand logic from legacy applications and undocumented code.
Required
7+
Familiarity with legacy front-end technologies (DHTML, HTML/JavaScript forms).
Required
7+
Experience with task schedulers for data automation.
Required
7+
Experience with AWS database and reporting services.
Required
7+
Knowledge of BI/reporting tools such as Power BI or AWS QuickSight.
Required
7+
Scripting experience (Python, PowerShell).
Required
7+
Experience with Offender Management or enterprise justice systems.
Required
7+
Experience working with external vendor teams on modernization projects.
Required
7+
Benefit Package includes: