Oracle PL/SQL Developer

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 cloud migration
• Migrate legacy Crystal Reports to a modern reporting platform compatible with AWS
• Extract, map, validate, and transform data for 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 Qualifications

• 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