Lead Developer - PL/SQL (Oracle)

Qualifications
Must have:
- Bachelor's degree in Computer Science, Information Technology, or a related field.
- Must have minimum of 5 years of experience as a Programmer Analyst with a focus on PL/SQL development. (Non-negotiable)
- Must have minimum 1 year of experience leading a team. (Non-negotiable)
- Must have minimum 5 years of hands-on experience in Oracle APEX, ORDS, Oracle Scheduler. (Non-negotiable)
- Must have in-depth knowledge of RDBMS concepts and strong expertise in Oracle technologies. (Non-negotiable)
- Must have experience with Data migration using ETL via Oracle. (Non-negotiable)
- Must have experience with Oracle Business Intelligence Publisher. (Non-negotiable)
- Must have experience with Oracle E-Business Suite. (Non-negotiable)
- Must have experience with MongoDB, PostgreSQL, and MS SQL. (Non-negotiable)
- Must have experience with Bash/shell scripting. (Non-negotiable)
- Strong problem-solving skills and the ability to work independently or within a team. (Non-negotiable)
- Must be knowledgeable in: Gitlab, Jira, Sonarqube/sonarlint, Control-M, SQL developer (Oracle IDE)

Job Description
- 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.