Software Engineer
Summary
Maintains and optimizes enterprise databases (DB2, Oracle, PostgreSQL) to ensure security, performance, and availability for internal systems.
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;