Senior Oracle Database/ETL Developer
Listed on 2026-07-19
-
Software Development
Data Engineering
Posted Wednesday, July 15, 2026 at 5:00 AM
ASRC Federal is a leading government contractor furthering missions in space, public health and defense. As an Alaska Native owned corporation, our work helps secure an enduring future for our shareholders. Join our team and discover why we are atop veteran employer and Certified Great Place to Work
ASRC Federal Agile Management LLC is seeking an experienced Senior Oracle Database / ETL Developer with deep expertise in SQL, PL/SQL, batch scheduling, and custom ETL development. The ideal candidate has spent a decade building data-intensive applications and hand-rolled ETL pipelines in PL/SQL and automating batch workloads using both OS-level cron and Oracle's internal scheduler.
Work Location: Hybrid / 2 days per week onsite in Arlington, VA
Responsibilities- Develop and maintain complex PL/SQL packages and SQL for business, integration, and reporting needs
- Design, build, and optimize hand-rolled PL/SQL ETL pipelines
- Automate and orchestrate batch jobs across OS cron and Oracle's internal scheduler
- Monitor pipeline and job health for accuracy, performance, and reliability
- Troubleshoot data and performance issues across the database and batch layers
- Document processes and participate in code reviews and production support
- Shell scripting (Bash/Korn) for cron orchestration, file handling, and job wrappers
- Experience with version control VSS, and ticketing tools (Jira)
- 10+ years hands-on experience with Oracle (11g/12c/19c)
- Strong understanding of database architecture, data modeling, normalization, and schema design
- Performance tuning using execution plans, indexing, partitioning, and statistics
- Advanced query development: complex joins, analytic/window functions, subqueries, set operations, and hierarchical queries
- Writing and optimizing DDL/DML for large datasets
- Query troubleshooting and optimization
- Expert-level development of stored procedures, functions, packages, and triggers
- Cursors, , collections, bulk operations (BULK COLLECT, FORALL), and dynamic SQL
- Robust exception handling, autonomous transactions, and modular, reusable code design
- Designing and building ETL pipelines entirely in PL/SQL - no reliance on commercial ETL tools
- Extraction, transformation, and loading logic implemented through packages and procedures
- Ingesting data via external tables, SQL
* Loader, and for flat-file processing - Handling incremental and full loads, staging strategies, error handling, logging, and reconciliation
- Ensuring data quality and integrity through validation logic and audit trails
- Optimizing high-volume transformations using set-based SQL and bulk processing
- Scheduling and maintaining batch jobs using OS-level cron (Unix/Linux)
- Building and managing jobs with Oracle's internal scheduler ( / ), including programs, schedules, chains, and job dependencies
- Coordinating workloads that span both the OS and database scheduling layers
- Monitoring execution, building logging/alerting, and handling failures, retries, and restartability
- Bachelor’s degree in computer science, IT, or related field (or equivalent experience)
- 10+ years of Oracle database development with significant hand-rolled ETL and batch automation experience
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.
#J-18808-Ljbffr(If this job is in fact in your jurisdiction, then you may be using a Proxy or VPN to access this site, and to progress further, you should change your connectivity to another mobile device or PC).