Job Description

:

Oracle DBA with Devops JD:

A combined Oracle DBA and DevOps role combines traditional database administration responsibilities with DevOps practices, automating and streamlining database operations. 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,required. Experience with cloud-based database services (e.g., RDS, Cloud SQL) can be valuable.
Required Skills:

Oracle DBA:

Proficiency in Oracle Database administration and development. Oracle Cloud, Terraform, Ansible, Github, Oracle DB Experience with SQL, PL/SQL, and SQLPlus.
Knowledge of database performance tuning and optimization. Experience with Oracle RMAN and Data Guard.

DevOps:

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.