Mod Oracle PL Sql/Web Developer

ASRC Federal Holding CompanyArlington, VA

Apply with Sonara

Automate your job search with Sonara.

Submit 10x as many applications with less effort than one manual application.¹

Reclaim your time by letting our AI handle the grunt work of job searching.

We continuously scan millions of openings to find your top matches.

Overview

Schedule

Full-time

Education

Engineering (PE)

Career level

Senior-level

Remote

Hybrid remote

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

Automate your job search with Sonara.

Submit 10x as many applications with less effort than one manual application.

Apply with Sonara Apply manually

FAQs About Mod Oracle PL Sql/Web Developer Jobs at ASRC Federal Holding Company

What is the work location for this position at ASRC Federal Holding Company?

This job at ASRC Federal Holding Company is located in Arlington, VA, according to the details provided by the employer. Some roles may also include multiple work locations depending on the requirement.

What pay range can candidates expect for this role at ASRC Federal Holding Company?

Employer has not shared pay details for this role.

What employment applies to this position at ASRC Federal Holding Company?

ASRC Federal Holding Company lists this role as a Full-time position.

What experience level is required for this role at ASRC Federal Holding Company?

ASRC Federal Holding Company is looking for a candidate with "Senior-level" experience level.

What education level is required for this job?

The education requirement for this position is Engineering (PE). Candidates with relevant qualifications or equivalent experience may also be considered.

What is the process to apply for this position at ASRC Federal Holding Company?

You can apply for this role at ASRC Federal Holding Company either through Sonara's automated application system, which helps you submit applications 10X faster with minimal effort, or by applying manually using the direct link on the job page.