Programmer Analyst – PL/SQL Developer

Salary: ₱60,000 – ₱65,000 per month

Key Responsibilities

• Develop and maintain applications based on approved business and technical requirements.

• Analyze application change requests and provide technical inputs for impact assessments and business cases.

• Collaborate with Business Analysts in preparing requirements and technical design documents.

• Develop and modify Oracle PL/SQL programs, packages, and procedures.

• Analyze, modify, and enhance existing PL/SQL packages based on change requests.

• Provide technical support for Oracle E-Business Suite R12.

• Monitor and support client databases using SQL Developer and UNIX.

• Monitor Oracle batch processes, including morning and night batch processing.

• Support batch monitoring using UC4 AppworX and Oracle Data Integrator (ODI).

• Develop and maintain reports using SQL Server Reporting Services (SSRS).

• Develop and maintain web applications using PHP, MySQL, CSS, Bootstrap, and JavaScript.

• Create prototypes as required.

• Conduct unit testing and system testing to ensure applications perform according to specifications.

• Investigate and resolve issues encountered during SIT and UAT, coordinating with vendors when necessary.

• Provide production support, including troubleshooting, production fixes, and application enhancements.

• Prepare deployment manuals and perform deployments in the production environment.

• Create summaries and reports for leads and stakeholders.

• Communicate with clients regarding change requests and application support concerns.

• Provide technical support and respond to inquiries related to E-Business Suite systems.

• Provide knowledge transfer and serve as an SME for supported applications.

• Maintain technical documentation in accordance with company SDLC standards.

Required Qualifications

• Bachelor’s Degree in Information Technology or a related course – NON-NEGOTIABLE

• Minimum 3 years of experience in Oracle PL/SQL programming/development – NON-NEGOTIABLE

• Minimum 3 years of experience with PL/SQL and Oracle E-Business Suite R12 – NON-NEGOTIABLE

• Experience monitoring and supporting client databases using SQL Developer and UNIX – NON-NEGOTIABLE

• Experience monitoring Oracle Batch Processes, including morning and night batch processing, using UC4 AppworX and Oracle Data Integrator (ODI) – NON-NEGOTIABLE

• Experience facilitating/developing reports using SQL Server Reporting Services (SSRS) – NON-NEGOTIABLE

• Experience with SQL Developer, SQL*Plus, and MySQL – NON-NEGOTIABLE

• Experience in web development using PHP, MySQL, CSS, Bootstrap, and JavaScript – NON-NEGOTIABLE

• Experience working with the Software Development Life Cycle (SDLC) – NON-NEGOTIABLE

• Excellent communication skills – NON-NEGOTIABLE

Technical Skills

The following technical skills are NON-NEGOTIABLE:

• Oracle PL/SQL

• Oracle PL/SQL Developer

• Oracle E-Business Suite R12

• Oracle RMS

• Oracle SIM

• Oracle WMS

• Oracle RPM

• Oracle Forms and Reports

• BI Publisher

• UNIX / Linux

• Apache

• Oracle Database 12c

• SQL Developer

• SQL*Plus

• MySQL

• PHP

• CSS

• Bootstrap

• JavaScript

• SAP

• UC4 AppworX

• Oracle Data Integrator (ODI)

• SQL Server Reporting Services (SSRS)