PL/SQL Programmer Analyst 

Job Description

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.

Are you interested in this position?

Apply by clicking on the “Apply Now” button below!

#GraphicDesignJobsOnline

#WebDesignRemoteJobs #FreelanceGraphicDesigner #WorkFromHomeDesignJobs #OnlineWebDesignWork #RemoteDesignOpportunities #HireGraphicDesigners #DigitalDesignCareers# Dynamicbrand guru