Job Title: SME Oracle APEX Developer Location: Washington DC
Pref Consultant's with Active public trust clearance
Primary Responsibilities.
- Work at the direction of the program manager to support the full lifecycle development of custom Oracle Applications, primarily using the Oracle APEX toolset.
- Perform advanced use of Oracle APEX 21 and above.
- Perform work with Oracle Integrated Development Environments such as Quest Toad and Oracle SQL Developer.
- Design and manipulate web content dynamically using JQuery, Ajax, JavaScript, CSS, and HTML.
- Create dynamic reports within the Oracle APEX environment. Provide support in the advanced use of Oracle Database products version 11 and above.
- Provide support Oracle database objects – tables, indexes, directories, sequences, triggers, etc.
- Provide support with PL/SQL, Java, Windows PowerShell, and Unix shell scripting with familiarity with built-in PLSQL packages and procedures.
- Provide support with storage, efficient retrieval, and manipulation of unstructured data (BLOBs, CLOBs, JSON, XMLType) in an Oracle environment.
- Integrate and manage BI Publisher templates and web Services.
- Analyze existing Oracle Forms applications and design migration strategies to scalable and secure web applications using Oracle Apex.
- Develop APIs and connections to external applications
- Successfully deliver enterprise level workflow centric applications.
- Build logical functions and algorithms to automate business processes.
Basic Qualifications.
- Typically requires BS degree and 12 – 15 years of prior relevant experience or Masters with 10 – 13 years of prior relevant experience. May possess a Doctorate in technical domain. additional experience may be considered in lieu of a degree.
- Ability to obtain and maintain a public trust security clearance
- Experience with secure network programming in an Oracle environment; use of security certificates, HTTPS callouts, etc.
- Experience with full lifecycle development of custom Oracle Applications, including the Oracle APEX toolset
- Experience with use of Oracle Integrated Development Environments such as Quest Toad and Oracle SQL Developer
- Experience with JQuery, Ajax, JavaScript, CSS, and HTML
- Experience with PL/SQL, Java, Windows PowerShell, and Unix shell scripting with familiarity with built-in PLSQL packages and procedures
- Experience with storage, efficient retrieval, and manipulation of unstructured data (BLOBs, CLOBs, JSON, XMLType) in an Oracle environment
- Experience establishing goals and meeting project plan objectives
- Experience with data migration tools and techniques.
- Must be able to write and maintain system documentation on work products
- Excellent communication and teamwork skills
- Agile development experience
- Customer interface experience
Preferred Qualifications.
- Experience with Oracle Database products version 11 and above
- Experience with Oracle Forms and Reports version 10G or higher
- Experience with Oracle APEX 4.0 and above
- Experience troubleshooting operational issues