IT INFRASTRUCTURE ENGINEER - Singapore - WSH EXPERTS PTE. LTD.

Description

Responsibilities

• Responsible for providing operational database services
• Responsible in designing, implementing, documenting, administering and monitoring the databases to ensure the databases run efficiently and securely
• Responsible for database patching;
• Owning, tracking and resolving database related incidents and requests, fulfilling requests and resolving incidents within SLAs
• Reviewing service-related reports (e.g: database backups, maintenance, monitoring) on a daily basis to ensure service-related issues are identified and resolved within established SLAs
• Responding to database related alerts and escalations and working with vendors and other parties to come up with strategic solutions to recurring problems
• Establishing and maintaining communication with development team

Requirements

• Recognised Degree with a technical major such as engineering, data communications or computer science, among others
• Minimum 5 years Database Administration experience
• Experience with Relational Database Administration for DB2 / Oracle Server / PostgreSQL
• Experience with Administration of Cloud Native / Software as a Services (SaaS) Data warehouses product such as Snowflake, AWS Redshift will be an advantage
• Knowledge and/or working experience in SQL Database servers and MySQL will be an advantage
• Experience in 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 /writing and implementing Stored Procedures, PL/SQL and SQL
• Experience working with Windows and UNIX servers
• Experience in cloud database computing will be an advantage