Oracle Developer

Strategic Data Systems, Inc.; Cincinnati (OH); Hybrid; USD 110,000 - 150,000; Full time

Benefits offered by this job

Competitive salary

Health benefits (medical, dental, and

Life and disability insurance

401(k) with match

Paid vacation

Bench time

Training allowance

Referral bonuses

Job summary

Strategic Data Systems, Inc. (SDS) is hiring an Oracle Data Engineer in Cincinnati, OH with remote USA option. You will design, build, and maintain ETL pipelines and data warehouses across multiple source systems, ensuring data quality and timely delivery.

You will work with Oracle SQL/PL/SQL, Unix shell scripting, Git, Snowflake and DBT, collaborating with cross-functional teams to meet business data needs while supporting deployments and automation.

Qualifications

• Expert-level PL/SQL with complex packages, materialized views, performance tuning.
• Strong Oracle DB Engineering including schema design, query optimization, indexing and partitioning.
• Linux/Shell Scripting & Bash for building scripts, automating ETL, and scheduling dependencies.
• SQL, ETL, Data Warehousing with strong data model understanding, orchestration and pipelines.
• Agile Delivery with sprint participation, estimates, and delivering high-quality increments.
• Table/ETL Scheduling Dependencies with familiarity of job schedulers (Control-M, Autosys, etc.).
• Strong Communication with monthly stakeholder presentations, status updates and risk reporting.

Responsibilities

• Design, develop, and maintain ETL pipelines and data warehouse processes across multiple source systems.
• Build and enhance data integration workflows, data validation, reconciliation, and resolve data quality issues.
• Provide production support by monitoring jobs, troubleshooting failures, and ensuring timely data delivery.
• Manage deployments and change requests, and continuously improve process reliability, automation, and monitoring.
• Collaborate with cross-functional teams to support business data needs and ensure data accuracy and consistency.

Skills

PL/SQL

Oracle DB Engineering

Linux/Shell

SQL/ETL/Data Warehousing

Agile Delivery

Job Scheduling

Communication

Tools

Unix Shell Scripting

Git

Snowflake

DBT

Control-M

Autosys

Job description

Careers at SDS

Oracle Developer

About This Role

For more than three decades, Strategic Data Systems (SDS) has been a software consultancy firm specializing in strategy, technology, and business transformation for Fortune 100 companies, mid-sized firms, and startups. At SDS, we empower our development teams to address our clients’ critical business challenges by leveraging cutting edge technologies. If you seek a workplace where your contributions are truly appreciated, then SDS is the company for you. Join us today to work alongside fellow development specialists and become a crucial part of our dynamic and cohesive community.

Title: Oracle Data Engineer

Location: Cincinnati, OH preferred, REMOTE USA (EST) OK

Design, develop, and maintain ETL pipelines and data warehouse processes across multiple source systems. Build and enhance data integration workflows, perform data validation and reconciliation, and resolve data quality issues. Provide production support by monitoring jobs, troubleshooting failures, and ensuring timely data delivery. Manage deployments and change requests, and continuously improve process reliability, automation, and monitoring. Collaborate with cross-functional teams to support business data needs and ensure data accuracy and consistency.

Technologies / Tools Used

Oracle SQL, PL/SQL, Unix Shell Scripting, Git, ETL/Data Warehousing concepts, Snowflake, DBT, job scheduling and monitoring tools.

Top Skills (Must Have)

• Expert-level PL/SQL– complex packages, materialized views, performance tuning, bulk operations.
• Strong Oracle Database Engineering– schema design, query optimization, indexing, partitioning.
• Linux/Shell Scripting & Bash– build scripts, automate ETL, support scheduling dependencies.
• SQL, ETL, Data Warehousing– strong understanding of data models, orchestration, pipelines.
• Agile Delivery– participates in sprints, provides estimates, delivers high-quality increments.
• Table/ETL Scheduling Dependencies– familiar with job schedulers (Control-M, Autosys, etc.)
• Strong Communication– monthly stakeholder presentations, status updates, risk reporting.

Nice-to-Have

• Migration experience (legacy Oracle → new Oracle environments)
• Exposure to CI/CD for data pipelines
• Knowledge of on-prem and cloud data platforms
• Experience supporting large banking/regulated environments

What You’ll Get

SDS, Inc. provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, gender, sexual orientation, national origin, age, disability, genetic information, marital status, amnesty, or status as a covered veteran in accordance with applicable federal, state, and local laws.

• Competitive base salary
• Medical, dental, and vision insurance coverage
• Optional life and disability insurance provided
• 401(k) with a company match and optional profit sharing
• Paid vacation time
• Paid Bench time
• Training allowance offering
• You’ll be eligible to earn referral bonuses!