Job Description
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
Numbers & Facts
| Location | Arlington, VA (Remote) |
| Industry | Aerospace and Defense |
| Company Size | 5,000 to 9,999 employees |
| Year Founded | 2003 |
| Website | http://www.asrcfederal.com |
Benefits
Military Leave, On Site Cafeteria, Parking, Prescription Drug Coverage, Professional Development, 401K, Employee Referral Program, Flexible Spending Accounts, Employee Events, Tuition Reimbursement, Work From Home, Life Insurance, Merchandise Discounts
About Company
ASRC Federal comprises a family of companies that provide mission-critical services to federal government agencies dedicated to defense, civil and intelligence support. Our customer-focused service delivery model and emphasis on operational excellence are foundational elements infused in all our companies. The reliability and quality of day-in, day-out service delivery from our family of companies ensure our customers that we keep our sights on their mission-critical priorities.