Programmer Analyst – PL/SQL Developer

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)