Description

Analyze, document, and modernize critical application components, focusing on cloud migration and system redesign.

This role is on-site.

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.
• Convert legacy DHTML-based UI forms to modern formats during system redesign.

Required 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.
• Proficiency in Python or PowerShell scripting.
• Familiarity with legacy front-end technologies (DHTML, HTML/JavaScript forms).
• Experience with task schedulers for data automation.
• Ability to understand logic from legacy applications and undocumented code.

Preferred Skills

• Experience with AWS database and reporting services.
• Knowledge of BI/reporting tools such as Power BI.

Key Skills

Education

Any Gradute