Connecting...

Oracle DBA

Job Title: Oracle DBA
Contract Type: Contract
Location: Singapore, Singapore
Industry:
Salary: Negotiable
Start Date: ASAP
Reference: 192726_1550807554
Contact Name: May Anne Ramos
Contact Email: mayanne.ramos@peoplebank.asia
Job Published: February 22, 2019 12:27

Job Description

Our Client

  • A familiar brand in Singapore's public-sector industry.
  • Attractive contract package and benefits (18 days AL, performance bonus, etc.)

The Opportunity

As a Oracle DBA, your role will be:

  • Responsible for designing the database's architecture and modelling strategies to ensure that the database is secure, scalable and performs reliably.
  • Ensures necessary data model design and policy compliance.
  • Work with the application development team to define the application data model and work on tuning and optimizing database related operation.
  • Point of contact to principal vendors for software and hardware.
  • Provides production support and responsible for the resolution of database related issues and duty rotation for after-office-hours support.
  • Provides 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.
  • 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
    1. Ensure database services and servers availability
    2. Install and configure Oracle Database and associated products
  • Provide operational support including
    1. Ensuring Oracle database patches are performed in accordance to the patch release cycle
    2. Reviewing and maintaining of database accounts
    3. Monitoring and optimising database performance, such as optimising queries, creating indexes etc
    4. Capacity planning
    5. Configuring RMAN backup on database
  • Ensuring Oracle database is hardening in accordance to company's standards

Your Background

The ideal candidate should possess the following skills and experience:

  • Tertiary Education (Degree or Diploma) 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
  • Experience in Oracle 12 will be added advantage
  • Experience in AWS RDS will be added advantage
  • Experience with DB audit and security will be added advantage
  • Experience with data masking products will be added advantage
  • Experience with Oracle database on Solaris Cluster setup will be added advantage
  • Experience with MSSQL will be added advantage
  • Good analytical and writing skills
  • Good team player and meticulous
  • Passionate in championing the team to continuously improve to deliver quality software product
  • Candidates must be open to 9 mos contract with option to extend

Interested candidates please submit your CV to mayanne.ramos@peoplebank.asia or apply online


Get similar jobs like these by email

By submitting your details you agree to our T&C's