Senior DBA (Contract Role)

UNISON CONSULTING PTE. LTD.; Singapore; On-site; SGD 50,000 - 70,000; Full time

Job summary

A leading company in Singapore is seeking a Database Administrator to monitor and manage various database platforms. The role involves ensuring high availability, security, and performance of production databases while collaborating with teams to resolve issues and implement improvements.

Qualifications

• Familiarity with multiple database systems including MariaDB, PostgreSQL, Oracle, and MSSQL.
• Strong communication skills and willingness to learn.

Responsibilities

• Monitor alerts for various database platforms and take appropriate actions.
• Conduct daily health checks of production databases.
• Oversee daily backup procedures and implement recovery solutions.

Skills

Database Monitoring

Incident Management

Process Improvement

Communication

Tools

MariaDB

PostgreSQL

Oracle

DB2

MSSQL

Redis

MongoDB

Linux

AIX

Windows

Job description

Job Responsibilities

1. Monitor alerts for various database platforms including MariaDB, PostgreSQL, EDB, Oracle, DB2, MSSQL, Redis, and MongoDB, and take appropriate actions.
2. Conduct daily health checks of production databases to ensure high availability, security, and performance.
3. Oversee daily backup procedures and implement recovery solutions as needed.
4. Manage database availability and performance, including incident and problem resolution.
5. Coordinate with the Major Incident Management (MIM) team to resolve critical issues.
6. Perform periodic patching and upgrades of production databases.
7. Collaborate with users and vendors to troubleshoot and resolve service-impacting issues promptly.
8. Identify opportunities for process improvements, automation, and efficiency in database operations, implementing best practices to enhance reliability and performance.
9. Maintain familiarity with multiple database systems, including MariaDB, PostgreSQL, EDB, Oracle, DB2, MSSQL, Redis, and MongoDB.
10. Gain exposure to MariaDB replication concepts, perform backups, restores, and point-in-time recoveries, and ensure database security and performance.
11. Acquire basic knowledge of backup and archive logging for Oracle/DB2 to ensure system resiliency.
12. Monitor and act on LRQ and LOCKWAITS in Oracle/DB2/MSSQL environments.
13. Monitor PostgreSQL/EDB LRQ, LRT, LRIIT metrics, and respond accordingly.
14. Perform basic monitoring of Redis databases, shards, and synchronization status.
15. Execute database patching and upgrades manually and via automation tools like Robosys.
16. Stay informed about banking industry regulations, standards, and best practices related to database management, security, and compliance.
17. Maintain basic knowledge of Linux (RedHat), AIX, and Windows operating systems and commands.
18. Be willing to work odd hours as required and demonstrate motivation and commitment.
19. Show a strong willingness to learn, excellent communication skills, and client management abilities.
20. Be a team player, self-motivated, and driven to improve performance and achieve results.