Senior Oracle Database Administrator - RAC, Data Guard and Performance Tuning

DiceTek UAE; Abu Dhabi; Sur place; AED 350 000 - 520 000; Plein temps

Résumé du poste

Dicetek LLC in Abu Dhabi, United Arab Emirates, seeks a senior Oracle Database Administrator for a full-time, on-site role. You will administer and optimize mission-critical Oracle environments, focusing on RAC, ASM, RMAN and Data Guard, with emphasis on high availability, performance tuning and proactive issue resolution.

The ideal candidate has 10+ years of hands-on DBA experience, strong RCA skills, and a track record of maintaining stability in large OLTP/Data Warehouse systems within

Qualifications

• Minimum 10 years of hands-on Oracle Database Administration in large enterprise environments.
• Strong hands-on expertise with Oracle RAC, ASM, RMAN and Data Guard Broker.
• Experience with Oracle Flashback technologies and Oracle Enterprise Manager.
• Proven ability to diagnose complex production issues and perform root-cause analysis.
• Proficiency in SQL and PL/SQL for tuning and troubleshooting.

Responsabilités

• Administer, maintain and support mission-critical Oracle database environments.
• Manage Oracle RAC, ASM, RMAN and Data Guard configurations.
• Monitor database health, availability, resource utilization and performance.
• Support high-volume OLTP and large Data Warehouse databases.
• Perform routine administration, configuration and maintenance tasks.
• Use Oracle Enterprise Manager to monitor and manage environments.
• Maintain reliability of database operations across complex systems.

Connaissances

Oracle DBA

Performance tuning

Root cause analysis

Automation

Outils

Oracle RAC

ASM

RMAN

Data Guard Broker

Flashback technologies

Oracle Enterprise Manager

Description du poste

Senior Oracle Database Administrator - RAC, Data Guard and Performance Tuning Job Snapshot - Role: Senior Oracle Database Administrator - Location: Abu Dhabi, United Arab Emirates - Industry: I T and Services - Function: Database Administration - Experience: 10 years - Job Type: Full Time - Work Arrangement: On-site

Position Overview

Dicetek LLC is seeking a highly experienced Senior Oracle Database Administrator (DBA) for a full-time, on-site position in Abu Dhabi, United Arab Emirates. The role requires extensive hands-on expertise in administering, maintaining and optimizing mission-critical Oracle database environments supporting large enterprise applications. The successful candidate will be responsible for Oracle database administration, high availability, disaster recovery, performance tuning, database maintenance and production troubleshooting across high-volume Online Transaction Processing (OLTP) and Data Warehouse environments. Candidates must have at least 10 years of Oracle Database Administration experience, with strong technical knowledge of Oracle Real Application Clusters (RAC), Automatic Storage Management (ASM), Recovery Manager (RMAN), Data Guard Broker, Flashback technologies and Oracle Enterprise Manager. The position requires an experienced database professional capable of independently diagnosing complex production issues, restoring services, performing root-cause analysis and implementing sustainable improvements to database reliability, scalability and performance.

Job Details

Country: United Arab Emirates - City: Abu Dhabi - Industry: I T and Services - Function: Database Administration - Salary: Not disclosed - Gender: No Preference - Candidate Nationality: Not specified - Job Type: Full Time - Work Arrangement: On-site

Key Responsibilities

• Administer, maintain and support mission-critical Oracle database environments.
• Manage Oracle RAC, ASM, RMAN and Oracle Data Guard configurations using Data Guard Broker.
• Monitor database health, availability, resource utilization and operational performance.
• Support high-volume OLTP systems and large enterprise Data Warehouse databases.
• Perform routine database administration, configuration and maintenance activities.
• Use Oracle Enterprise Manager to monitor and manage database environments.
• Maintain reliable database operations across complex enterprise production systems.

Database Performance Monitoring and Tuning

• Monitor, diagnose and optimize database, SQL and system performance.
• Perform advanced performance analysis using Automatic Workload Repository (AWR), Active Session History (ASH) and Automatic Database Diagnostic Monitor (ADDM).
• Analyse SQL execution plans and database wait events to identify performance bottlenecks.
• Investigate inefficient queries, resource contention and database processing delays.
• Review indexing strategies, table partitioning and optimizer statistics to improve database performance.
• Support performance optimization for high-volume transactional workloads and large Data Warehouse environments.
• Recommend improvements to database configuration, resource utilization and query execution efficiency.

Production Troubleshooting and Root-Cause Analysis

• Independently investigate and resolve complex Oracle database production incidents.
• Diagnose database failures, performance degradation and availability issues.
• Restore affected database services and support operational recovery.
• Conduct detailed technical Root Cause Analysis (RCA) for critical incidents.
• Identify recurring database problems and implement corrective and preventive actions.
• Collaborate with application, infrastructure and engineering teams during production incidents.
• Take end-to-end ownership of assigned database issues with minimal supervision.

High Availability, Backup and Disaster Recovery

