Sr. Oracle Database/ETL Developer (100% remote)
- Discuss this with your agent
- Open in Claude
- Open in ChatGPT
Prepare application
- Draft this with your agent
- Open in Claude
- Open in ChatGPT
Role details
Tech stack
+10 more
Job description
Marathon TS 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., * 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
Requirements
Oracle Database, Database Extract Transform and Load (ETL), Database Programming, Oracle Database, Oracle PL-SQL, SQL (Structured Query Language), Database Extract Transform and Load (ETL), Database Programming, Cron Job Scheduling, Operating Systems, 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
Apply for this position
This job is hosted externally. Click below to view the full posting and apply.
Prepare application
- Draft this with your agent
- Open in Claude
- Open in ChatGPT
Good distractions
Loading talks and stories from around this roleβ¦