Oracle PL/SQL Developer

Megan Soft Inc; Irvine (CA); On-site; USD 120,000 - 180,000; Full time

Job summary

Megan Soft Inc in Irvine, CA seeks an experienced Oracle PL/SQL Developer to design, enhance, test, and support complex Oracle applications. The role requires hands-on expertise in Oracle SQL, PL/SQL, Forms 6i, Reports 6i, and ProC, and strong analytical, documentation, and communication skills.

You will analyze legacy systems, write intricate SQL queries, develop stored procedures and triggers, troubleshoot issues, and provide timely resolutions for production users in a customer-facing

Qualifications

• 10+ years hands-on experience with Oracle SQL, PL/SQL, Forms 6i, Reports 6i and ProC.
• Strong background in database design, development, testing and production support.
• Ability to write complex SQL queries for reporting and data analysis.
• Experience developing stored procedures, functions, packages, scripts and triggers.
• Solid understanding of relational databases, data quality and integrity.

Responsibilities

• Design, develop, test, enhance and maintain Oracle-based applications.
• Analyze existing applications and create detailed technical/functional documentation.
• Develop and maintain complex SQL/PLSQL scripts, procedures, functions and triggers.
• Troubleshoot application and database issues and provide timely resolutions.
• Support application users using SQL and PL/SQL techniques.
• Ensure data quality, consistency and database integrity.

Skills

Oracle SQL

PL/SQL

Forms 6i

Reports 6i

ProC

Data analysis

SQL scripting

Troubleshooting

Documentation

Customer-facing experience

Tools

Forms 6i

Reports 6i

ProC

Job description

Required Skills: Oracle SQL, PL/SQL, Forms 6i, Reports 6i,

Job Description

We are seeking an experienced Oracle PL/SQL Developer with strong hands‑on expertise in Oracle SQL, PL/SQL, Forms 6i, Reports 6i, and ProC. The candidate will be responsible for developing, enhancing, testing, troubleshooting, and supporting complex Oracle applications. Strong analytical, communication, documentation, and problem‑solving skills are required.

Must-Have Skills:

• 10+ years of hands‑on experience with Oracle SQL, PL/SQL, Forms 6i, Reports 6i, and ProC.
• Strong experience in database application design, development, testing, and production support.
• Ability to write complex SQL queries for reporting and data analysis.
• Strong experience developing stored procedures, functions, packages, scripts, and triggers.
• Good understanding of database technologies, data quality, integrity, and relational database concepts.
• Experience analyzing complex legacy applications and documenting their functionality.
• Strong troubleshooting, debugging, root‑cause analysis, and issue‑resolution skills.
• Strong technical, analytical, decision‑making, and problem‑solving abilities.
• Excellent written and verbal communication skills.
• 4+ years of experience working in a customer‑facing environment.

Key Responsibilities:

• Design, develop, test, enhance, and maintain Oracle‑based applications.
• Analyze existing applications and create detailed technical/functional documentation.
• Develop and maintain complex SQL/PLSQL scripts, procedures, functions, and triggers.
• Troubleshoot application and database issues and provide timely resolutions.
• Support application users using SQL and PL/SQL techniques.
• Ensure data quality, consistency, and database integrity.