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.

• Design, develop, and maintain web applications served through Oracle
• 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
• Participate in code reviews, deployments, and production support

• Configuring and maintaining  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  architectures
• Array parameter passing between pages
• 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, ), 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
• AJAX integration with  endpoints for asynchronous, partial‑page updates (XMLHttpRequest / Fetch, JSON or XML payloads returned from PL/SQL procedures)

• 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  web applications

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

We invest in the lives of our employees, both in and out of the workplace, by providing competitive pay and benefits packages. Benefits offered may include health care, dental, vision, life insurance; 401(k); education assistance; paid time off including PTO, holidays, and any other paid leave required by law. The salary offered will depend on several factors including, but not limited to, relevant experience, skills, education, geographic location, internal equity, business needs, and other factors permitted by law.

Posted pay ranges are a general guideline only and are not a guarantee of compensation or salary.

ASRC Federal and its Subsidiaries are Equal Opportunity employers. All qualified applicants will receive consideration for employment without regard to race, gender, color, age, sexual orientation, gender identification, national origin, religion, marital status, ancestry, citizenship, disability, protected veteran status, or any other factor prohibited by applicable law.