Oracle Database Administrator
1 month ago
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
-
Oracle Database Administrator
1 month ago
Cape Town City Centre, South Africa Jobted ZA C2 Full timeWhat 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...
-
Oracle Database Management Expert
2 weeks ago
Cape Town, Western Cape, South Africa Recru-it Full timeJob Title: Oracle Database Management ExpertAbout the Role:We are seeking an experienced Oracle Database Management Expert to join our team at Recru-it. As an Oracle Database Management Expert, you will be responsible for managing and maintaining our Oracle database infrastructure, ensuring high availability, scalability, and performance.Key...
-
Oracle Database Specialist
2 days ago
Cape Town, Western Cape, South Africa iLaunch Full timeiLaunch Seeks Oracle DBAEstimated salary: R800,000 - R1,200,000 per annum.Job OverviewiLaunch is a leading Financial Services Client requiring an experienced Oracle DBA to join their dynamic team. The successful candidate will be responsible for designing, maintaining, and optimizing production databases to ensure high performance, availability, and...
-
Oracle Database Architect
4 weeks ago
Cape Town, Western Cape, South Africa iLaunch Full timeAbout iLaunchiLaunch is a leading Financial Services Client seeking a skilled Oracle DBA to join their dynamic team.Job SummaryThis role involves designing, maintaining, and optimising production databases to ensure high performance, availability, and integrity. The successful candidate will have at least 2 years of experience in a similar role and possess a...
-
Oracle Database Specialist
1 month ago
Cape Town, Western Cape, South Africa iLaunch Full timeJob OverviewiLaunch, a leading Financial Services Client in Cape Town, is seeking an experienced Oracle DBA to join their dynamic team.About the RoleThe successful candidate will be responsible for designing, maintaining, and optimising production databases to ensure high performance, availability, and integrity. Key responsibilities include handling...
-
Database Administrator
7 months ago
Cape Town, South Africa Job Crystal Full timeREQUIREMENTS Ingres Database Admin Ingres Database enhancements Unix Linux Intermediate knowledge: Oracle Exadata administration backup/recovery using RMAN PL/SQL coding background logical and physical data models partitioning Knowledge of Oracle RAC, Cluster Resource software, and Oracle 12C features DevOps Experience Experience with Application servers...
-
Dataops Database Administrator
4 days ago
Cape Town, South Africa F & G Sourcing Specialist Full timeAn exciting opportunity is available for **IT Professional** that can administrate, configure, monitor and maintain a Database environment. The opportunity available is known as a **DataOps Database Administrator** and is based in Bellville, Cape Town. **Salary**: R360 000 p/a (incl. benefits) **Requirements**: - Matric - Tertiary qualification in IT -...
-
Senior Oracle Database Specialist
2 weeks ago
Cape Town, Western Cape, South Africa iLaunch Full timeJob Title: Senior Oracle Database SpecialistLocation: Cape Town, South AfricaAbout iLaunch:iLaunch is a dynamic and innovative company that values technology and expertise. We are seeking a highly skilled Oracle DBA to join our team and contribute to the success of our organization.Estimated Salary: R800,000 - R1,200,000 per annumKey Responsibilities:Design,...
-
Oracle Dba
3 days ago
Cape Town, South Africa Capital Edge Recruitment Full time**The Role** As an Oracle DBA you will be expected to install Oracle software when required. Creating Oracle databases will also be a requirement. Performing upgrades of the database and software to new release levels. Other daily functions can include starting up and shutting down databases. Database storage structures will also need to be managed. Users...
-
Ingres Database Administrator
7 months ago
Cape Town, South Africa Capital Edge Recruitment Full timeJoin a leading IT Managed Services Company, as an Ingres Database Administrator. We’re seeking a talented professional to play a pivotal role in supporting and enhancing our client’s database environment. **The Role**: **Your responsibilities will include**: - Supporting the operation of Ingres database instances, implementing minor enhancements, and...
-
Dataops Database Administrator
3 days ago
Cape Town, South Africa Boardroom Appointments Full time**Key purpose**: **Duties and responsibilities**: - Documentation of processes - Database installs and DR environment configuration - Database patching and upgrades as well as backups and restores - Implementation of database monitoring utilities - Database performance investigations - Structural changes and deployment of database objects - User...
-
Senior Oracle PL/SQL Database Architect
4 weeks ago
Cape Town, Western Cape, South Africa Communicate Recruitment Full timeJob Description:We are seeking an experienced Oracle PL/SQL Back End Developer to join our team at Communicate Recruitment. This is a unique opportunity for a skilled professional to work with our clients and contribute to the development of innovative solutions.About Us:Communicate Recruitment is a leading recruitment agency specializing in placing top...
-
Database Architect
1 month ago
Cape Town, Western Cape, South Africa Recru-it Full time**Recru-it** is seeking a highly skilled Oracle Database Administrator to join our team. As an experienced professional in database administration, you will play a crucial role in ensuring the smooth operation and scalability of our database systems.About the Role:We are offering a competitive salary of $120,000 per annum for this exciting opportunity. The...
-
SQLserver and Oracle Database Administrator
7 months ago
Cape Town, South Africa Red Wizardry Full timeWe are looking for a mid level SQL Server and Oracle DBA's for a contract position - proven DBA skills - good communication skills - a clean criminal record **Job Type**: Contract Contract length: 12 months **Salary**: R200.00 - R400.00 per hour
-
Oracle Dba
1 month ago
Cape Town, South Africa iLaunch Full timeApplication database request handling Oracle user access control and review. Perform database backups Implement and maintain Oracle database user roles and privileges Database backup and recovery process implementation and monitoring. DDL creation for database object manipulation using basic SQL, PL/SQL scripts SQL procedures Matric Degree or Diploma in the...
-
Senior Oracle Audit Vault Specialist
4 months ago
Cape Town, South Africa Excellenta Full time**Key Responsibilities**: - **Oracle Audit Vault Management**: - Design, implement, and maintain Oracle Vault solutions to secure sensitive data. - Develop and enforce policies for database encryption, user access, and data masking within Oracle Vault. - Monitor and audit Oracle Vault activities to ensure compliance with security policies and standards. -...
-
Senior Database Administrator
4 months ago
Cape Town, South Africa BDR Group Full time**About the Company** BDR Group are a successful, family owned technology business founded over 30 years ago. We sell the latest cutting edge technology into businesses that enable our clients to securely and effectively communicate. Our services often play a critical part in our client’s operations, such as taking card payments and powering essential...
-
Senior SQL Database Administrator
7 months ago
Cape Town, South Africa Capital Edge Recruitment Full timeJoin an international IT MSP as a Senior SQL Database Administrator on a 6 Months fixed-term contract. Be a key player in their team, delivering SQL database support and project services remotely to multiple customers in adherence to SLAs and KPIs. **Responsibilities**: - Provide incident management, diagnosis, and resolution. - Understand and proactively...
-
Enterprise Database Specialist
2 weeks ago
Cape Town, Western Cape, South Africa Recru-it Full timeJob Title: Enterprise Database SpecialistAbout the Role:We are seeking an experienced Enterprise Database Specialist to join our team at Recru-it. As an Enterprise Database Specialist, you will be responsible for designing, implementing, and managing large-scale databases that meet the evolving needs of our business.Key Responsibilities:Design and implement...
-
Database Systems Architect
2 weeks ago
Cape Town, Western Cape, South Africa Recru-it Full timeJob Description: Database Systems ArchitectAbout the Company:We are Recru-it, a leading provider of innovative solutions to complex business problems. We are seeking a highly skilled Database Systems Architect to join our team and help us design and implement cutting-edge database systems that drive business success.Key Responsibilities:Design and implement...