Oracle Database Administrator (DBA)

Careers International; Dubai; On-site; AED 167,000 - 279,000; Full time

Job summary

Careers International in Dubai seeks a Database Environment Management professional to plan, implement, and maintain in-house database environments across development, testing, and production.

You will monitor and optimize performance using OEM tools, manage backups and recovery, and provide 24x7 operational support to resolve incidents quickly while escalating when needed. Strong Unix and Oracle skills are essential.

Qualifications

• Experience administering Unix-based operating systems.
• Strong skills in Unix shell scripting.
• Proficiency in PL/SQL development.
• Familiarity with Oracle tools and technologies.
• Experience using Oracle Data Guard is preferred.

Responsibilities

• Plan, implement, test, and maintain in-house database environments.
• Setup and configure database engines for development, testing, and production environments.
• Provide 24x7 support for day-to-day database activities, ensuring speedy resolution or escalation of operational incidents/problems.
• Conduct proactive monitoring activities to prevent incidents and maximize database availability.
• Perform regular performance tuning of the database, including table structure and index optimization.
• Develop and implement scripts for database task scheduling, monitoring, and maintenance.
• Manage database backup and restore operations to ensure data integrity and availability.

Skills

Unix OS administration

Unix shell scripting

PL/SQL development

Oracle tools

Oracle Data Guard

Tools

Oracle Enterprise Manager (OEM) 12c

Job description

Database Environment Management:

• Plan, implement, test, and maintain in-house database environments.
• Setup and configure database engines for development, testing, and production environments.
• Provide 24x7 support for day-to-day database activities, ensuring speedy resolution or escalation of operational incidents/problems.

Monitoring and Optimization:

• Conduct proactive monitoring activities to prevent incidents and maximize database availability.
• Perform regular performance tuning of the database, including table structure and index optimization.
• Develop and implement scripts for database task scheduling, monitoring, and maintenance.

Reporting and Analysis:

• Generate weekly reports on database status for analysis and forecasting usage, including tablespace,disk space, and table rows.
• Utilize Oracle Enterprise Manager (OEM) 12c cloud for comprehensive monitoring and management.

Backup and Recovery

Manage database backup and restore operations to ensure data integrity and availability.

Requirements

• Proficiency in administrating Unix OS.
• Strong knowledge of Unix shell scripting.
• Experience with PL/SQL development.
• Familiarity with Oracle-related tools and technologies.
• Experience using Oracle Data Guard, with or without broker.

Certifications:

• Preferably hold OCA / OCP Certification (Oracle Certified Associate / Oracle Certified Professional) or equivalent.