Job description:
- Ensures timeliness and accuracy of data sync during co-existence with legacy systems.
- Responsible for developing and maintaining database-related codes / scripts such as data sync scripts, data masking scripts, stored procedures etc
- Ensure database services and servers availability
- Install and configure Oracle Database and associated products
- Provide operational support including
- Ensuring Oracle database patches are performed in accordance to the patch release cycle
- Reviewing and maintaining of database accounts
- Monitoring and optimising database performance, such as optimising queries, creating indexes etc
- Capacity planning
- Configuring RMAN backup on database
- Ensuring Oracle database is hardening in accordance to the internal standards
Job requirement:
- Singaporean only
- Tertiary Education in relevant field is preferred
- Working experience with Oracle 11g database or above in an Oracle RAC Active-Active environment setup, including setting up and managing the environment.
- Strong working experience in PL/SQL scripting
- Experience in working with ETL and data co-existence technology with legacy systems.
- Expected to acquire some domain knowledge to develop and maintain the stored procedures, data masking scripts and data sync script
- Added advantage with the following working experiences - Oracle 12c - AWS RDS - DB audit and security - Data masking products - Oracle Data Guard - Oracle GoldenGate - MS SQL Server
- Good analytical and writing skills
- Good team player and meticulous
- Passionate in championing the team to continuously improve to deliver quality software product