Senior Associate, NoSQL Database Administrator, Group Infrastructure and Cloud, Technology & Operations

Business Function Group Technology and Operations (T&O) enables and empowers the bank with an efficient, nimble and resilient infrastructure through a strategic focus on productivity, quality & control, technology, people capability and innovation. In Group T&O, we manage the majority of the Bank's operational processes and inspire to delight our business partners through our multiple banking delivery channels. Responsibilities

• Install, setup, configure, patch, and upgrade database software (Redis and MongoDB) safely, with reversion included.
• Set up Active-Active, High Availability and Redundant systems to support critical production and use-cases.
• Setup DB2 Qreplication and HADR for high availability.
• Patch and upgrade without downtime for all db2 databases.
• To support critical databases like mobile banking, internet banking.
• Monitor the database with custom scripts to get in-depth details to improve database's performance (Memory, I/O Utilization, Long running session, Log Utilization, Lock wait etc..).
• Expertise in Backup and Restore of high-end database involving online/offline/incremental images.
• Performing failover testing & load testing involving application team.
• Monitor and ensure uptime and health of both development and production databases.
• Manage and monitor day-to-day replication and backup processes.
• Ensure system reliability, performance, and that best practices are being followed.
• Troubleshoot NoSQL issues and performance bottlenecks, working with vendor and application teams to achieve efficient and effective queries.
• Work with internal teams to plan and schedule application upgrades.
• Prepare Change Requests and related documents to support rolling out changes in Production environments.
• Design, implement, enhance monitoring for servers and database instances in lower environments and Production to provide comprehensive overview of health on-demand and historically.
• Design, implement, maintain and automate the appropriate backup and recovery architecture as required.

• Minimum 6 years of experience in NoSQL Database Administration.
• Position requires the ability to work various work schedules that support a 24x7 coverage included nights, weekends and holidays shift.
• Good foundational understanding in caching, cluster-based setups, backup and restore cycles, delayed replication, NoSQL principles.
• Basic appreciation of networking, application design, virtual server environment, security and access control.
• Hands on experience in troubleshooting on issues, raising ticket and coordinating with vendor, communicating and closing cases with internal users.
• Good communication (verbal and written) and documentation skills, with ability to coordinate clearly with different parties as above.
• Hands on experience in troubleshooting on patching issue and raise case with vendor, follow up for fixing.
• Hands on experience in Linux operating system (RedHat).
• Team Player who is self-motivated and has the drive to improve performance and achieve results.