Job Description

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, VAResponsibilitiesDevelop and maintain complex PL/SQL packages and SQL for business, integration, and reporting needsDesign, build, and optimize hand-rolled PL/SQL ETL pipelinesAutomate and orchestrate batch jobs across OS cron and Oracle's internal schedulerMonitor pipeline and job health for accuracy, performance, and reliabilityTroubleshoot data and performance issues across the database and batch layersDocument processes and participate in code reviews and production supportShell scripting (Bash/Korn) for cron orchestration, file handling, and job wrappersExperience with version control VSS, and ticketing tools (Jira)Required Skills & ExperienceOracle Database10+ years hands-on experience with Oracle (11g/12c/19c)Strong understanding of database architecture, data modeling, normalization, and schema designPerformance tuning using execution plans, indexing, partitioning, and statisticsSQLAdvanced query development: complex joins, analytic/window functions, subqueries, set operations, and hierarchical queriesWriting and optimizing DDL/DML for large datasetsQuery troubleshooting and optimizationPL/SQLExpert-level development of stored procedures, functions, packages, and triggersCursors, ref cursors, collections, bulk operations (BULK COLLECT, FORALL), and dynamic SQLRobust exception handling, autonomous transactions, and modular, reusable code designCustom PL/SQL ETL (Hand-Rolled)Designing and building ETL pipelines entirely in PL/SQL — no reliance on commercial ETL toolsExtraction, transformation, and loading logic implemented through packages and proceduresIngesting data via external tables, SQL*Loader, and UTL_FILE for flat-file processingHandling incremental and full loads, staging strategies, error handling, logging, and reconciliationEnsuring data quality and integrity through validation logic and audit trailsOptimizing high-volume transformations using set-based SQL and bulk processingBatch Scheduling (OS Cron + Oracle Scheduler)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 dependenciesCoordinating workloads that span both the OS and database scheduling layersMonitoring execution, building logging/alerting, and handling failures, retries, and restartabilityQualificationsBachelor’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 experienceJobFamilyInformation TechnologyJobFunctionApplication DevelopmentPayTypeSalary

Job Tags

Similar Jobs