Oracle Database Administrator

1 month ago


Cape Town City Centre, South Africa Jobted ZA C2 Full time

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



  • Cape Town, South Africa Recru-it Full time

    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...


  • Cape Town, Western Cape, South Africa Recru-it Full time

    Job 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...


  • Cape Town, Western Cape, South Africa iLaunch Full time

    iLaunch 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...


  • Cape Town, Western Cape, South Africa iLaunch Full time

    About 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...


  • Cape Town, Western Cape, South Africa iLaunch Full time

    Job 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 time

    REQUIREMENTS 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...


  • Cape Town, South Africa F & G Sourcing Specialist Full time

    An 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 -...


  • Cape Town, Western Cape, South Africa iLaunch Full time

    Job 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

    5 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...


  • Cape Town, South Africa Capital Edge Recruitment Full time

    Join 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...


  • 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...


  • Cape Town, Western Cape, South Africa Communicate Recruitment Full time

    Job 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...


  • Cape Town, South Africa Red Wizardry Full time

    We 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

    2 months ago


    Cape Town, South Africa iLaunch Full time

    Application 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...

  • Database Administrator

    13 hours ago


    Cape Town, South Africa NETWORK IT BRUMA Full time

    **Qualifications & Experience**: - Degree/Diploma - At least 4 years working experience - Database design, documentation, and coding - ** Databases**: - PostgreSQL - Essential Expert Level - MySQL some experience required - NoSQL (Mongo or similar) - MSQL and Oracle (not required) - Cloud deployments/DBs (Amazon) - Understanding of Microservices...


  • Cape Town City Centre, South Africa Jobted ZA C2 Full time

    Our Client a Global, Tech firm is seeking a Senior Specialist Analyst Developer/ Senior OpenText ECM for Oracle EBS Specialist to join their team in Cape town (Onsite) on a contract basis. - Provide Specialist troubleshooting and configuration assistance for the Oracle EBS-to-Extended ECM integration. - Liaison with Oracle EBS System Administrators where...

  • Database Developer

    1 month ago


    Cape Town City Centre, South Africa Jobted ZA C2 Full time

    You will design and implement scalable database architectures to support mission-critical applications. While developing advanced database objects and queries to optimize performance Skills & experience: Minimum 5+ years of hands-on experience as a database developer Expertise in SQL and one or more database management systems (e.g. MySQL, PostgreSQL,...


  • 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. -...


  • Cape Town City Centre, South Africa Jobted ZA C2 Full time

    Minimum 5+ years of experience as a back-end developer Strong expertise in database and systems design Proficiency in Oracle PL/SQL Experience working with JSON and XML datasets and schema configurations A solid understanding of Git for version control The ability to build reusable, scalable code Contact Selandea McGuinness on