Develops, test and implements complex ETL and database designs.
Implement complex business logic through Oracle database views.
Design and implementation of new database schemas for the the BI product portfolio.
Query Optimization and tuning of existing oracle database schemas as well as database views
Build CI/ CD pipelines and facilitate the automation of build creation, unit testing and deployment.
Participate in Proof of Concept (feasibility studies) of new functionality of the BI products.
Support large enterprise initiatives and help resolve architectural issues in the environment and database infrastructure.
Data Engineering background will be beneficial.
What will make you successful
Minimum 6+ years’ of experience with extensive knowledge of Oracle RDBMS
Database architect experience is required. or atleast worked on DB migration project.
Superior troubleshooting skills, battle-tested in high-volume production environments.
Hands on experience with performance tuning.
Hands-on experience working with Oracle 11g, 12c or 19c with some exposure to database administrative (pertaining to optimisation, performance tuning and granular access controls
Deep understanding of DevOps tools and Agile methods.
Experience in Jenkins, Git and Ansible.
Team player and good communication skills.
Good understanding of BI/ data warehousing concepts and ability to articulate to technical and non-technical audiences.
Benefits.
Hybrid working arrangement - 2 days in the office per week
15% EPF employer contribution for local candidates.
Health insurance coverage (including spouse and children)
Transport allowance
Integration activities
Opportunities for promotion (reviewed every year)
Professional developments
Optical coverage reimbursement
Additional 2 days of annual leave upon completion every 1 year in Billennium