• Administer Oracle RAC environments to support database availability and resilience.
• Manage Oracle Data Guard and Data Guard Broker configurations.
• Support Oracle Flashback technologies and database recovery operations.
• Perform database backup and recovery activities using Oracle RMAN.
• Validate backup procedures and database recovery capabilities.
• Participate in disaster recovery testing and validation.
• Review database architecture and recommend improvements to high availability, recovery readiness and operational resilience.

Database Maintenance and Optimization

• Manage database partitioning and indexing strategies.
• Perform table maintenance and database object management.
• Maintain and review database optimizer statistics.
• Monitor database storage utilization and perform space management activities.
• Support database housekeeping and maintenance operations.
• Identify opportunities to improve database efficiency and resource utilization.
• Maintain database stability during planned maintenance activities.

Database Patching, Upgrades and Migration

• Perform Oracle database patching and upgrades.
• Support database migration activities within enterprise environments.
• Assess technical dependencies and operational risks associated with database changes.
• Coordinate planned maintenance with application, infrastructure and engineering teams.
• Validate database functionality and stability following patches, upgrades and migrations.
• Troubleshoot technical issues arising during database maintenance or change activities.

Database Automation and Scripting

• Automate recurring database administration and maintenance activities.
• Develop and maintain Shell scripts for operational database tasks.
• Use SQL and PL/SQL scripting to support database administration and troubleshooting.
• Apply relevant automation tools to improve operational efficiency.
• Identify manual processes that can be standardized or automated.
• Support consistent execution of database maintenance and monitoring activities.

Database Architecture and Technical Collaboration

• Review Oracle database architecture and configuration across enterprise environments.
• Recommend improvements to database availability, scalability, resilience and performance.
• Apply strong knowledge of Oracle database internals when investigating technical issues.
• Support technical discussions involving database infrastructure and application dependencies.
• Collaborate with application developers, infrastructure specialists and engineering teams.
• Provide technical input during incidents, planned changes and database maintenance activities.

Required Qualifications and Experience

• Minimum 10 years of hands-on Oracle Database Administration experience in large enterprise production environments.
• Extensive experience administering mission-critical Oracle databases.
• Strong hands-on expertise with Oracle RAC, ASM, RMAN and Data Guard Broker.
• Practical experience using Oracle Flashback technologies and Oracle Enterprise Manager.
• Advanced database performance tuning and SQL optimization skills.
• Experience using AWR, ASH, ADDM, SQL execution plans and database wait-event analysis.
• Proven experience supporting high-volume OLTP and large Data Warehouse databases.
• Strong understanding of Oracle database architecture, internals, high availability and recovery concepts.
• Experience with database partitioning, indexing, table maintenance, statistics and space management.
• Hands-on experience with Oracle patching, upgrades, migrations, backup and recovery.
• Proven ability to troubleshoot complex production issues and conduct technical root-cause analysis.
• Experience automating DBA activities using Shell, SQL, PL/SQL or relevant automation tools.
• Ability to work independently and take complete ownership of database issues with minimal supervision.

Required Technical Skills Oracle Database Technologies

• Oracle Database Administration.
• Oracle Real Application Clusters (RAC).
• Oracle Automatic Storage Management (ASM).
• Oracle Recovery Manager (RMAN).
• Oracle Data Guard.
• Oracle Data Guard Broker.
• Oracle Flashback technologies.
• Oracle Enterprise Manager.

Performance Tuning and Diagnostics

• Automatic Workload Repository (AWR).
• Active Session History (ASH).
• Automatic Database Diagnostic Monitor (ADDM).
• SQL execution plan analysis.
• Database wait-event analysis.
• SQL performance tuning.
• Database resource utilization analysis.
• Performance troubleshooting for OLTP and Data Warehouse environments.

Database Architecture and Maintenance

• Oracle database architecture and internals.
• High availability and disaster recovery.
• Database partitioning.
• Indexing strategies.
• Table and database object maintenance.
• Optimizer statistics management.
• Database storage and space management.
• Backup, recovery and disaster recovery validation.

Scripting and Automation

• Shell scripting.
• SQL.
• PL/SQL.
• Database administration automation.
• Automated maintenance and operational tasks.

Professional Competencies

• Strong analytical thinking and advanced technical troubleshooting skills.
• Ability to diagnose and resolve complex database issues independently.
• End-to-end ownership of production incidents and database administration activities.
• Effective root-cause analysis and preventive problem-solving.
• Strong understanding of database reliability, scalability and performance optimization.
• Ability to collaborate with application, infrastructure and engineering teams.
• Attention to detail during database changes, maintenance and recovery activities.
• Ability to work effectively with minimal supervision in mission-critical production environments.

Candidate Profile

The ideal candidate will be a senior Oracle DBA with extensive experience managing complex enterprise database environments and supporting business-critical applications. The role requires deep expertise in Oracle RAC, Data Guard Broker, ASM, RMAN, Flashback technologies and advanced performance diagnostics. Candidates should be comfortable managing high-volume transactional databases and large Data Warehouse platforms while maintaining database availability and operational resilience. Strong independent troubleshooting capabilities, technical ownership and a proactive approach to database performance optimization, automation and preventive maintenance will be essential for success in this position.