> Markdown version of [/jobs/ext/1815570-senior-oracle-database-etl-developer](https://www.wearedevelopers.com/jobs/ext/1815570-senior-oracle-database-etl-developer). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Senior Oracle Database / ETL Developer - **Company:** ASRC FEDERAL - **Location:** Arlington, VA, United States - **Experience:** Expert - **Contract:** Permanent contract - **Skills:** JIRA, Bash Shell, Big Data, Code Review, Databases, Cron, Extract Transform Load (ETL), Data Manipulation Languages, Cursor (Graphical User Interface Elements), File Systems, Korn Shell, Oracle Databases, Oracle (Applications), Performance Tuning, Standard Sql, Shell Script, SQL Stored Procedures, PL-SQL, SQL Databases, Data Logging, Indexer, Information Technology, Software Version Control - **Published:** July 17, 2026 - **Apply:** https://www.indeed.com/viewjob?jk=c8b433b06eb23793 ## About the Role Oracle Database * 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 SQL * 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 PL/SQL * 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, * 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 ## Description * 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), * 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 Batch 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 dependencies * Coordinating workloads that span both the OS and database scheduling layers * Monitoring execution, building logging/alerting, and handling failures, retries, and restartability ## Related Videos - [Improving quality with Agentic AI with Rovo Dev and Xray](https://www.wearedevelopers.com/videos/2005-improving-quality-with-agentic-ai-with-rovo-dev-and-xray) - [From clicks to cribs - How to find your dream home with web scraping](https://www.wearedevelopers.com/videos/767-from-clicks-to-cribs-how-to-find-your-dream-home-with-web-scraping) - [How building an industry DBMS differs from building a research one](https://www.wearedevelopers.com/videos/768-how-building-an-industry-dbms-differs-from-building-a-research-one) - [Collaboration Quantified: Lessons from Open Source Developer Networks](https://www.wearedevelopers.com/videos/1422-collaboration-quantified-lessons-from-open-source-developer-networks) - [Enjoying SQL data pipelines with dbt](https://www.wearedevelopers.com/videos/823-enjoying-sql-data-pipelines-with-dbt) - [Is your backend a hodgepodge of queues, event stores and cron jobs? Durable Execution to the Rescue.](https://www.wearedevelopers.com/videos/744-is-your-backend-a-hodgepodge-of-queues-event-stores-and-cron-jobs-durable-execution-to-the-rescue) ## Related Articles - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers) - [93 Java Interview Questions You Should Prepare For](https://www.wearedevelopers.com/magazine/14-93-java-interview-questions-you-should-prepare-for) - [How We Built a Worry-Free System That Runs for 10+ Years – And What We’d Do Again](https://www.wearedevelopers.com/magazine/751-how-we-built-a-worry-free-system-that-runs-for-10-years-and-what-we-d-do-again) - [Résumé-Driven Development: How IT trends affect the job market for software developers](https://www.wearedevelopers.com/magazine/59-resume-driven-development-how-it-trends-affect-the-job-market-for-software-developers) - [Quick guide: How to write a Software Developer CV](https://www.wearedevelopers.com/magazine/37-quick-guide-how-to-write-a-software-developer-cv)