Oracle Developer: SQL/PLSQL, Data Modeling & Tuning

Ethereum Technologies LLC; Madison (WI); On-site; USD 100,000 - 150,000; Full time

Job summary

Ethereum Technologies in Madison, WI seeks an Oracle Developer to design, develop and optimize Oracle database solutions. You will write complex SQL and PL/SQL, build stored procedures, packages, triggers, and manage objects like views and materialized views.

The role emphasizes data integration, migration, security, and performance tuning across enterprise applications, with collaboration among developers, analysts, and QA teams. Strong learning mindset and SDLC familiarity are valued.

Qualifications

• Hands-on experience in designing database solutions and implementing Oracle database applications.
• Ability to write complex SQL queries, PL/SQL procedures, functions, packages and triggers.
• Experience with data modeling, data migration, and ETL processes.
• Capability to analyze business requirements and translate them into technical database solutions.
• Experience with query optimization and performance tuning.
• Experience collaborating with development, QA, and business teams.

Responsibilities

• Design, develop, and maintain Oracle database applications based on business requirements.
• Write complex SQL queries, PL/SQL procedures, functions, packages, and triggers.
• Develop and manage database objects including tables, views, indexes, and materialized views.
• Analyze requirements and translate into technical database solutions.
• Perform SQL optimization and performance tuning.
• Develop and maintain data integration and migration processes.
• Support Oracle Database environments for enterprise applications.
• Implement database security and data integrity controls.
• Troubleshoot issues and perform root-cause analysis.
• Monitor performance and improve application efficiency.
• Collaborate with application developers, business analysts and QA teams.
• Participate in code reviews, unit testing, integration testing, and deployments.
• Support database upgrades and production releases.
• Prepare technical documentation and maintain standards.

Skills

Oracle Database

SQL

PL/SQL

Stored Procedures

Packages

Triggers

Data Modeling

Query Optimization

Materialized Views

Views

Indexes

SQL Developer

Data Pump

ETL

Data Migration

REST APIs

Web Services

Python

Java

Agile

SDLC

Analytical Skills

Job description

Ethereum Technologies in Madison, WI seeks an Oracle Developer to design, develop and optimize Oracle database solutions. You will write complex SQL and PL/SQL, build stored procedures, packages, triggers, and manage objects like views and materialized views.

The role emphasizes data integration, migration, security, and performance tuning across enterprise applications, with collaboration among developers, analysts, and QA teams. Strong learning mindset and SDLC familiarity are valued.