Senior Oracle Database / ETL Developer

ASRC Federal•Arlington, VA

2d•Hybrid

About The Position

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.

Requirements

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, ref 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, SQLLoader, and UTL_FILE 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 (DBMS_SCHEDULER / DBMS_JOB), 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

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)