Job Title: SME Oracle APEX Developer
Location: Washington, DC (Onsite)
Type: Contract
Security Clearance: Public Trust

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.

Requirements

• Minimum 12 years of relevant experience.
• Bachelor’s degree required; 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 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.
• Ability to write and maintain system documentation on work products.
• Excellent communication and teamwork skills.
• Agile development experience.
• Customer interface experience.

System One, and its subsidiaries including Joulé and Mountain Ltd., are leaders in delivering outsourced services and workforce solutions across North America. We help clients get work done more efficiently and economically, without compromising quality. System One not only serves as a valued partner for our clients, but we offer eligible employees health and welfare benefits coverage options including medical, dental, vision, spending accounts, life insurance, voluntary plans, as well as participation in a 401(k) plan.

System One is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex (including pregnancy, childbirth, or related medical conditions), sexual orientation, gender identity, age, national origin, disability, family care or medical leave status, genetic information, veteran status, marital status, or any other characteristic protected by applicable federal, state, or local law.

#M-M2
#LI-RF1
Ref: #851-Rockville-S1