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.

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)

Required Skills & Experience 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

Custom PL/SQL ETL (Hand-Rolled)

• 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

Qualifications

• 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

#cjjobs Marathon TS is committed to the development of a creative, diverse and inclusive work environment. In order to provide equal employment and advancement opportunities to all individuals, employment decisions at Marathon TS will be based on merit, qualifications, and abilities. Marathon TS does not discriminate against any person because of race, color, creed, religion, sex, national origin, disability, age or any other characteristic protected by law (referred to as "protected status "). Remote Skills: Analysis Skills, Atlassian JIRA, Automation, Bash Scripting, Code Reviews, Computer Science, Cron Job Scheduling, Data Description Language (DDL), Data Modeling, Data Quality, Data Sets, Database Architecture, Database Design, Database Extract Transform and Load (ETL), Database Management Software/Systems (DBMS), Database Programming, Error Handling, Identify Issues, Linux Operating System, Operating Systems, Oracle, Oracle 11i, Oracle Database, Oracle PL-SQL, Oracle SQL*Loader, Performance Tuning/Optimization, Procedure Development, Production Support, Query Optimization, Reconciliation, SQL (Structured Query Language), Schedule Development, Source Code/Configuration Management (SCM), Statistics, Stored Procedures, Unix Operating Systems, Unix Shell Programming Marathon TS, Inc.