Associate Consultant – Oracle DBA (12 months contract)

ESOL PTE. LTD.; Singapore; On-site; SGD 80,000 - 110,000; Full time

Job summary

A technology company in Singapore seeks a skilled professional to manage and optimize Oracle databases. The role includes responsibilities like implementing CI/CD pipelines, automating deployments, and monitoring database performance. Candidates must have a Bachelor's degree in a relevant field and 5-7 years of experience in database administration, with proficiency in Oracle and cloud services. This position requires strong scripting and DevOps skills, ensuring successful database operation and integration.

Qualifications

• 5-7 years of experience in related field.
• Proficiency in Oracle Database administration and development.
• Experience with cloud-based database services (e.g., RDS, Cloud SQL).

Responsibilities

• 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.
• Implement and manage backup and recovery strategies.

Skills

Oracle Database administration

SQL

PL/SQL

SQL*Plus

Database performance tuning

CI/CD tools

Terraform

Ansible

Scripting (Python, Perl, Shell)

Cloud platforms (OCI, Azure)

Git

Education

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

Tools

Oracle RMAN

Data Guard

Jenkins

GitLab CI

Azure DevOps

Job description

Job Description & Requirements

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.

Skills Requirement

• 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.