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.
