PL/SQL Developer

Oracle PL/SQL Programmer Analyst

Qualifications

• Bachelor's degree in Information Technology, Computer Science, or a related field
• At least 3 years of hands-on experience in Oracle PL/SQL programming and development
• At least 3 years of experience working with Oracle E-Business Suite R12
• Hands-on experience with Oracle SQL Developer and SQL*Plus
• Experience supporting and monitoring Oracle databases in a Unix/Linux environment
• Experience monitoring Oracle batch processes, including morning and night batch processing
• Experience with batch/process monitoring tools such as UC4 AppworX
• Experience with Oracle Data Integrator (ODI) or similar data integration tools
• Experience generating or supporting reports using SQL Server Reporting Services (SSRS)
• Experience with MySQL
• Experience with web development technologies such as PHP, MySQL, CSS, Bootstrap, and JavaScript
• Understanding of the Software Development Life Cycle (SDLC)
• Strong analytical, troubleshooting, and problem-solving skills
• Good written and verbal communication skills
• Willingness to support applications in both development and production environments

Technical Skills

Experience with the following technologies and applications is an advantage:

• Oracle PL/SQL
• Oracle E-Business Suite R12
• Oracle RMS
• Oracle SIM
• Oracle WMS
• Oracle RPM
• Oracle Forms and Reports
• BI Publisher
• Unix/Linux
• Apache
• Oracle Database
• SAP
• UC4 AppworX
• Oracle Data Integrator (ODI)
• SQL Developer / SQL*Plus
• MySQL
• PHP
• JavaScript
• CSS / Bootstrap
• SSRS

Key Responsibilities

• Develop and maintain applications and programs based on approved business and technical requirements
• Assess application change requests and provide technical inputs for impact assessments and business cases
• Collaborate with Business Analysts and other stakeholders in defining technical solutions and development estimates
• Prepare technical design documents and program specifications
• Develop, modify, and maintain Oracle PL/SQL packages, procedures, and related database objects
• Develop prototypes or technical solutions as required
• Conduct unit and system testing to ensure programs perform according to approved specifications
• Investigate and resolve issues identified during System Integration Testing (SIT) and User Acceptance Testing (UAT)
• Provide production support, including application fixes, enhancements, and issue resolution
• Monitor and support Oracle database and batch processing activities
• Provide technical support for Oracle E-Business Suite R12
• Analyze and modify existing PL/SQL programs based on approved change requests
• Coordinate with vendors and technical teams to investigate and resolve application issues
• Prepare deployment documentation and conduct application deployments in production environments
• Create reports and summaries for technical leads and stakeholders
• Communicate with clients and business users regarding application changes, support concerns, and requirements
• Provide knowledge transfer and technical guidance to other team members as an SME
• Maintain technical documentation and ensure compliance with established SDLC standards
• Perform other related application development and production support activities as needed

Pay: Php60,000.00 per month

Benefits:

• Company Christmas gift
• Company events
• Health insurance
• Opportunities for promotion

Work Location: In person