Mid- Lead PL/SQL Developer

At Umpisa Inc., our mission is to make the Philippines be known globally as a tech hub.

Umpisa Inc. is a progressive technology services company that partners with select industries, clients and people to work on pioneering and industry-changing solutions via digital transformation, modern software development and venture building.

We create a set of world-class and impactful products and solutions to help organizations and individuals live better lives. We offer demanding, challenging and rewarding careers in software development, product development, emerging technologies, and more for the right candidates.

Essential Skills

• Aligns with our values: Excellence, Integrity, Professionalism, People Success, Customer Success, Fun, Innovation and Diversity
• Strong communication skills
• Strong problem solving and analytical skills
• Excellent problem-solving ability
• Would like to work as part of a self-organizing Scrum team in a scaled agile framework
• Must be a self-starter and loves to collaborate with the team and client

Job Summary

Responsible for the support and maintenance to existing application functionalities.

Specific Duties & Responsibilities

• Provide second-level support for assigned production-related application incidents within established service level requirements and application maintenance in coordination with the vendor where applicable.
• Minimize the occurrence of application incidents by investigating, analyzing, developing and implementing corrective measures as directed.
• Provide support for operational requests received within agreed TAT.
• Provide technical inputs to address maintenance requirements.
• Provide technical inputs for requirements of assigned key initiatives for application stability or customer experience or improve business unit’s operational efficiency.
• Prepare technical design documents where applicable.
• Code programs based on requirements in accordance with company programming standards.
• Perform unit testing, document test results and prepare unit test signoff form; or review other programmers or vendor’s test results where applicable or assigned.
• Provide technical support and/or resolution/fixes to reported errors during systems testing/systems integration testing and user acceptance testing where needed.
• Prepare application for implementation in test and production environments with the necessary documents according to the change control standard.
• Provide technical input if there is proposed service catalogue item for handled application, deliver automation or provide procedures and monitor implementation of the service catalogue.
• Work with other IT Delivery units personnel to plan and execute service transition activities of applications.
• Maintain the application section of the Technical Recovery Procedure of the supported application.
• Train, as necessary, other Programmer Analysts on application functionality and features, Department and Division function, guidelines and processes to be followed; provide technical guidance to other programmers where needed.
• Perform other related functions that may be assigned from time to time.

Required Skills:

• RDBMS
• Oracle SQL
• Oracle PL/SQL

Good-to-have Skills:

• Oracle APEX and ORDS
• Oracle Scheduler
• MongoDB
• PostreSQL
• MS SQL

Knowledge on the following applications:

• Gitlab
• Jira
• Sonarqube/sonarlint
• Control-M
• Bash/shell scripting
• SQL developer (Oracle IDE)