Mod Oracle PL Sql/Web Developer
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 Remote 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 Skills: AJAX (Asynchronous JavaScript and XML), Agile Programming Methodologies, Analysis Skills, Application Programming Interface (API), CSS (Cascading Style Sheet), Code Reviews, Computer Science, Computer Security, DHTML (Dynamic HTML), DOM (Document Object Model), Data Description Language (DDL), Debugging Skills, HTML (HyperText Markup Language), HTTP (HyperText Transport Protocol), Information Technology & Information Systems, Internet Application, JSON, JavaScript, Mathematics, Microsoft Access Database, Oracle, Oracle Applications, Oracle Database, Oracle PL-SQL, Oracle SQLPlus, Oracle WebLogic Server, Performance Tuning/Optimization, Physics, Procedure Development, Production Support, Quest Software TOAD, SQL (Structured Query Language), Software Administration, Stored Procedures, Systems Administration/Management, United States Drug Enforcement Agency (DEA), User Interface/Experience (UI/UX), Web Browsers, Web Programming, Wheel/Front-End Loader, XML (EXtensible Markup Language) undefined: ASRC Federal Holding 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. Company Size: 5,000 to 9,999 employees Industry: Aerospace and Defense undefined: 2003 Website: http://www.asrcfederal.com