Database Infrastructure Engineer (Contract/3x HC)

Minimum Requirements:

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

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 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.
• 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.

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 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: Get familiarized with LRQ, LRT, 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 Linux operating system (RedHat)/AIX/Windows and basic commands.