Senior Oracle PL/SQL Developer for Legacy Systems & Data

Valiant Technologies LLC; Irvine (CA); On-site; USD 120,000 - 160,000; Full time

Job summary

Valiant Technologies LLC in Irvine, CA is seeking 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, plus strong analytical and communication skills. You will contribute across the development lifecycle in a customer-facing environment.

Experience with legacy systems and data integrity is a plus.

Qualifications

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

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

Tools

ProC

Job description

Valiant Technologies LLC in Irvine, CA is seeking 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, plus strong analytical and communication skills. You will contribute across the development lifecycle in a customer-facing environment.

Experience with legacy systems and data integrity is a plus.