Mod Oracle PL SQL/Web Developer

ASRC Federal • Arlington, VA

1d • Hybrid

About The Position

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. This role involves designing, developing, and maintaining web applications served through Oracle mod_plsql. The developer will write and optimize complex PL/SQL packages and SQL queries, build interactive front-end interfaces, troubleshoot performance issues, and participate in code reviews, deployments, and production support.

Requirements

• 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) / Apache
• Generating dynamic HTML output directly from PL/SQL stored procedures
• Session and state management in stateless mod_plsql architectures
• Array parameter passing between pages
• URL parameter passing
• Proper understanding of the various locking strategies to maintain data integrity
• File upload/download functionality
• Expert-level development of stored procedures, functions, packages, and triggers
• Cursors (explicit, implicit, ref cursors), bulk operations (BULK COLLECT, FORALL), collections, and dynamic SQL
• Exception handling, autonomous transactions, and performance tuning of PL/SQL code
• Building and maintaining reusable PL/SQL APIs and business logic layers
• Dynamic SQL
• Advanced query writing, complex joins, analytic/window functions, subqueries, and set operations
• Query optimization using execution plans, hints, indexing strategies, and partitioning
• Data modeling, normalization, and writing DDL/DML for Oracle databases (19c and above)
• Hand-coding semantic HTML and responsive CSS layouts
• JavaScript for client-side validation, DOM manipulation, and interactivity
• AJAX 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
• 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

Nice To Haves

• Familiarity with Oracle HTTP Server / WebLogic configuration
• Experienced with tools like TOAD, SQL Developer, SQL Plus, VSS

Responsibilities

• Design, develop, and maintain web applications served through Oracle mod_plsql
• Write and optimize complex PL/SQL packages and SQL queries against large datasets
• Build interactive, AJAX-driven front-end interfaces backed by PL/SQL procedures
• Troubleshoot performance issues across the database, gateway, and browser layers
• Participate in code reviews, deployments, and production support

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level