Senior Specialist – Oracle Database Administrator

Key Responsibilities

• Install, configure, upgrade, and maintain Oracle databases from versions 11g to 23ai, including Oracle Grid Infrastructure.
• Manage database storage using ASM, ACFS, traditional file systems, and Exadata storage components.
• Monitor database performance, alerts, and health through Oracle Enterprise Manager (OEM), generating regular health checks and capacity reports.
• Manage database users, roles, privileges, scheduled jobs, and access permissions.
• Perform SQL query tuning, execution plan analysis, and troubleshooting of database performance, connectivity, and storage issues.
• Implement and monitor backup and recovery strategies using RMAN and Data Pump, validate backup logs, and perform restore testing.
• Manage tablespaces, indexes, database statistics, storage reclamation, patching, and routine maintenance activities.
• Support and maintain high-availability and disaster recovery solutions using Oracle RAC, Data Guard, and GoldenGate.
• Participate in disaster recovery drills and validate recovery procedures for business-critical databases.
• Conduct advanced performance analysis using AWR, ADDM, ASH, and SQLT, addressing SQL bottlenecks and system-level performance issues.
• Implement database security controls, including Transparent Data Encryption (TDE), Database Vault, Virtual Private Database (VPD), and data masking.
• Manage database auditing and access controls, supporting compliance with CIS and NIST security standards.
• Collaborate with information security teams to implement database hardening and compliance requirements.
• Automate routine database administration tasks using Shell scripting (Bash and KornShell) and develop monitoring and alerting scripts.
• Manage database incidents through IT service management (ITSM) tools, raise and track service requests with Oracle Support, and lead root cause analysis.
• Ensure changes are properly documented, assessed, and approved in accordance with established change management procedures.

Requirements

• Bachelor’s degree or equivalent qualification in Computer Science, Information Technology, or a related field.
• Minimum of 8 years of solid experience as an Oracle Database Administrator.
• In-depth knowledge of Oracle Database (11g–23ai), Oracle RAC, and Grid Infrastructure.
• Strong hands-on experience with Oracle Enterprise Manager (OEM), RMAN, Data Guard, GoldenGate, ASM, ACFS, ZFS, and Exadata.
• Experience with Oracle Cloud Infrastructure (OCI) and Azure environments supporting Oracle databases.
• Oracle Certified Professional (OCP) certification is required.
• Experience with Oracle Exadata or Oracle Database Appliance (ODA).
• Familiarity with Oracle Multitenant architecture, including Container Databases (CDB) and Pluggable Databases (PDB).
• Knowledge of Shell scripting using Bash or KornShell.
• Basic Linux administration experience, preferably with Oracle Linux, RHEL, Ubuntu, or CentOS.
• Exposure to other database platforms, such as SQL Server, MongoDB, MariaDB, or PostgreSQL, is an advantage.
• Experience using ITSM tools such as ManageEngine.
• Strong analytical, troubleshooting, and problem-solving skills.
• Ability to work independently and collaboratively within a team.
• Strong technical documentation and communication skills.
• Ability to perform effectively in high-pressure environments.
• Proficiency in English is required; Arabic proficiency is preferred.