Skip to main content

This job has expired

You will need to login before you can apply for a job.

Oracle DBA

Employer
Cognizant
Location
Singapore, Singapore
Salary
Competitive
Closing date
May 17, 2024

View more

Job Function
Other
Industry Sector
Finance - General
Employment Type
Full Time
Education
Bachelors
Roles and Responsibilities

Part of the project DevOps team to take on the exciting and challenging role of delivering and maintaining a large-scale project using AGILE software development methodology.
  • 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
  • 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 Requirements
  • Working experience with Oracle 19c 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
  • 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 19c
    • AWS RDS
    • DB audit and security
    • Data masking products
    • Oracle Data Guard
    • Oracle GoldenGate
    • MS SQL Server
    • Postgres DB


Employee Status : Full Time Employee

Shift : Day Job

Travel : No

Job Posting : May 14 2024

About Cognizant
Cognizant (Nasdaq-100: CTSH) is one of the world's leading professional services companies, transforming clients' business, operating and technology models for the digital era. Our unique industry-based, consultative approach helps clients envision, build and run more innovative and efficient businesses. Headquartered in the U.S., Cognizant is ranked 185 on the Fortune 500 and is consistently listed among the most admired companies in the world. Learn how Cognizant helps clients lead with digital at www.cognizant.com or follow us @Cognizant.

Sign in to create job alerts

Sign in or create an account to start creating job alerts and receive personalised job recommendations straight to your inbox.

Create alert