Oracle DBA (SQL, PL/SQL, SQL*Plus, Oracle RMAN and Data Guard)

EXASOFT PTE. LTD.; Singapore; On-site; SGD 60,000 - 80,000; Full time

Job summary

A leading technology firm in Singapore seeks an experienced database administrator. The role involves installing, configuring, and maintaining Oracle databases, automating deployments, optimizing performance, and collaborating with development teams. Candidates should have a Bachelor's degree in Engineering or IT and 5-7 years of experience with database administration and cloud technologies. Familiarity with CI/CD tools and scripting languages is essential.

Qualifications

• 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 CI/CD tools like Jenkins, GitLab CI, or Azure DevOps.

Responsibilities

• Install, configure, and maintain Oracle databases.
• Automate database deployments and updates using tools like Terraform and Ansible.
• Monitor and analyze database performance metrics.
• Collaborate with development teams for database integration.
• Migrate databases to cloud platforms.

Skills

Oracle Database administration

SQL

Cloud platforms

Terraform

Ansible

Python

Education

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

Tools

Git

Jenkins

Data Guard

RMAN

Job description

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.

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.
• Experience of cloud platforms and services.
• Experience with Git for source code management.