Programmer Analyst

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.