Associate Consultant – Oracle DBA

PARKAR DIGITAL PTE. LTD.; Singapore; On-site; SGD 75,000 - 95,000; Full time

Job summary

A leading digital solutions provider in Singapore is seeking an experienced Database Administrator who will manage and optimize Oracle databases while implementing CI/CD pipelines. The ideal candidate has 5-7 years of experience with SQL, PL/SQL, and cloud platforms, along with proficiency in scripting and infrastructure as code tools. An attractive compensation package is offered along with opportunities for professional growth.

Qualifications

• 5-7 years of experience in a related field.
• Proficiency in Oracle Database administration and development.
• Experience with SQL, PL/SQL, and SQL*Plus.
• Knowledge of cloud platforms and services.

Responsibilities

• Install, configure, and maintain Oracle databases.
• Develop and maintain database schemas, tables, views, and indexes.
• Optimize SQL queries and database structures for performance.
• Implement and manage backup and recovery strategies.
• Automate database deployments and updates using tools like Terraform and Ansible.

Skills

Oracle Database administration

SQL

PL/SQL

Database performance tuning

CI/CD tools (Jenkins, GitLab CI, Azure DevOps)

Infrastructure as Code (IaC)

Scripting (Python, Perl, Shell)

Git

Education

Bachelor’s degree in Engineering/Information Technology/Computer Science

Tools

Oracle RMAN

Data Guard

Terraform

Ansible

Job description

Role Summary

This role involves managing and optimizing Oracle databases while also implementing CI/CD pipelines, infrastructure-as-code (IaC) tools, and monitoring systems for database deployments and performance.

Responsibilities

Database Administration

• Install, configure, and maintain Oracle databases.
• Develop and maintain database schemas, tables, views, and indexes.
• Optimize SQL queries and database structures for performance.
• Monitor and analyze database performance metrics.
• Troubleshoot and resolve database issues.
• Implement and manage backup and recovery strategies.
• Manage user access and security.

DevOps

• Automate database deployments and updates using tools like Terraform, Ansible, and Git.
• Implement continuous integration and continuous delivery (CI/CD) pipelines.
• Utilize Infrastructure as Code (IaC) to manage database infrastructure.
• Monitor database performance and availability using monitoring tools.
• Collaborate with development teams to ensure database integration and deployment.
• Migrate databases to cloud platforms.
• Automate database tasks and processes using scripting (e.g., Python, Perl, Shell).

Cloud Skills

• Familiarity with cloud platforms like OCI, Azure
• Experience with cloud-based database services (e.g., RDS, Cloud SQL) can be valuable.

Requirements

• Bachelor’s degree in Engineering/Information Technology/ Computer Science
• 5-7 years of experience in related field
• Proficiency in Oracle Database administration and development.
• Experience with SQL, PL/SQL, and SQL*Plus.
• Knowledge of database performance tuning and optimization.
• Experience with Oracle RMAN and Data Guard.
• Experience with CI/CD tools like Jenkins, GitLab CI, or Azure DevOps.
• Experience with IaC tools like Terraform or Ansible.
• Familiarity with scripting languages like Python, Perl, or Shell.
• Knowledge of cloud platforms and services.
• Experience with Git for source code management.

Education

• Bachelor’s degree in Engineering/Information Technology/ Computer Science