Responsibilities
Alert monitoring for all database flavors (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.
Coordinate with the Major Incident Management (MIM) team to resolve high‐critical issues.
Carry out periodic production patch and upgrade management.
Work with users and vendors to take timely and appropriate steps to resolve and troubleshoot issues impacting 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.
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 and perform point-in-time recovery.
MariaDB ensure performance and 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 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 and via Robosys.
Stay up-to-date with banking industry regulations, standards, and best practices related to database management, security, and compliance.
Requirements
Minimum 6-10 years of experience and familiarity with at least 2 databases among MySQL/MariaDB, PostgreSQL/EDB, Oracle, MSSQL, DB2, MongoDB and Redis.
Ability to support a 24x7 coverage including nights, weekends and holidays.
Basic knowledge of Linux (Red Hat), AIX, Windows and basic commands.
Committed and motivated individual willing to work odd hours 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.
#J-18808-Ljbffr