Job description:
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).
