ASRC Federal Agile Management LLC is seeking an experienced Mod Oracle PL SQL/Web Developer to support our work with the DEA's Diversion Division.
Work Location: Hybrid - Arlington, VA (2 days per week onsite). Fully remote work may be considered.Responsibilities
Design, develop, and maintain web applications served through Oracle mod_plsqlWrite and optimize complex PL/SQL packages and SQL queries against large datasetsBuild interactive, AJAX-driven front-end interfaces backed by PL/SQL proceduresTroubleshoot performance issues across the database, gateway, and browser layersParticipate in code reviews, deployments, and production support
Required Technical SkillsOracle mod_plsql / Web Toolkit
Extensive experience building web applications using Oracle's mod_plsql gateway (PL/SQL Web Toolkit, OWA packages such as HTP, HTF, OWA_UTIL, OWA_COOKIE, WPG_DOCLOAD)Configuring and maintaining mod_plsql Database Access Descriptors (DADs) under Oracle HTTP Server (OHS) / ApacheGenerating dynamic HTML output directly from PL/SQL stored proceduresSession and state management in stateless mod_plsql architecturesArray parameter passing between pagesURL parameter passingProper understanding of the various locking strategies to maintain data integrityFile upload/download functionality
PL/SQL
Expert-level development of stored procedures, functions, packages, and triggersCursors (explicit, implicit, ref cursors), bulk operations (BULK COLLECT, FORALL), collections, and dynamic SQLException handling, autonomous transactions, and performance tuning of PL/SQL codeBuilding and maintaining reusable PL/SQL APIs and business logic layersDynamic SQL
SQL
Advanced query writing, complex joins, analytic/window functions, subqueries, and set operationsQuery optimization using execution plans, hints, indexing strategies, and partitioningData modeling, normalization, and writing DDL/DML for Oracle databases (19c and above)
Front-End: HTML, CSS, JavaScript, AJAX
Hand-coding semantic HTML and responsive CSS layoutsJavaScript for client-side validation, DOM manipulation, and interactivityAJAX integration with mod_plsql endpoints for asynchronous, partial-page updates (XMLHttpRequest / Fetch, JSON or XML payloads returned from PL/SQL procedures)Cross-browser compatibility and debugging
Education/Experience:
A BS/BA in Engineering, Physics, Computer Science, Information Technology, Mathematics or equivalent, and at least 5 years' experience in the field. Nine (9) years of related experience is equivalent to a BS/BA in Engineering, Physics, Computer Science,
4+ years of hands-on Oracle development, with significant time spent specifically on mod_PLSQL web applications
Preferred / Nice-to-Have
Familiarity with Oracle HTTP Server / WebLogic configuration
Experienced with tools like TOAD, SQL Developer, SQL Plus, VSS