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.