Hello all,
Job Title : Programmer Analyst
Job ID : 151864
Location : Jackson MS
This position offers remote work; however, candidates must be willing to come onsite as needed for meetings with user groups.
Job Summary
We are looking for a talented Programmer Analyst with substantial experience in enterprise software development, SQL / Oracle programming, and cloud modernization projects. The ideal candidate will play a pivotal role in reviewing, refactoring, and migrating legacy application logic—including PL / SQL code, stored procedures, and Crystal Reports—into a modern AWS-based architecture. This position demands a clear understanding of existing business processes, thorough documentation of workflows, and collaboration with both internal teams and external vendors. The Analyst will contribute significantly to the redesign of core application functionality to ensure system accuracy and efficiency.
Key Responsibilities
- Review and document the existing application architecture, data models, workflows, and stored procedures.
- Rewrite and optimize Oracle PL / SQL packages, functions, triggers, and views for 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 the system redesign.
- Understand and document scheduled jobs and backend automation processes.
- Collaborate with a third-party vendor to clarify requirements and facilitate 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.The 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.