Developer - Oracle

R+L Carriers; Los Angeles (CA); On-site; USD 120,000 - 150,000; Full time

Benefits offered by this job

Medical insurance

Dental insurance

Vision insurance

401(k) retirement plan

Vacation lodging at employee resorts

Job summary

R+L Carriers is seeking a Senior Oracle Developer to join the Information Technology Department in Los Angeles. The role focuses on SQL/PLSQL development in Oracle 19c or higher, optimizing performance, and supporting enterprise software initiatives.

Ideal candidates will have 5+ years of experience with Oracle and strong communication skills, with the ability to mentor other developers and collaborate with cross-functional teams.

Qualifications

• 5+ years of hands-on SQL/PLSQL development in Oracle 19c or higher.
• Proven experience with Oracle performance tuning.
• Experience supporting critical, high-volume transactional databases.
• Experience using TOAD and OEM Cloud Control for development and monitoring.
• Strong analytical and problem-solving skills; ability to communicate with stakeholders.

Responsibilities

• Develop PL/SQL packages, procedures, functions, and triggers in Oracle 19c.
• Tune and optimize SQL and PL/SQL for performance and scalability.
• Maintain shared tooling to support partitioning and purging.
• Guide execution plan optimization and statistics gathering.
• Mentor and support Oracle developers across projects.

Skills

PL/SQL

Oracle 19c

SQL tuning

Performance tuning

TOAD

Oracle OEM Cloud Control

Mentoring

Communication

Tools

TOAD

Oracle OEM Cloud Control

Job description

Job Summary

R+L Carriers Information Technology Department is growing and has an immediate opening for a Senior Oracle Developer. Successful candidates will work within the Information Technology Department performing development and optimization activities in the SQL/PLSQL programming language in Oracle 19c or higher. The candidates will be key members of an interdisciplinary team supporting the company’s enterprise software development initiatives, working with different stakeholders to understand real world business requirements and to develop or optimize enterprise level solutions.

Essential Duties and Responsibilities:

• Develop PL/SQL Packages, Stored Procedures, Functions, Triggers, SQL statements in Oracle 19c
• Performance Tuning including optimizing SQL code and PL/SQL packages
• Maintaining shared tooling including PL/SQL packages that facilitate partitioning and purging
• Index based optimization, including statistics gathering and optimizing execution plans
• Work with Oracle Enterprise Manager (Cloud Control) to monitor and optimize SQL statements
• Improve application architecture to prevent deadlocks in highly concurrent applications
• Monitor and reduce SQL plan degradation
• Implement SQL profiles and SQL plan baselines to help with critical production issues
• Provide mentoring and support to Oracle developers

Qualifications

• Extensive Experience (5+ years) in SQL and PL/SQL Programming in Oracle 19c
• Proven Experience with Oracle Performance Tuning
• Extensive experience supporting critical systems and providing technical solutions
• Experience working with high volume transactional databases
• Experience working with development tools like TOAD
• Experience working with OEM tools like Cloud control
• Strong analytical and problem-solving skills
• Strong verbal and written communication skills

We offer a comprehensive benefits package that includes medical, dental, vision, life, a 401(k)-retirement plan and free vacation lodging at our employee resorts in Daytona Beach, FL, Big Bear Lake, CA, Ocean Isle Beach, NC and Pigeon Forge, TN.