What are the responsibilities and job description for the Programmer Analyst position at Elegant Enterprise Wide Solutions?
About this Position:
Job Title: 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 direct client 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 teams on modernization projects.