Cape Town City Centre: Oracle Database Administrator

Date	2024-11-20
Job Title	Oracle Database Administrator
Employer	More Information
Salary	1 Monthly
Category	It Computing Software
Location	Cape Town Region / Cape Town City Centre

Job Summary

The Database Administrators role is to design, support, monitor, maintain, and performance tune production databases while ensuring high levels of data availability. This individual is also responsible for developing, implementing, and overseeing database policies and procedures to ensure the integrity and availability and recoverability of databases and their accompanying software. Perform general Oracle database administration tasks on Oracle 19C installations for the companies centrally hosted Oracle solutions for African countries, as well as support of in-country hosted implementations. Oracle is deployed on both Linux and Windows. This position includes both system – and application database support tasks. 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 Perform database backups (Hot/Cold Backups) using RMAN. Perform schema-based backups using export and import utilities. TDE Wallet encryption for file encryption Database Security 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 Understand disaster recovery principles and take part in DR exercises Linux and MS OS Proficiency Working knowledge of the underlying Linux – and Microsoft OS to perform basic Oracle DBMS tasks. Sound knowledge of OS level DBMS utilities. (IMPDB, EXPDB, RMAN etc.) PL/SQL & SQL DDL and DML 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) Database maintenance job creation, scheduling and monitoring. Management Tool Knowledge Sound working knowledge of Toad / SQL Developer for daily task management Good working knowledge of OEM Cloud Control will be advantageous Cloud knowledge and skills are advantageous Oracle specific Working knowledge of Oracle DBMS, Sound working knowledge of the operating system Oracle server resides on and usage of underlying infrastructure Knowledge of general database concepts Understanding up to Oracle DMBS v19C Working knowledge and understanding of Oracle DMBS v19C Working knowledge and sound understanding of all available products, services and resources in the Oracle DMBS v19C Server suite of products Knowledge to advise and execute on integration to the Oracle environment including ODBC, JDBC, ODBO and other Oracle supported connectors 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

View Job Cape Town City Centre: Aircraft Mechanic Ame

Oracle Database Administrator position available in Cape Town Region, Cape Town City Centre. This job position was posted by . The job has been posted on 2024-11-20 in the It Computing Software category

Click Go Apply to apply online!

You might also like to look at the available jobs in the same area.

Select one of the buttons below to browse for more available jobs.

Apply directly for this position
Some posts have contact information included with other instructions. All applicants are urged to read the instructions carefully.
We will list jobs at the bottom of each job, so feel free to scroll down and continue your search.

We do not accept any job applications and merely offer the service of daily jobs being mined and displayed on our job portal.
Each job post has a link to take you directly to the original post to apply on their website or the original website where the post came from.

Here are some more related positions