PL/SQL Developer

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

Qualifications

Must have:

• Bachelor's Degree in IT or Related course.

• Minimum 3 years of experience in Oracle PL/SQL programming/development. (Non-negotiable)

• Must have experience in monitoring and supporting the client’s database using SQL Developer and UNIX. (Non-negotiable)

• Must have experience in monitoring Oracle Batch Processes (Morning and Night Batch Processing) using UC4 AppworX and Oracle Data Integrator Facilitates reports using SQL Server Reporting Services (SSRS) (Non-negotiable)

• Must have 3 years of experience in PL/SQL language and Oracle E-business Suite R12 (Non-negotiable)

• Must have experience in SQL Developer, SQL * Plus, and MySQL database (Non-negotiable)

• Must have experience in Web Development using PHP, MySQL, CSS, Bootstrap/Java Script (Non-negotiable)

• Must have experience in Software Development Life Cycle (Non-negotiable)

• Must have excellent communication skills. (Non-negotiable)

TECHNICAL SKILLS: (Non-negotiable)

• Oracle RMS

• Oracle SIM

• Oracle WMS

• Oracle RPM

• Bi-Publisher

• UNIX/LINUX

• Apache

• Oracle Forms and Reports

• SAP

• Oracle 12g

• Oracle PL/SQL

Job Description

• The Programmer Analyst is responsible for the development of simple to medium complexity application design, programs and related facilities according to approved business specifications, regulatory and company standards.

• Provides high level assessment for application system change requirements and technical inputs for user requirements during the preparation of impact document and business case documents

• Collaborates with the Business Analyst to provide design inputs and estimates in the preparation of requirements document.

• Documents system design and program specification in technical design document.

• Writes programs and codes based on approved technical design document.

• Develop prototypes as needed

• Conducts unit testing on written codes to ensure program perform per design at the unit level.

• Coordinates with vendor or conducts own investigation and resolution of errors reported during SIT and UAT.

• Maintain the systems once they are up and running in production, and perform production fixes or application enhancements as needed.

• Performs the above function in compliance with software development lifecycle standards of the company.

• Creating summaries or reports that can be used by the leads during presentations.

• Communicating with the client regarding changes request and sub-leading in supporting applications.

• Creating Deployment manuals and conduct actual deployment in Production Environment.

• Providing support and conduct Knowledge Transfer to other members as an SME of the system.

• Analyzing, Modifying and developing existing PL/SQL packages based on change requests.

• Handling and providing technical support and respond to inquiries about E-Business Suite System.

• Creating and executing Unit tests and System tests for the Programs developed.