Oracle APEX Consultant

Position Summary

We are seeking a Senior Oracle APEX Developer (SME) to support a Government IT project in Washington, D.C. The ideal candidate will have extensive experience designing, developing, enhancing, and supporting enterprise Oracle APEX applications while working closely with program managers and government stakeholders.

Responsibilities

• Develop and maintain enterprise applications using Oracle APEX (Version 21+)
• Design, develop, and support secure Oracle-based web applications
• Build dynamic dashboards, reports, and workflow-driven enterprise solutions
• Develop advanced PL/SQL packages, procedures, functions, and triggers
• Design and maintain Oracle database objects including tables, indexes, sequences, and triggers
• Develop and integrate REST APIs and Web Services
• Support Oracle Forms to Oracle APEX migration initiatives
• Work with BI Publisher, JSON, XMLType, BLOBs, and CLOBs
• Automate business processes through scalable application design
• Prepare technical documentation and collaborate with business and government stakeholders

Required Skills

• 12+ years of Oracle Application Development experience
• Oracle APEX (Version 21+)
• Oracle Database 11g or higher
• Advanced PL/SQL development
• Oracle SQL Developer
• Quest Toad
• Java
• JavaScript, jQuery, AJAX
• HTML & CSS
• REST APIs / Web Services
• Oracle Database Objects & Database Administration concepts
• Windows PowerShell
• Unix Shell Scripting
• BI Publisher
• Oracle Forms Migration
• JSON, XMLType, BLOB, CLOB
• Secure Oracle Programming (HTTPS Callouts & Security Certificates)
• Data Migration
• Enterprise Application Development
• Agile Methodology
• Technical Documentation
• Client-facing / Customer Interaction experience

Preferred Skills

• Oracle Forms & Reports (10g+)
• Oracle APEX 4.0+ experience
• Government IT project experience
• Department of Justice (DOJ) project experience
• Enterprise workflow application development
• Production support and troubleshooting