Infrastructure Engineer

TEAMLEASE DIGITAL CONSULTING PTE. LTD.; Singapore; On-site; SGD 60,000 - 90,000; Full time

Job summary

A leading company in Singapore is seeking a seasoned database management professional with at least 5 years of experience. The role involves monitoring, maintaining database health, and ensuring high availability of multiple database environments. Candidates should be adept in handling incidents and optimizing database performance per industry regulations and best practices. Join a dedicated team to enhance system reliability and contribute to process improvements in a dynamic environment.

Qualifications

• Minimum 5 years of experience managing databases.
• Familiarity with databases like MySQL, PostgreSQL, Oracle, etc.
• Basic knowledge of Linux and operating systems.

Responsibilities

• Monitor alerts for all database flavours and take action.
• Perform daily health checks of production databases.
• Manage database performance and incident responses.

Skills

Database Management

Alert Monitoring

Incident Management

Performance Monitoring

Process Improvements

Tools

MariaDB

PostgreSQL

Oracle

DB2

MSSQL

MongoDB

Redis

Job description

Minimum Requirements:

• Minimum 5 years of experience and required familiarity with at least 2 databases among MySQL/MariaDB, PostgreSQL/EDB, Oracle, MSSQL, DB2, MongoDB, and Redis.
• The position requires the ability to work various schedules that support 24/7 coverage, including nights, weekends, and holiday shifts.

Responsibilities:

• Alert monitoring for all database flavours (MariaDB, PostgreSQL, EDB, Oracle, DB2, MSSQL, Redis, and Mongo) and take appropriate action.
• Daily health monitoring of production databases, ensuring high availability, security, and performance.
• Perform daily backup monitoring and take action to have a recovery solution in place.
• Manage database availability and performance, including incident and problem management.
• Incident management in coordination with the MIM (Major Incident Management) team to resolve or coordinate high-critical issues.
• Carry out periodical production patch and upgrade management.
• Collaborate with users and vendors to take timely and appropriate steps to resolve and troubleshoot issues that impact service levels.
• Identify opportunities for process improvements, automation, and efficiency gains in database operations.
• Implement best practices and innovative solutions to enhance system reliability and performance.
  

Database Expertise Required:

• Required familiarity with multiple databases among MariaDB, PostgreSQL, EDB, Oracle, DB2, MSSQL, Redis, and Mongo.
• MariaDB exposure to replication concepts to resync.
• MariaDB backup and restore & perform point-in-time recovery.
• MariaDB: Ensure the performance and security of databases.
• Oracle/DB2: Basic knowledge of backup and archive logging to ensure resiliency.
• Oracle/DB2/MSSQL: Familiarity with monitoring and taking action for LRQ and LOCKWAITS.
• PostgreSQL/EDB: Get familiarised with LRQ, LRT, and LRIIT monitoring and take action accordingly.
• Redis: Basic monitoring of database, shards, and sync status.

Operations and Tools:

• Perform database patching/upgrades both manually and via Robosys.
• Stay up-to-date with banking industry regulations, standards, and best practices related to database management, security, and compliance.
• Basic knowledge of the Linux operating system (RedHat)/AIX/Windows and basic commands.