Oracle Developer: PL/SQL, SQL & DB Design

Robotic Technologies Automation; Madison (WI); On-site; USD 90,000 - 130,000; Full time

Job summary

Robotic Technologies Automation is seeking an Oracle Developer to design, develop, and optimize Oracle database solutions. You will work on PL/SQL programming, stored procedures, and data modeling for enterprise applications.

The role involves performance tuning, data migration, and ensuring data integrity across Oracle environments, collaborating with developers and QA teams on deployments.

Qualifications

• Hands-on with Oracle Database and PL/SQL
• Experience building enterprise Oracle solutions
• Strong SQL and performance tuning skills
• Ability to design scalable data models and migrations
• Familiarity with web services and REST APIs

Responsibilities

• Design, develop, and maintain Oracle database applications.
• Write complex SQL queries, PL/SQL procedures, functions, packages, and triggers.
• Develop and manage tables, views, indexes, and materialized views.
• Translate business requirements into technical database designs.
• Perform SQL optimization and performance tuning.
• Develop and maintain data integration and migration processes.
• Support enterprise applications in Oracle environments.
• Implement database security and data integrity controls.
• Troubleshoot issues and perform root cause analysis.
• Monitor performance and optimize application efficiency.
• Collaborate with developers, analysts, and QA teams.
• Participate in code reviews and deployment activities.
• Prepare technical documentation and development standards.

Skills

Oracle Database

Oracle SQL and PL/SQL

Stored Procedures and Functions

Packages and Triggers

Database Design and Data Modeling

Query Optimization and Performance T…

Views, Indexes, and Materialized Views

Oracle SQL Developer

Oracle Data Pump

ETL and Data Migration

REST APIs and Web Services

Tools

OCI

Oracle Cloud Infrastructure

Oracle APEX

Oracle Forms

Job description

Robotic Technologies Automation is seeking an Oracle Developer to design, develop, and optimize Oracle database solutions. You will work on PL/SQL programming, stored procedures, and data modeling for enterprise applications.

The role involves performance tuning, data migration, and ensuring data integrity across Oracle environments, collaborating with developers and QA teams on deployments.