Required Skills: Oracle SQL, PL/SQL, Forms 6i, Reports 6i, Pro*C
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 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.
- Day Break availability/requirement.
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.