Senior Associate, Database Operation 24/7 support, Group Infrastructure and Cloud, Technology & Operations
DBS Bank
- Singapore
- Permanent
- Full-time
- Perform production support administration tasks including proactive monitoring, maintenance and on-call support to ensure availability and performance requirements are met.
- Alert monitoring for all database flavours and take appropriate action.
- Daily health monitoring of production database system and data integrity checks.
- Perform daily backup monitoring and take action to have recovery solution in place.
- Managing the database availability and performance, including incident and problem management.
- Carry out periodical production patch and upgrade management.
- Work with users and vendors to take timely and appropriate steps to resolve and troubleshoot issues impacting service levels.
- MariaDB exposure to replication concepts to resync.
- MariaDB backup and restore & perform point-in-time recovery.
- MariaDB Ensure performance, security of databases.
- Oracle/DB2 Basic knowledge on backup and archive logging to ensure resiliency.
- Oracle/DB2/MSSQL familiarity to monitor and take action for LRQ and LOCKWAITS.
- PostgreSQL/EDB get familiarize with LRQ, LRT, LRIIT monitoring and take action accordingly.
- Redis basic monitoring of database, shards and sync status.
- Perform database patching/upgrade both manually & via Robosys.
- Minimum 6 years of experience and required familiarity with at least 2 databases among Mysql/MariaDB, PostgreSQL/EDB, Oracle, MSSQL and Redis.
- Participate in the 24/7 rotational shift including Night and weekends shifts.
- Team Player who is self-motivated and has the drive to improve performance and achieve results.
- Basic knowledge of Linux operating system (RedHat)/AIX/Windows and basic commands.
- Incident management to work with MIM(Major Incident Management) team to resolve/co-ordinate the high critical issues.
- Stay up-to-date with banking industry regulations, standards, and best practices related to database management, security, and compliance
- Committed and motivated individual and willing to work odd hours at times when required.
- Highly coachable and willingness to learn.
- Excellent communication and Client management.
- Team Player who is self-motivated and has the drive to improve performance and achieve results.