Database Administrator

Position Summary

You will work with a team of Database Administrators whose mission is to maintain 24/7 database availability in production environments relating to online payment services in NETS.You will be responsible for day-to-day administration tasks, which includes installation, configuration, upgrades, patching, backup & recovery, tuning, scripting, query optimizations and routine maintenance of the databases under your care.

Key Responsibilities

• Establish database performance baseline and executing workload tests such as replication, backup & recovery, log shipping, scalability, partitioning etc.
• 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.
• Automate DBA operational and maintenance tasks
• Work closely with stakeholders in supporting the application development lifecycle by building an effective, usable database environment while also maintaining the proper database structure requirements.
• Create primary database storage structures (tablespaces), primary objects (tables, views, indexes) 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 are aligned to NETS Cyber Security and IT policies, procedures, and service management frameworks.
• Consult, analyze, 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.
• Requires to be on 24 x 7 standby rotational basis.

Requirements

• Degree in Computer Science or related technology disciplines with at least 5 years of experience in database administration and operation management in Oracle, MySQL, & Microsoft SQL Server.
• Experience in Enterprise MySQL Database administration, architecture & design.
• Strong knowledge in database design, development, and administration in high volume, large scale and data intensive environment with relational & distributed databases.
• Experience with highly-available database technology like clustering and replication.
• Proficient in Ansible and Bash scripting to automate DBA operations and maintenance tasks.
• Knowledge in system administration in Red Hat Linux (RHEL), Windows Server (2012 and above) 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 (Zabbix, Oracle Enterprise Manager).