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 after-office-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.
Required skills:
- Past track records with Oracle/MSSQL/DB2/MySQL/Postgres/Maria/Mongol databases including setting up and managing the environment.
- Experience in setting up and managing databases in a high availability active-active setup will be added advantage.
- Knowledge in PL/SQL scripting will be added advantage.
- Knowledge in working with ETL and data co-existence technology with legacy systems will be added advantage.
- Knowledge with DB audit and security will be added advantage.
- Knowledge with data masking products will be added advantage.