Oracle Developer | PL/SQL, Tuning & ETL Specialist

Robotic Technologies Automation; Columbus (OH); On-site; USD 110,000 - 140,000; Full time

Job summary

Robotic Technologies Automation in Columbus, OH seeks an experienced Oracle Developer to design, develop, implement, and maintain database applications using Oracle technologies. The candidate should excel in PL/SQL, SQL, stored procedures, packages, triggers, performance tuning, and database development.

The role involves ETL, data migration, and collaboration with developers, analysts, and QA to deliver robust data solutions supporting BI and reporting needs.

Qualifications

• Strong experience in Oracle PL/SQL, SQL, stored procedures, functions, packages, triggers and performance tuning.
• Proven ability to design, develop and maintain database applications using Oracle technologies.
• Experience with Oracle 12c, 18c, 19c and 21c environments and ETL processes.

Responsibilities

• Design, develop, and maintain database applications using Oracle Database.
• Write complex SQL queries, PL/SQL procedures, functions, packages, and triggers.
• Develop and optimize database objects to improve application performance.
• Perform SQL query optimization and database performance tuning.
• Develop and maintain database schemas, tables, views, indexes, and sequences.
• Implement data migration, data integration, and database transformation processes.
• Work with Oracle environments 12c/18c/19c/21c.
• Develop and maintain ETL processes for data extraction, transformation, and loading.
• Perform database troubleshooting, debugging, and issue resolution.
• Implement data validation, integrity constraints, and database security.
• Collaborate with application developers, business analysts, and QA teams.
• Develop database reports and support BI requirements.
• Perform testing, deployment, and production support.

Skills

Oracle PL/SQL

SQL

Stored Procedures

Functions

Packages

Triggers

Performance Tuning

Database Development

Tools

SQL Developer

TOAD

SQL*Plus

ODI

Informatica

Job description

Robotic Technologies Automation in Columbus, OH seeks an experienced Oracle Developer to design, develop, implement, and maintain database applications using Oracle technologies. The candidate should excel in PL/SQL, SQL, stored procedures, packages, triggers, performance tuning, and database development.

The role involves ETL, data migration, and collaboration with developers, analysts, and QA to deliver robust data solutions supporting BI and reporting needs.