PL/SQL Developer (Oracle) |
Summary
Develops, maintains, and optimizes Oracle PL/SQL database programs — procedures, functions, packages, and triggers — for enterprise-level systems, while preparing test data, troubleshooting database issues, and writing technical documentation. Core stack: Oracle SQL, PL/SQL, and JasperReports/Crystal Reports.
About the Role
We are looking for a skilled PL/SQL Developer to join our growing team. The ideal candidate will have strong experience in Oracle SQL and PL/SQL development, with the ability to develop, maintain, and optimize database applications and reports. This role offers an excellent opportunity to work on enterprise-level systems and collaborate with cross-functional teams in delivering high-quality solutions.
Key Responsibilities
Develop, modify, and maintain PL/SQL programs based on business and technical requirements.
Create and revise database procedures, functions, packages, and triggers.
Prepare test data, define expected results, and perform unit testing of developed programs.
Assist in designing database structures, input/output file layouts, report formats, and screen layouts.
Prepare and maintain technical documentation related to development activities.
Support system testing activities and validate test results.
Identify and resolve database-related issues and performance bottlenecks.
Collaborate with business users, analysts, and other developers to deliver system enhancements.
Perform other duties and responsibilities as assigned.
Qualifications
Bachelor's Degree in Computer Science, Information Technology, or a related field.
3-5 years of hands-on experience in PL/SQL Development.
Strong knowledge of Oracle Database and RDBMS concepts.
Proficiency in Oracle SQL, PL/SQL, stored procedures, functions, packages, and triggers.
Familiarity with JasperReports and/or Crystal Reports.
Strong analytical, troubleshooting, and problem-solving skills.
Excellent communication and teamwork abilities.
Preferred Qualifications
Experience in Database Administration (DBA).
Knowledge of database performance tuning and query optimization.
Exposure to enterprise application environments.
Experience supporting system integration and testing activities.
Required Skills
Oracle SQL
PL/SQL Development
RDBMS Concepts
Stored Procedures & Functions
JasperReports / Crystal Reports
Database Troubleshooting
Unit Testing
Technical Documentation
Skills
Sign in to read and join the discussion.