Associate Consultant - Oracle DBA, DevOps (1 year contract)

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.