Oracle Database Administrator

About the Role

We are searching for a seasoned Oracle Database Administrator with 5 to 10 years of professional experience to oversee, maintain, and fine-tune Oracle database systems. This role is based in Jeddah, Saudi Arabia, with an onsite contract arrangement. The successful candidate will be proficient in administration, performance optimization, backup and recovery, high availability configurations, and securing Oracle databases.

Key Duties

• Install, configure, upgrade, and apply patches to Oracle Databases including versions 11g, 12c, 19c, and 21c.
• Handle core database administrative tasks such as creation, migration, cloning, and routine maintenance.
• Continuously monitor database health, ensure optimal performance, and maximize availability.
• Use tools like AWR, ASH, ADDM, SQL Trace, and execution plans for tuning database performance.
• Set up and manage Oracle Data Guard to guarantee disaster recovery readiness.
• Administer Oracle Real Application Clusters (RAC) environments.
• Develop and execute RMAN-based backup and recovery strategies.
• Resolve database-related challenges including performance bottlenecks, locking issues, deadlocks, storage problems, and connectivity faults.
• Perform database refreshes, cloning, and migration operations effectively.
• Implement best practices for database security including user management, role assignment, privilege control, and audit procedures.
• Monitor storage usage and plan capacity expansions as necessary.
• Automate repetitive database admin tasks through Shell scripting or Python programming.
• Collaborate closely with application, infrastructure, and development teams to support seamless operations.
• Provide incident support for production environments and participate in the on-call rotation.

Required Expertise

• Proficient in Oracle Database versions 11g, 12c, 19c, and 21c administration.
• Experience managing Oracle RAC and Oracle Data Guard technologies.
• Skilled in RMAN for backup and recovery implementations.
• Strong capabilities in database performance tuning, SQL, and PL/SQL programming.
• Understanding of Automatic Storage Management (ASM).
• Experienced in installation, upgrades, and patching using OPatch utility.
• Comfortable working with Linux/Unix operating systems and administering these environments.
• Competent in Shell scripting for automation purposes.
• Knowledgeable in database security practices, including user and role management.
• Hands-on experience with database cloning, refreshing processes, and Oracle Enterprise Manager (OEM).