Software Developer - PL/SQL (Client-site with relocation package)

Umpisa Inc.; Manila, Hinoba-an; On-site; PHP 1,000,000 - 1,500,000; Full time

Job summary

Umpisa Inc. in Manila, Philippines, is seeking an experienced software professional to support and maintain existing applications. The role requires deep knowledge of Oracle SQL/PL/SQL, strong communication, and the ability to lead a small team within a scaled agile environment.

You will provide second-level support, analyze incidents, implement fixes, and prepare technical designs and unit tests. Collaboration with vendors and cross-functional teams is essential for ensuring stability and

Qualifications

• More than 5 years of relevant experience with leadership responsibilities.
• Provide second-level support for production-related application incidents within SLA and coordinate with vendors when applicable.
• Minimize incidents by investigating, analyzing, and implementing corrective measures as directed.
• Provide leadership support for operational requests and technical inputs for maintenance initiatives.
• Prepare technical design documents and code programs according to company standards.
• Perform unit testing and document results, and review tests from others when needed.
• Prepare applications for test and production environments per change control standards.
• Train other programmers on functionality and features and provide technical guidance.

Responsibilities

• Support and maintain existing application functionalities.
• Provide second-level incident support and coordinate with vendors.
• Investigate and implement corrective measures to reduce incidents.
• Lead operational requests and provide technical inputs for maintenance.
• Prepare design documents and code per standards; perform unit testing.
• Assist in test/production prep and change control procedures.
• Mentor other programmers and share technical guidance.
• Collaborate with IT Delivery teams to transition services.

Skills

Communication skills

Problem solving

Analytical skills

Self-starter

Team collaboration

Scrum/Agile

Tools

Oracle SQL

Oracle PL/SQL

Oracle APEX

ORDS

MongoDB

PostgreSQL

MS SQL

Gitlab

Jira

SonarQube

Sonarlint

Control-M

Bash/shell scripting

SQL Developer

Job description

AtUmpisa 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

• More than 5 years of relevant experience, keen to take on people management 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 leadership 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.

Requirements

• 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)