[AIT] Infrastructure Engineer (Intermediate) (MAX 4056)

Contact email: careersrise@bcg.com
Job ref: MAX 4056
Published: 3 months ago
Startdate: 23 September 2024 - 23 September 2024

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.