Developer - Oracle

R+L Carriers; Wilmington (OH); On-site; USD 120,000 - 160,000; Full time

Benefits offered by this job

Medical Insurance

Dental Insurance

Vision Insurance

Life Insurance

401(k) Plan

Vacation lodging at employee resorts

Job summary

R+L Carriers Information Technology Department is seeking a Senior Oracle Developer to join an interdisciplinary team responsible for enterprise software development in Oracle 19c or higher. You will develop and optimize SQL/PLSQL, tune performance, mentor other Oracle developers, and collaborate with stakeholders to translate business needs into robust solutions.

The role includes building PL/SQL packages, managing performance, monitoring with OEM Cloud Control, and improving architecture to

Qualifications

• 5+ years of SQL/PL/SQL in Oracle 19c
• Proven experience with Oracle performance tuning
• Experience supporting critical systems and high-volume databases
• Experience with TOAD and Oracle tools
• Strong analytical and communication skills

Responsibilities

• Develop PL/SQL packages, procedures, functions, triggers, and SQL in Oracle 19c
• Perform performance tuning and optimize SQL code
• Maintain tooling for partitioning and purging
• Gather statistics and optimize execution plans
• Monitor SQL statements with OEM Cloud Control
• Improve architecture to prevent deadlocks in highly concurrent apps
• Mentor and support Oracle developers

Skills

SQL

PL/SQL

Oracle 19c

Performance Tuning

TOAD

Cloud Control

Mentoring

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

Benefits

• 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.