PL/SQL Developer

WeSupport Incorporated; Taguig; On-site; PHP 480,000 - 720,000; Full time

Job summary

WeSupport Incorporated is seeking a Programmer Analyst to develop simple to medium complexity applications following approved specifications and company standards. The role involves high-level assessment for system changes and providing technical inputs during impact analysis and business cases.

You will collaborate with Business Analysts, document designs, write code, and conduct unit testing. The candidate should have strong PL/SQL experience, SSRS, and web development skills, with excellent

Qualifications

• Bachelor's Degree in IT or related field is required.
• 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.

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.

Skills

Excellent communication

Education

Bachelor's Degree in IT or Related course

Tools

Oracle PL/SQL

SQL Developer

UNIX

UC4 AppworX

Oracle Data Integrator

SSRS

PL/SQL

Oracle E-Business Suite R12

SQL*Plus

MySQL

PHP

CSS

Bootstrap/JavaScript

Software Development Life Cycle

Job description

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