Senior Oracle Developer: PL/SQL, Tuning & ETL

Ethereum Technologies LLC; Columbus (OH); On-site; USD 100,000 - 130,000; Full time

Job summary

Ethereum Technologies is seeking an experienced Oracle Developer to design, implement, and maintain database applications using Oracle technologies. The role focuses on PL/SQL development, performance tuning, and data integration.

The ideal candidate will work with Oracle 12c–21c environments, develop ETL processes, and collaborate with cross-functional teams to deliver reliable BI reports and data solutions.

Qualifications

• Experience designing and maintaining Oracle database applications.
• Strong PL/SQL development skills including procedures, functions, packages, and triggers.
• Proficient SQL writing and query optimization capabilities.
• Familiar with Oracle tools for development and debugging.
• Experience with ETL tools ODI or Informatica.
• Experience with reporting tools Oracle Reports or BI Publisher.
• Knowledge of data migration and data integration processes.

Responsibilities

• Design, develop, and maintain Oracle database applications.
• Write complex SQL queries, PL/SQL procedures, functions, packages, and triggers.
• Develop and optimize database objects to improve performance.
• Perform SQL query optimization and database performance tuning.
• Develop and maintain schemas, tables, views, indexes, and sequences.
• Implement data migration and data transformation processes.
• Work with Oracle 12c, 18c, 19c, and 21c environments.
• Develop and maintain ETL processes for data extraction, transformation, and loading.
• Troubleshoot, debug, and resolve database issues.
• Implement data validation and security controls.
• Collaborate with developers, analysts, and QA teams.
• Develop reports and support BI requirements.
• Perform testing, deployment, and production support.
• Maintain database development standards and documentation.
• Support backup, recovery, and DR activities.

Skills

Oracle 12c/19c/21c

PL/SQL

SQL

SQL Developer

TOAD

SQL*Plus

Stored Procedures

Functions

Packages

Triggers

Views

Performance Tuning

Explain Plan

Indexing

Query Optimization

ODI

Informatica

Oracle Reports

BI Publisher

SQL Loader

External Tables

Database Links

Tools

SQL Developer

TOAD

SQL*Plus

ODI

Informatica

Oracle Reports

BI Publisher

SQL Loader

External Tables

Database Links

Job description

Ethereum Technologies is seeking an experienced Oracle Developer to design, implement, and maintain database applications using Oracle technologies. The role focuses on PL/SQL development, performance tuning, and data integration.

The ideal candidate will work with Oracle 12c–21c environments, develop ETL processes, and collaborate with cross-functional teams to deliver reliable BI reports and data solutions.