Key Responsibilities
- Design the database's architecture and modelling strategies to ensure that the database is secure, scalable and performs reliably.
- Work with the application development team to define the application data model and work on tuning and optimizing database related operation.
- Be point of contact to principal vendors for software and hardware.
- Provide production support and responsible for the resolution of database related issues and duty rotation for afteroffice-hours support.
- Provide support on to application team on database related matters (e.g. data patching, application deployments, extracting data from database for reporting)
- Plan and strategize data mapping for migration of data from legacy systems to support the deployment of the project, ensuring no data loss during conversion.
- Review data mapping/conversion/integration specs between systems to ensure appropriate mapping quality and adherence to modelling strategies.
- Ensure timeliness and accuracy of data sync during co-existence with legacy systems.
- Develop and maintain database-related codes / scripts such as data sync scripts, data masking scripts, stored procedures etc.
- Ensure database services and servers availability.
- Install and configure Database and associated products
Provide operational support including:
- Ensuring database patches are performed in accordance with the patch release cycle.
- Troubleshoot and remediate security vulnerabilities reported by security scan.
- Reviewing and maintaining of database accounts.
- Monitoring and optimising database performance, such as optimising queries, creating indexes etc.
- Capacity planning.
- Configuring backup on database.
- Ensuring database is hardening in accordance with Authority standards.
