> Markdown version of [/jobs/ext/1731390-mod-oracle-pl-sql-web-developer](https://www.wearedevelopers.com/jobs/ext/1731390-mod-oracle-pl-sql-web-developer). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Mod Oracle PL SQL/Web Developer - **Company:** ASRC FEDERAL - **Location:** Arlington, VA, United States - **Experience:** Experienced - **Contract:** Permanent contract - **Skills:** HTML, JavaScript (Programming Language), Application Programming Interfaces (APIs), Ajax (Programming Language), Apache HTTP Server, Business Logic, Oracle WebLogic Server, Big Data, Browser Compatibility, Cascading Style Sheets (CSS), Code Review, Databases, System Configuration, Data Manipulation Languages, Database Connection, Cursor (Graphical User Interface Elements), Database Queries, Software Debugging, Web Development, Document Object Model, Web Servers, JSON, Oracle Databases, Oracle (Applications), Performance Tuning, Query Optimization, Standard Sql, Responsive Web Design, Semantic HTML, SQL Stored Procedures, PL-SQL, SQL*Plus, SQL Databases, Web Applications, Extensible Markup Language (XML), Database Optimization, Information Technology, Toad (Software), Front End Software Development - **Published:** July 17, 2026 - **Apply:** https://www.indeed.com/viewjob?jk=433597461a843090 ## About the Role * 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 ## Description * 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 Required Technical Skills Oracle 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) / 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 PL/SQL * 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 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) Front-End: HTML, CSS, JavaScript, AJAX * 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 ## Related Videos - [Building with IBM Bob](https://www.wearedevelopers.com/videos/100275-building-with-ibm-bob) - [Tips and Tricks for Working with JSON](https://www.wearedevelopers.com/videos/1229-tips-and-tricks-for-working-with-json) - [The Resilience of the World Wide Web](https://www.wearedevelopers.com/videos/1281-the-resilience-of-the-world-wide-web) - [Web development best practices in 2021](https://www.wearedevelopers.com/videos/280-web-development-best-practices-in-2021) - [Introducing JSON Structure](https://www.wearedevelopers.com/videos/100219-introducing-json-structure) - [NoLoJS - Avoiding JavaScript Cruft with HTML and CSS - Aaron T. Grogg](https://www.wearedevelopers.com/videos/1806-nolojs-avoiding-javascript-cruft-with-html-and-css-aaron-t-grogg) ## Related Articles - [93 Java Interview Questions You Should Prepare For](https://www.wearedevelopers.com/magazine/14-93-java-interview-questions-you-should-prepare-for) - [Top 10 Java Libraries](https://www.wearedevelopers.com/magazine/364-top-10-java-libraries) - [What is a web developer?](https://www.wearedevelopers.com/magazine/18-what-is-a-web-developer) - [7 Important Tips That Every Software Developer Should Know](https://www.wearedevelopers.com/magazine/101-7-important-tips-that-every-software-developer-should-know) - [Résumé-Driven Development: How IT trends affect the job market for software developers](https://www.wearedevelopers.com/magazine/59-resume-driven-development-how-it-trends-affect-the-job-market-for-software-developers) - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story)