Database Administrator

Singapore, Singapore

Job Description


  • 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.
Requirements
  • Design the database\xe2\x80\x99s 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.

Unison Consulting

Beware of fraud agents! do not pay money to get a job

MNCJobz.com will not be responsible for any payment made to a third-party. All Terms of Use are applicable.


Related Jobs

Job Detail

  • Job Id
    JD1474316
  • Industry
    Not mentioned
  • Total Positions
    1
  • Job Type:
    Full Time
  • Salary:
    Not mentioned
  • Employment Status
    Permanent
  • Job Location
    Singapore, Singapore
  • Education
    Not mentioned