Job Summary
You will be working with our client in the financial industry. You will play an important role in transforming structured and unstructured data. You will be part of a dynamic team responsible for developing, enhancing and maintaining IT systems/applications that support data management needs.
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.
- 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.
- 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 organisation's standards.
Requirements
- Bachelor’s degree in IT, Computer Science, or a related field.
- 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.
If you are interested in this role and would like to discuss the opportunity further please click apply now or email Chew Kai-Xinn at [email protected] for more information.
Only shortlisted candidates will be responded to, therefore if you do not receive a reply within 14 days please accept this as notification that you have not been shortlisted.
Morgan McKinley Talent Solutions
Morgan McKinley Pte Ltd EA Licence No: 11C5502
EAP Registration No: R2196712
EAP Name: Chew Kai-Xinn
