Description

Programmer Analyst responsible for migrating legacy Oracle applications to AWS, optimizing PL/SQL, and modernizing reporting and UI components.

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 cloud migration.
• 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 and refactor core logic modules, converting legacy DHTML-based UI forms to modern formats.

Required Skills

• Expert knowledge of Oracle PL/SQL, including procedures, functions, triggers, packages, and views.
• Strong SQL expertise with a focus on 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 such as DHTML and HTML/JavaScript forms.
• Experience with AWS database and reporting services.
• Knowledge of BI/reporting tools such as Power BI or AWS QuickSight.
• Scripting experience with Python or PowerShell.
• Minimum 5 years of experience in similar roles.

Key Skills

Education

Any Gradute