Software Engineer

Responsibilities: Responsible in designing, implementing, documenting, administering and monitoring the databases to ensure the databases run efficiently and securely

To track and resolve database related incidents and requests within Service Level Agreements (SLAs)

Review service-related reports (e.g.: database backups, maintenance, monitoring) on a daily basis

Respond to database related alerts and working with vendors and other parties to resolve the problems

Manage and resolve issues in alignment with the SLAs

Establishing and maintaining communication with development team to keep them updated with status of their requests, initiating and performing changes on Non-Production systems and

Pro-actively escalating any issues that cannot be resolved within the established timeframes.

Qualifications & Requirements: Recognised degree in Computer Science, IT or Engineering

Minimum 5 years Database Administration experience

Experience with Database Administration for DB2 (version 10 onwards) / Oracle Server (version 11 onwards) / PostgreSQL (version 14 onwards)

Knowledge and/or working experience in SQL Database servers and MySQL will be an advantage

Experience in data modelling which include performing, managing and validating Data Model creation (ERWIN and/or equivalent)

Experience in troubleshooting and resolving database problems

Experience in Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools. (knowledge of indexes, index management, and statistics)

Experience with backups, restores and recovery models

Knowledge of High Availability (HA) and Disaster Recovery (DR) options for DB2 / Oracle Server / PostgreSQL

Experience in implementing operational automation using scripts / shell scripting

Experience in writing and implementing Stored Procedures, PL/SQL and SQL

Experience in database design, development and performance tuning

Experience in cloud database computing

Experience working with Windows, AIX, Linux and Solaris servers

Experience in Automatic Fare Collection (AFC) system will be an advantage

Experience in EMV and Payment Card Industry Data Security Standard (PCI DSS) will be an advantage