Oracle PL/SQL Developer

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

Job summary

Cloud Analytics Technologies, LLC is seeking an experienced Oracle PL/SQL Developer to design, implement, and support Oracle-based applications in a fast-paced environment. You will craft complex SQL/PLSQL scripts, troubleshoot database issues, and contribute to documentation and data quality efforts.

The role emphasizes customer-facing collaboration, strong analytical skills, and clear communication to resolve production issues and deliver reliable software solutions.

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

Database design

Testing

Production support

Troubleshooting

Documentation

Customer-facing

Communication

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.

Some of our Business Ventures - Knowledge Analytics

Do restrictive necessities, your capability for advanced analytics or your business model need custom-made applications and infrastructure configurations? opt for our hosted managed services to urge comprehensive analytics solutions supported industry-leading Cloud Analytics Technologies, LLC code - delivered by the Cloud Analytics Technologies, LLC consultants UN agency understand these solutions best. Through a mix of with-it technology and dedicated service and support, Cloud Analytics Technologies, LLC hosted managed services will facilitate you: