Oracle Developer: PL/SQL & Performance Tuning

Quantum Technologies LLC; Madison (WI); On-site; USD 110,000 - 140,000; Full time

Job summary

Quantum Technologies. LLC in the United States is seeking an experienced Oracle Developer to join our database team. You will design, implement, and optimize Oracle database solutions, write advanced SQL and PL/SQL, and manage procedures, packages, and triggers to support complex business applications.

You will analyze requirements, implement performance improvements, and lead data migration efforts. Collaboration with developers, analysts, and QA will be essential to deliver secure, scalable

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.

Skills

Oracle Database

PL/SQL

Stored Procedures

Functions

Packages

Triggers

Database Design

Query Optimization

Materialized Views

ETL and Data Migration

REST APIs

Web Services

Tools

Oracle SQL Developer

Oracle Data Pump

Job description

Quantum Technologies. LLC in the United States is seeking an experienced Oracle Developer to join our database team. You will design, implement, and optimize Oracle database solutions, write advanced SQL and PL/SQL, and manage procedures, packages, and triggers to support complex business applications.

You will analyze requirements, implement performance improvements, and lead data migration efforts. Collaboration with developers, analysts, and QA will be essential to deliver secure, scalable