Oracle DBA (OMAN/UAE)

ITHR 360° CONSULTING FZE; Dubai; On-site; AED 240,000 - 480,000; Full time

Job summary

ITHR 360° CONSULTING FZE is seeking a senior Oracle Database Administrator to install, configure, and upgrade Oracle database software and manage patches. You will monitor environments for high availability, perform backups and DR, and collaborate with development teams to optimize performance and reliability.

The role requires deep expertise in Oracle RAC, Data Guard, RMAN, and SQL/PLSQL tuning, with experience in OEM and AWR/ADDM/ASH reporting. Uplift of automation via scripting is a plus.

Qualifications

• Strong knowledge of Oracle Database 12c, 18c, 19c, and/or 21c.
• In-depth knowledge of Oracle RAC, Data Guard, ASM, and RMAN.
• Expertise in SQL query optimization and PL/SQL programming.
• Familiarity with Oracle Enterprise Manager (OEM) and other database monitoring tools.
• Experience with Oracle AWR, ADDM, and ASH reports for performance tuning.
• Solid understanding of database backup, recovery, and disaster recovery methodologies.
• Experience with shell scripting or automation tools (e.g., Ansible, Python) is a plus.

Responsibilities

• Install, configure, and upgrade Oracle database software and manage patches/updates.
• Manage and monitor Oracle database environments for high availability and performance.
• Perform regular database backups, restore operations, and disaster recovery processes.
• Assist with capacity planning and performance tuning.
• Support database security including user management, access controls, and audits.
• Implement and monitor replication, clustering, and high availability solutions (RAC, Data Guard).
• Perform root-cause analysis for database issues and provide solutions.
• Handle incidents and service requests, ensuring timely resolution and minimal downtime.
• Troubleshoot complex database issues related to SQL performance, connection failures, and database crashes.
• Work closely with development and application teams to resolve issues related to application-database integration.

Skills

Oracle DB versions

Oracle RAC

SQL/PLSQL tuning

OEM monitoring

AWR/ADDM/ASH

Backup & DR

Scripting (Shell/Python)

Tools

OEM

RMAN

Ansible

Python

Job description

• Install, configure, and upgrade Oracle database software and manage patches/updates.
• Manage and monitor Oracle database environments, ensuring high availability and performance.
• Perform regular database backups, restore operations, and disaster recovery processes.
• Assist with capacity planning and performance tuning, ensuring system efficiency.
• Support database security, including user management, access controls, and audits.
• Implement and monitor database replication, clustering, and high availability solutions (RAC, Data Guard).
• Perform root-cause analysis for database issues and provide solutions.
• Handle incidents and service requests, ensuring timely resolution and minimal downtime.
• Troubleshoot complex database issues related to SQL performance, connection failures, and database crashes.
• Work closely with development and application teams to resolve issues related to application-database integration.

Database Monitoring & Optimization:

• Use Oracle Enterprise Manager (OEM) and other monitoring tools to oversee database health and performance.
• Analyze database logs and performance metrics to identify areas of improvement.
• Optimize queries and indexing for improved database performance.
• Implement and monitor database maintenance tasks like reorg, stats gathering, etc.

Support & Maintenance:

• Provide 24x7 support on call as part of the support rotation for critical systems and databases.
• Provide technical support during database outages or failures and participate in post-mortem reviews.
• Develop and maintain documentation for database configurations, processes, and troubleshooting guides.

Technical Skills:

• Strong knowledge of Oracle Database 12c, 18c, 19c, and/or 21c.
• In-depth knowledge of Oracle RAC, Data Guard, ASM, and RMAN.
• Expertise in SQL query optimization and PL/SQL programming.
• Familiarity with Oracle Enterprise Manager (OEM) and other database monitoring tools.
• Experience with Oracle AWR, ADDM, and ASH reports for performance tuning.
• Solid understanding of database backup, recovery, and disaster recovery methodologies.
• Experience with shell scripting or automation tools (e.g., Ansible, Python) is a plus.