Oracle PL/SQL Developer

Ravh-IT; Irving (TX); On-site; USD 120,000 - 160,000; Full time

Job summary

Ravh-IT is seeking an experienced Oracle PL/SQL Developer to join our team in a hands-on role. The candidate will design, develop, test, and maintain Oracle-based applications, including complex SQL/PLSQL scripts and Pro*C integrations.

Responsibilities include analyzing legacy systems, producing detailed technical documentation, and providing rapid troubleshooting and support to users in a customer-facing environment. Strong communication is essential.

Qualifications

• 10+ years of hands-on experience with Oracle SQL, PL/SQL, Forms 6i, Reports 6i, and Pro*C.
• Experience in database application 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.
• Understanding of relational database concepts and data quality/integrity.
• Experience analyzing complex legacy applications and documenting their functionality.
• Strong troubleshooting, debugging, root-cause analysis, and issue-resolution skills.
• Excellent written and verbal communication skills.
• 4+ years of experience 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

Pro*C

Stored procedures

Functions

Packages

Triggers

Scripts

Root-cause analysis

Analytical skills

Customer-facing

Communication

Job description

Must have: Oracle SQL, PL/SQL, Forms 6i, Reports 6i, and Pro*C.

Job Summary:

We are seeking an experienced Oracle PL/SQL Developer with strong hands-on expertise in Oracle SQL, PL/SQL, Forms 6i, Reports 6i, and Pro*C. 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 Pro*C.
• 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.