Senior Oracle APEX Developer — Enterprise App Leader

CGS Federal; City of Albany (NY); On-site; USD 110,000 - 150,000; Full time

Benefits offered by this job

Health, Dental, and Vision

Life Insurance

401k

Flexible Spending Account (FSA)

Job summary

CGS Federal seeks a Senior Oracle APEX Developer to support a broad range of IT services for government clients. You will lead the full lifecycle development of Oracle Applications, primarily using Oracle APEX, with hands-on work in Oracle IDEs such as TOAD and SQL Developer.

The role requires strong SQL, PL/SQL, Java, and scripting skills, familiarity with BI Publisher, JSON/XML, and web technologies. A US citizenship and ability to obtain a public trust are required.

Qualifications

• Bachelor’s degree with 8+ years experience. A High School diploma with additional years of experience and/or relevant certifications may be considered in lieu of a degree.
• U.S. Citizen.
• 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 the 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.
• Must be able to write and maintain system documentation on work products.
• Excellent communication and teamwork skills.
• Agile development experience.
• Customer interface experience.

Responsibilities

• Support full lifecycle development of custom Oracle Applications, primarily using Oracle APEX.
• Perform advanced use of Oracle APEX 4.0 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 for 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.
• Successfully deliver enterprise-level workflow-centric applications.
• Build logical functions and algorithms to automate business processes.

Skills

Oracle APEX

JQuery

JavaScript

SQL Developer

TOAD

PL/SQL

Java

PowerShell

Unix scripting

Agile

BI Publisher

JSON/XML

Security clearance

DOJ experience

Education

Bachelor's degree or higher

U.S. Citizenship

Tools

Oracle APEX

Oracle SQL Developer

Quest TOAD

Job description

CGS Federal seeks a Senior Oracle APEX Developer to support a broad range of IT services for government clients. You will lead the full lifecycle development of Oracle Applications, primarily using Oracle APEX, with hands-on work in Oracle IDEs such as TOAD and SQL Developer.

The role requires strong SQL, PL/SQL, Java, and scripting skills, familiarity with BI Publisher, JSON/XML, and web technologies. A US citizenship and ability to obtain a public trust are required.