Oracle Developer

Job Description

Job Description

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!