- 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.
- 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.
- 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 optimizing database performance, such as optimising queries, creating indexes etc.
- Capacity planning.
- Configuring backup on database.
- Ensuring database is hardening in accordance with Authority standards.
Top Skills
What We Do
Unison Consulting was launched in Singapore on September 2012, the hub of the financial industry, with innovative visions in the technocratic arena. We are a boutique next-generation Technology Company with strong business-interests in Liquidity risk, Market Risk, Credit Risk and Regulatory Compliance.
Unison provides technology consulting and services to implement Risk Management and Risk Analytics System for Financial Institutions. Our services suite comprises of Techno-Functional consulting, systems integration, Business Intelligence, information management, and custom development of IT solutions, plus project management expertise for financial institutions.
We have expertise in latest cutting edge technology to achieve better total cost of ownership. Through our qualified professionals, we assist you drive your unique risk management strategies, whether that means efficient monitoring, improving risk appetite of the financial institutions, complying with regulations, or capturing growth opportunities through innovation, this is what maximizes your decision taking potential. At Unison Consulting, we view clients as partners, and our success is only measured by the success of our partners. So we put it all on the table in order to exceed expectations.
Our staff consists of young, energetic and innovative consultants who are never afraid to challenge the conventions and push the boundaries in an effort to help our clients. For every project, no matter how large or how small, we strive to not only meet your needs, but deliver a showcase in your field