Oracle PL/SQL Developer

Ravh-IT; Irvine (CA); On-site; USD 110,000 - 150,000; Full time

Job summary

Ravh-IT in Irvine, CA is seeking an experienced Oracle PL/SQL Developer with hands-on expertise in Oracle SQL, PL/SQL, Forms 6i, Reports 6i, and Pro*C. The candidate should have strong analytical, troubleshooting, communication, and problem-solving skills, along with customer-facing experience.

You will develop, enhance, test, and support complex Oracle applications; analyze legacy systems; and design and optimize SQL/PLSQL scripts, procedures, functions, and triggers.

Qualifications

• 8+ years of hands-on Oracle database development, design, and testing.
• Strong SQL/PLSQL, complex queries for reporting and data analysis.
• Experience with forms/reports 6i and Pro*C.
• Excellent communication and documentation skills; customer-facing experience.

Responsibilities

• Develop, enhance, test, and support complex Oracle applications.
• Analyze legacy applications and document functionality.
• Develop complex SQL/PLSQL scripts, procedures, functions, and triggers.
• Troubleshoot application/database issues and provide rapid resolutions.
• Support users using SQL and PL/SQL techniques.
• Ensure data quality and integrity.
• Collaborate with customers, business users, and technical teams.
• Learn existing applications quickly and provide effective technical solutions.

Skills

Oracle SQL

PL/SQL

Forms 6i

Reports 6i

Pro*C

Job description

Job Summary

We are seeking an experienced Oracle PL/SQL Developer with strong hands-on experience in Oracle SQL, PL/SQL, Forms 6i, Reports 6i, and Pro*C. The candidate should have strong analytical, troubleshooting, communication, and problem-solving skills, along with customer-facing experience.

Must-Have Skills

• Oracle SQL, PL/SQL, Forms 6i, Reports 6i, Pro*C
• 8+ years of hands-on Oracle database development, design, development, and testing
• Strong database technologies and relational database concepts
• Complex SQL queries for reporting and data analysis
• Stored procedures, functions, scripts, packages, and triggers
• Application troubleshooting, production support, and root-cause analysis
• Data quality and database integrity
• Strong technical, analytical, decision-making, and problem-solving skills
• 4+ years of customer-facing experience
• Strong communication and technical documentation skills

Responsibilities

• Develop, enhance, test, and support complex Oracle applications.
• Analyze existing legacy applications and document functionality and business processes.
• Develop complex SQL/PLSQL scripts, procedures, functions, and triggers.
• Troubleshoot application/database issues and provide quick resolutions.
• Support users using SQL and PL/SQL techniques.
• Ensure data quality, consistency, and integrity.
• Work through requirements, design, development, testing, and production release.
• Collaborate with customers, business users, and technical teams.
• Quickly learn existing applications and provide effective technical solutions.

Preferred: Experience in Financial, Banking, Insurance domains.