Job Overview
We are seeking an experienced Oracle PL/SQL Developer. The ideal candidate will possess a deep technical proficiency in PL/SQL and an ability to develop complex database solutions to support our business objectives.
Responsibilities
- Design develop and maintain efficient and reliable PL/SQL code.
- Work closely with other team members to implement database systems based on project requirements.
- Optimise database systems for performance efficiency.
- Debug and troubleshoot complex database issues.
- Create and manage various database objects including cursors packages procedures views and more.
- Document technical specifications and process workflows when required.
Requirements
Proven expertise in Oracle PL/SQL development with a solid understanding and practical experience and will need to demonstrate knowledge examples as follows:
- Cursors and advanced data manipulation
- Development and optimisation of packages functions and stored procedures
- Implementation of loops unions and complex queries
- Exception handling mechanisms
- Creating and optimising views
- Utilising PL/SQL control structures such as decode and case statements
Desirable Skills:
- Knowledge and experience with Oracle Application Express (APEX) are advantageous but not mandatory.
- Experience with performance tuning and optimisation.
Benefits
Join our team for an exhilarating adventure with these amazing perks:
- 100% conversion of UNUSED leave credits
- HMO on Day 1
- Grab Voucher every month
- Birthday Gift
- Loyalty Gift
- Christmas Gift
- WorkLife Balance
- Active employee engagements physically such as Christmas Party & Team Building and virtual events such as townhall with prizes.
Specialization in React with 3+ years of experience, preferably with TypeScript, integrating with GraphQL APIs. Extensive experience in HTML and CSS, with proficiency in CSS frameworks highly regarded. Strong foundation in HTML and CSS for visually appealing and intuitive web page creation. Ability to translate design concepts into functional web applications for seamless user experiences. Proficiency in React for implementing interactive features and connecting with backend services via GraphQL API calls. Capability to write clean, maintainable, and efficient code with attention to UI/UX design detail. Experience with modern front-end development tools, version control, pre-processors, and testing frameworks. Collaboration with backend team and designers to optimize website architecture and design for speed and scalability.