Oracle Database Administrator

What will make you successful in this role? Strategy & Planning - Assess and develop long-term strategic goals for production databases in conjunction with data owners and department managers - Work with application development staff to develop database architectures, coding standards, and quality assurance policies and procedures - Design and implement redundant systems, policies, and procedures for disaster recovery and data archiving to ensure effective protection and integrity of data assets Acquisitions & Deployment - Conduct research and make recommendations on database products, services, protocols, and standards in support of procurement and development efforts. Specific daily tasks will include, but is not limited to - General Oracle multi-tenant and schema administration tasks, management and maintenance. - Application database request handling. - Starting up and shutting down databases routines as part of the OS patching routines. - Oracle Patching routines N-1 requirement in line with application certification. - Database logical and physical storage structure changes and maintenance. - Oracle user access control and review. - Create, deploy and review DDL and DML to manage user data and schema objects. - Database backup and recovery process implementation and monitoring. - Database health monitoring and reporting issues to senior DBA, as well as actively take part in preventive or corrective actions. - Implement and review DR capability and participate in twice annual DR exercises. - DBMS performance troubleshooting, monitoring user activity and trace application session activity. Upskill & / or participate in Oracle DBMS component support - Data Guard (Recovery) - Advanced Security (Encryption) - Database Vault (DAM) - Multi-Tenant (PDB & CDB) - Masking & SubSetting (Data Obfuscation) Qualifications: - Matric - Degree or Diploma in the field of computer science and/or 2 years equivalent work experience Knowledge & Experience: - DBMS Backups o Perform database backups (Hot/Cold Backups) using RMAN. o Perform schema-based backups using export and import utilities. o TDE Wallet encryption for file encryption - Database Security o Implement and maintain Oracle database user roles and privileges (i.e c#, etc.) for adherence to the companys data access- and data security policies - Disaster Recovery o Understand disaster recovery principles and take part in DR exercises - Linux and MS OS Proficiency o Working knowledge of the underlying Linux - and Microsoft OS to perform basic Oracle DBMS tasks. o Sound knowledge of OS level DBMS utilities. (IMPDB, EXPDB, RMAN etc.) - PL/SQL & SQL DDL and DML o DDL creation for database object manipulation using basic SQL, PL/SQL scripts SQL procedures. (All database schema objects - tables, indexes, views, database link, PL/SQL procedures and triggers) o Database maintenance job creation, scheduling and monitoring. - Management Tool Knowledge o Sound working knowledge of Toad / SQL Developer for daily task management o Good working knowledge of OEM Cloud Control will be advantageous - Cloud knowledge and skills are advantageous - Oracle specific o Working knowledge of Oracle DBMS, Sound working knowledge of the operating system Oracle server resides on and usage of underlying infrastructure o Knowledge of general database concepts o Understanding up to Oracle DMBS v19C o Working knowledge and understanding of Oracle DMBS v19C o Working knowledge and sound understanding of all available products, services and resources in the Oracle DMBS v19C Server suite of products o Knowledge to advise and execute on integration to the Oracle environment including ODBC, JDBC, ODBO and other Oracle supported connectors o Knowledge of the Oracle manager to monitor database performance and troubleshooting Knowledge and Skills - IT Data Analysis - Database Knowledge and Monitoring - Data Security - Risk Management - Project Oversight Personal Attributes - Organisational savvy - Contributing through others - Manages complexity - Contributing through others - Plans and aligns - Contributing through others - Optimises work processes - Contributing through others Core Competencies - Cultivates innovation - Contributing through others - Customer focus - Contributing through others - Drives results - Contributing through others - Collaborates - Contributing through others - Being resilient - Contributing through others

Location: Cape Town City Centre, ZA

Posted Date: 12/21/2024