PL/SQL Developer

About the role

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.

Qualifications

• Bachelor's Degree in IT or Related course
• Minimum 3 years of experience in Oracle PL/SQL programming/development
• Experience in monitoring and supporting the client's database using SQL Developer and UNIX
• Experience in monitoring Oracle Batch Processes (Morning and Night Batch Processing) using UC4 AppworX and Oracle Data Integrator
• Experience facilitating reports using SQL Server Reporting Services (SSRS)
• 3 years of experience in PL/SQL language and Oracle E-business Suite R12
• Experience in SQL Developer, SQL * Plus, and MySQL database
• Experience in Web Development using PHP, MySQL, CSS, Bootstrap/Java Script
• Experience in Software Development Life Cycle
• Excellent communication skills

Key responsibilities

• 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