Senior Oracle Database / ETL Developer
$150,000–$200,000 year
HybridArlington, Virginia, United States
Job Summary
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 using packages, procedures, and bulk operations to handle extraction, transformation, and loading logic. Automate and orchestrate batch jobs across OS cron and Oracle's internal scheduler, monitoring pipeline health for accuracy and reliability. Troubleshoot data and performance issues, document processes, and participate in code reviews. Requires 10+ years of Oracle database development with significant hand-rolled ETL and batch automation experience. Hybrid schedule with two days per week onsite in Arlington, VA.
Required Qualifications
- 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, SQL*Loader, 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
- Experience with version control VSS, and ticketing tools (Jira)
Hiring someone like this?
Get your role in front of qualified candidates on Sorce.