Job Title: Infrastructure Engineer (Intermediate) (MAX 4056)
Work location: East
Duration: 12 months No.ofRole: 2
Monthly Basic Salary: $4000 - $7500
Candidates who are Singapore citizen or Singapore PR are welcome to apply
Job description
· Minimum 3-5 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 included nights, weekends and holidays shift.
· Alert monitoring for all database flavors (MariaDB, PostgreSQL, EDB, Oracle, DB2, MSSQL, Redis, and Mongo) and take appropriate action.
· Daily health monitoring of production database ensuring high availability, security, and performance.
· Perform daily backup monitoring and take action to have recovery solution in place.
· Managing the database availability and performance, including incident and problem management.
· Incident management to work with MIM(Major Incidenet Management) team to resolve/co-ordinate the 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
· 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, security of databases.
· Oracle/DB2 Basic knowledge on backup and archive logging to ensure resiliency.
· Oracle/DB2/MSSQL familiarity to monitor and taken 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.
· 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.
· 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.