Oracle Developer

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

Job summary

Quantum Technologies LLC in Columbus, OH seeks an experienced Oracle Developer to design, develop, and maintain database applications using Oracle technologies. You will work with PL/SQL, SQL, and various Oracle objects to deliver robust data solutions.

Responsibilities include performance tuning, data migration, ETL processes, and collaboration with developers, business analysts, and QA teams to ensure high-quality BI reporting and reliable database operations.

Qualifications

• 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 12c, 18c, 19c, and 21c database environments.
• 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 business intelligence requirements.
• Perform database testing, deployment, and production support.
• Maintain technical documentation and database development standards.
• Support database backup, recovery, and disaster recovery activities.

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 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 12c, 18c, 19c, and 21c database environments.
• 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 business intelligence requirements.
• Perform database testing, deployment, and production support.
• Maintain technical documentation and database development standards.
• Support database backup, recovery, and disaster recovery activities.

Skills

Oracle PL/SQL

SQL

Performance tuning

Database Development

Oracle 12c/19c/21c

Tools

SQL Developer

TOAD

SQL*Plus

ODI

Informatica

Oracle BI Publisher

Oracle Reports

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 an experienced Oracle Developer responsible for designing, developing, implementing, and maintaining database applications using Oracle technologies. The ideal candidate should have strong experience in Oracle PL/SQL, SQL, Stored Procedures, Functions, Packages, Triggers, Performance Tuning, and Database Development.

Roles and 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 12c, 18c, 19c, and 21c database environments.
• 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 business intelligence requirements.
• Perform database testing, deployment, and production support.
• Maintain technical documentation and database development standards.
• Support database backup, recovery, and disaster recovery activities.

Required Technical Skills

• Database: Oracle Database 12c, 19c, 21c
• Programming: SQL, PL/SQL
• Oracle Tools: SQL Developer, TOAD, SQL*Plus
• Database Objects: Stored Procedures, Functions, Packages, Triggers, Views
• Performance Tuning: Explain Plan, Indexing, Query Optimization
• ETL Tools: Oracle Data Integrator (ODI), Informatica
• Reporting Tools: Oracle Reports, Oracle BI Publisher
• Data Integration: SQL Loader, External Tables, Database Links

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.