Oracle Developer

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

US Citizen, Green Card, H-1B, OPT-EAD, CPT, Other

Work Authorization: US Citizen, Green Card, OPT-EAD, CPT, H-1B, H4-EAD, Other

Job Summary

We are seeking a skilled Oracle Developer with strong expertise in database development, PL/SQL programming, and enterprise application solutions. The ideal candidate should have hands-on experience in designing database solutions, optimizing queries, developing stored procedures, and supporting complex business applications.

Roles & 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 business requirements and translate them into technical database solutions.
• Perform SQL query optimization and database performance tuning.
• Develop and maintain data integration and migration processes.
• Work with Oracle Database environments to support enterprise applications.
• Implement database security, access controls, and data integrity measures.
• Troubleshoot database issues and perform root cause analysis.
• Monitor database performance and improve application efficiency.
• Collaborate with application developers, business analysts, and QA teams.
• Participate in code reviews, unit testing, integration testing, and deployment activities.
• Support database upgrades, enhancements, and production releases.
• Prepare technical documentation and maintain development standards.

Required Technical Skills

• Oracle Database
• Oracle SQL and PL/SQL
• Stored Procedures and Functions
• Packages and Triggers
• Database Design and Data Modeling
• Query Optimization and Performance Tuning
• Views, Indexes, and Materialized Views
• Oracle SQL Developer
• Oracle Data Pump
• ETL and Data Migration
• REST APIs and Web Services

Preferred Qualifications

• Knowledge of Oracle RAC and Data Guard.
• Experience with Oracle Cloud Infrastructure (OCI).
• Familiarity with Oracle APEX and Oracle Forms.
• Knowledge of Python or Java for database integration.
• Understanding of Agile and SDLC methodologies.
• Strong analytical and problem-solving skills.

We are an equal opportunity employer. All aspects of employment including the decision to hire, promote, discipline, or discharge, will be based on merit, competence, performance, and business needs. We do not discriminate on the basis of race, color, religion, marital status, age, national origin, ancestry, physical or mental disability, medical condition, pregnancy, genetic information, gender, sexual orientation, gender identity or expression, national origin, citizenship/ immigration status, veteran status, or any other status protected under federal, state, or local law.