About the role

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.
Originally posted on Himalayas

Interview prep

Walk in with sharper answers.

Use this as a quick practice sheet before you speak with the employer.

Senior

Technology & IT MySQL SQL Developer Oracle Technology Senior level

Likely questions

Tell us about work you have done that is close to the Developer - Oracle role.
How would you approach your first 30 days at R+L Carriers?
Which of MySQL, SQL and Developer have you used recently, and what did it help you achieve?
How have you led people, improved a process, or made a hard decision in a previous role?
How do you handle busy days, changing priorities, or pressure at work?

Prepare before the call

A recent example that proves your experience with MySQL, SQL and Developer.
One short story with a problem, your action, and the result.
Two examples that show the strengths listed on your CV.
A clear reason why this role and company interest you.
Your availability, preferred work style, and salary expectations.

Ask them

What would success look like in the first 90 days?
What are the main problems this hire should help solve?
How does the team give feedback and measure good work?
What does a normal working week look like for this role?

Practice line

I am interested in the Developer - Oracle role because I can bring practical experience in MySQL, SQL and Developer, learn the team quickly, and contribute to the outcomes R+L Carriers needs from this hire.

Developer - Oracle

About the role

Walk in with sharper answers.

Likely questions

Prepare before the call

Ask them

Related jobs.