Oracle PL/SQL Developer

Artificial Intelligence Technologies LLC; Irvine (CA); On-site; USD 120,000 - 180,000; Full time

Job summary

Artifintech in Irvine, CA seeks an experienced Oracle PL/SQL Developer to design, enhance, test and support complex Oracle applications. You will craft SQL/PL/SQL scripts, procedures and triggers, troubleshoot issues and collaborate with users to ensure data integrity.

The role requires strong analytical and communication skills, plus 4+ years in customer-facing environments. Applicants must be eligible to work in the United States.

Qualifications

• 10+ years of hands-on Oracle SQL, PL/SQL, Forms 6i, Reports 6i and ProC.
• Experience designing, building, testing and supporting Oracle applications.
• Ability to write complex SQL queries for reporting and data analysis.
• Experience developing stored procedures, functions, packages, scripts and triggers.
• Strong understanding of relational database concepts, data quality and integrity.
• Experience analyzing legacy applications and documenting their functionality.
• Strong troubleshooting, debugging and root-cause analysis skills.
• Excellent written and verbal communication skills.
• 4+ years in a customer-facing environment.

Responsibilities

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

Skills

Oracle SQL

PL/SQL

Legacy app analysis

SQL scripting

Troubleshooting

Documentation

Communication

Customer-facing

Education

Bachelor's degree in CS or related

Tools

Forms 6i

Reports 6i

ProC

Job description

US Citizen, Green Card, H-1B, OPT-EAD, CPT, Other

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.

We are an equal opportunity employer. All aspects of employment including the decision to hire, promote, discipline, or discharge, will be based on merit, competence, performance, and business needs. We do not discriminate on the basis of race, color, religion, marital status, age, national origin, ancestry, physical or mental disability, medical condition, pregnancy, genetic information, gender, sexual orientation, gender identity or expression, national origin, citizenship/ immigration status, veteran status, or any other status protected under federal, state, or local law.