Cloud Oracle Database Administrator

P3 Design Solutions; Chennai District; On-site; INR 900,000 - 1,500,000; Full time

Job summary

P3 Design Solutions in Chennai District, India, is seeking an Oracle Database Administrator to manage OCI-based databases and ensure high availability in cloud environments.

You will oversee backups, disaster recovery, performance tuning, and security, while migrating on-premises databases to the cloud and automating routine tasks with scripts.

Qualifications

• Experience managing Oracle databases (12c/19c+) in production.
• Proficient with OCI database services and cloud infrastructure.
• Strong SQL/PLSQL tuning and RMAN/Data Guard knowledge.
• Experience with backups, recovery, monitoring, and DR.
• Proficient in Linux/Unix commands and shell scripting.
• Knowledge of cloud security and networking in a high-availability context.

Responsibilities

• Install, configure, administer, and maintain Oracle databases in cloud environments, preferably OCI.
• Manage Oracle Autonomous Database, backup and recovery, and disaster recovery procedures.
• Monitor database performance and perform SQL tuning and query optimization.
• Implement database security, user access management, patching, and upgrades.
• Troubleshoot database issues and ensure high availability, reliability, and data integrity.
• Support database migration from on-premises environments to the cloud.
• Automate routine database administration tasks using scripts.

Skills

Oracle Database Administration

OCI Cloud Services

SQL & PL/SQL

Performance Tuning

Linux/Unix Shell

High Availability

Security & Backups

Job description

Role & responsibilities

• Install, configure, administer, and maintain Oracle databases in cloud environments, preferably Oracle Cloud Infrastructure (OCI).


• Manage Oracle Autonomous Database, backup and recovery, and disaster recovery procedures.


• Monitor database performance and perform SQL tuning and query optimization.


• Implement database security, user access management, patching, and upgrades.


• Troubleshoot database issues and ensure high availability, reliability, and data integrity.


• Support database migration from on-premises environments to the cloud.


• Automate routine database administration tasks using scripts.

Required Skills:

• Strong experience in Oracle Database administration (Oracle 12c/19c or later).


• Hands-on knowledge of OCI database services and cloud infrastructure.


• Proficiency in SQL, PL/SQL, performance tuning, RMAN, and Data Guard.


• Knowledge of database backup, recovery, monitoring, and disaster recovery.


• Experience with Linux/Unix commands and shell scripting.


• Understanding of cloud security, networking, and high-availability concepts.