Senior Database Management Engineer

Job description:

The Technology Division at BCS is responsible for the operations, maintenance, and support of BCS applications such as FAST, Giro, CTS, PayNow, SGQR, TFR, eGIRO and its critical infrastructure, ensuring its operational stability, regulatory compliance, and service reliability.

The IT Infrastructure Department under Technology ensures the resilience, security, and high-performance of BCS' technology infrastructure across various functions of service monitoring, incident management, and technical support. The team ensures seamless operation, maintenance, and strategic growth of core infrastructure components, including networks, servers, storage, middleware, and databases.

The Senior Database Management Engineer is responsible for the maintenance of the databases and ensuring 24/7 database availability in the production environments relating to online payment services in in BCS.

Key Responsibilities

• Establish database performance baseline and executing workload tests such as replication, backup & recovery, log shipping, scalability, and partitioning.
• Responsible for database sizing, capacity planning, performance tuning and database account management.
• Review release notes and upgrade or patch database software based on maintenance schedules.
• Work closely with stakeholders to support the application development lifecycle by building an effective database environment and maintaining the proper database structure requirements.
• Create primary database storage structures (filesystems, tablespaces); and assist in primary objects (tables, views, indexes) creation after application developers have designed an application.
• Define user access and enable data distribution to the right end user in an appropriate format and in a timely manner.
• Maintain and monitor systems to ensure optimal performance that meet established Service Level Agreements.
• Develop and maintain the database standards and operating procedures that aligned to NETS Cyber Security and IT policies, procedures, and service management frameworks.
• Consult, analyse, assess and implement action plans to mitigate risks in relation to data management.
• Provide recommendations to management and related stakeholders on the technology roadmap and database integration with enterprise and/or cloud platforms.
• To be on 24/7 standby rotational basis to respond to incidents and monitoring alerts.
• Oversee the introduction and integration of innovative database solutions, including automation to enhance efficiency and scalability.

Requirements

Education and Experience

• Bachelor's degree in Information Technology, Information Systems, Computer Science, or a related field.
• Minimum of 6 years of experience in database administration and operation management in Oracle (Primary), MariaDB, Microsoft SQL Server.
• Experience in Enterprise Database administration, architecture, design and solutioning.
• Experience with high-availability database technology like clustering (RAC cluster) and replication (Data-guard & Gloden-Gate).

Skills and Knowledge

• Strong knowledge in database design, development, and administration in high volume, large scale and data intensive environment with relational & distributed databases.
• Good working knowledge on automation and orchestration with proven record of accomplishment. Skilled in tools such as Puppet, Ansible & Kubernetes.
• Strong knowledge of system administration in Red Hat Linux (RHEL) & Windows Server will be an added advantage.
• Strong analytical and project management skills, with the ability to juggle multiple projects with various timelines in a fast paced and dynamic environment.
• Familiar with ITIL processes such as Change, Incident Management.
• Proficient in database monitoring tools (Oracle Enterprise Manager, MySQL Enterprise Monitor, MONyog).
• Excellent ability to communicate technical and strategic information effectively across all organisational levels, fostering collaboration and alignment