PL/SQL Developer (Oracle) |

Uptc; Metro Manila; On-site; PHP 600,000 - 1,000,000; Full time

Job summary

Uptc is seeking a skilled PL/SQL Developer to join our team in the Philippines. You will develop, optimize, and maintain Oracle SQL/PL/SQL programs and work on enterprise-level database applications and reports.

The role requires 3–5 years of hands-on experience with PL/SQL development, strong SQL skills, and familiarity with JasperReports or Crystal Reports. Collaboration with cross-functional teams and thorough documentation are essential.

Qualifications

• Bachelor's degree in CS/IT or related field.
• 3–5 years hands-on PL/SQL development experience.
• 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 and problem-solving skills.
• Excellent communication and teamwork abilities.

Responsibilities

• Develop, modify, and maintain PL/SQL programs based on requirements.
• Create and revise database procedures, functions, packages, and triggers.
• Prepare test data, define expected results, and perform unit testing.
• 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.

Skills

Oracle SQL

PL/SQL Development

RDBMS Concepts

Stored Procedures & Functions

Database Troubleshooting

Unit Testing

Technical Documentation

Education

Bachelor's Degree in Computer Science/Information Technology or related field

Tools

JasperReports / Crystal Reports

Job description

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