Oracle Database Administrator

2 weeks ago

Cape Town, South Africa Recru-it Full time
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

  • Oracle Database Administrator

    6 days ago

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

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

  • Oracle Database Specialist

    7 days ago

    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 Developer with Oracle Expertise

    2 days ago

    Cape Town, Western Cape, South Africa Capital H Staffing and Advisory Solutions Full time

    Capital H Staffing and Advisory Solutions, a leading recruitment agency, is seeking an experienced Database Developer to join our team. This role offers a competitive salary of R750,000 - R1,200,000 per annum.About the Role:We are looking for a skilled Database Developer with expertise in Oracle PL/SQL development to work on a variety of projects.The ideal...

  • Database Administrator

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

  • Highly Skilled Oracle Database Professional Wanted

    2 weeks ago

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

    We are seeking a highly skilled Oracle Database Administrator to join our team at Recru-it. This role requires strong technical expertise in designing, implementing, and maintaining large-scale databases.About the RoleThis position is responsible for providing strategic leadership and hands-on support for database development, administration, and...

  • Database Architect

    1 week ago

    Cape Town, Western Cape, South Africa Acuity Consultants Full time

    About Acuity ConsultantsWe are a leading consulting firm specializing in digital transformation and technology governance. Our expertise spans robust data architecture, security, and collaboration to drive business growth.Our ClientA top financial services group operating at the forefront of digital innovation, delivering cutting-edge solutions for...

  • Ingres Database Administrator

    6 months ago

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

  • Oracle GoldenGate Specialist

    3 weeks ago

    Cape Town,, South Africa Jobted ZA C2 Full time

    We are seeking a highly skilled Oracle GoldenGate Specialist to join our dynamic team. The ideal candidate will have extensive experience in designing, implementing, and managing Oracle GoldenGate solutions to ensure seamless data replication and integration across various platforms. Key Responsibilities: Design, implement, and manage Oracle GoldenGate...

  • Database Architect

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

  • Oracle Dba

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

  • Oracle PL/SQL Developer

    4 weeks ago

    Cape Town, Western Cape, South Africa CapitalH Full time

    Job Title: Oracle PL/SQL DeveloperJob Summary:CapitalH is seeking an experienced Oracle PL/SQL Developer to join our team. As a key member of our development team, you will be responsible for designing, developing, and implementing Oracle database applications to meet our business needs.Key Responsibilities:Design, develop, and implement Oracle PL/SQL code...

  • Senior Oracle Audit Vault Specialist

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

  • Oracle PL/SQL Developer

    1 month ago

    Cape Town, Western Cape, South Africa Capital H Staffing and Advisory Solutions Full time

    Job Title: Software DeveloperCapital H Staffing and Advisory Solutions is seeking a skilled Oracle PL/SQL Developer to join our team in Kuilsrivier, Western Cape. As a key member of our team, you will be responsible for developing, implementing, and maintaining Oracle database applications to meet our business needs.Key Responsibilities:Design, develop, and...

  • Oracle Development Expert

    3 weeks ago

    Cape Town, Western Cape, South Africa Hire Resolve Full time

    Hire Resolve's Client is seeking a seasoned Oracle PL/SQL Developer to contribute to their team's success. As a key member, you will be responsible for designing and implementing Oracle PL/SQL applications, including creating stored procedures, functions, triggers, and packages. You will collaborate with cross-functional teams to gather requirements, design...

  • Enterprise Oracle PL/SQL Database Architect

    4 days ago

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

    We are seeking a highly skilled Oracle PL/SQL Back End Developer to join our team at Communicate Recruitment.About UsAs a leading recruitment agency in Cape Town, we specialize in matching top talent with exciting career opportunities in the IT sector.Job DescriptionThis is a challenging role that requires a minimum of 5 years of experience as a back-end...

  • Senior Database Administrator

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

  • Oracle PL/SQL Developer with Expertise in Forms and Reports

    2 weeks ago

    Cape Town, Western Cape, South Africa Capital H Staffing and Advisory Solutions Full time

    Capital H Staffing and Advisory Solutions is seeking a skilled Oracle PL/SQL Developer to join their team. With 3-5 years of experience in Oracle Forms and Reports, the ideal candidate will be responsible for developing, implementing, and maintaining Oracle database applications to meet business needs.Key Responsibilities:Design, develop, and test Oracle...

  • Senior Oracle PLSQL Developer Position

    1 month ago

    Cape Town, Western Cape, South Africa Hire Resolve Full time

    Job Title: Senior Oracle PLSQL Developer PositionAbout the Role:Hire Resolve's client is seeking an experienced Oracle PLSQL developer to work on developing and maintaining Oracle PLSQL applications. The ideal candidate will have a strong knowledge of Oracle PLSQL programming language and experience with Oracle database management systems.Key...

  • Database Systems Architect

    3 weeks ago

    Cape Town, Western Cape, South Africa MiX Telematics Full time

    Database Administrator Position OverviewWe are looking for a highly skilled and experienced Database Administrator to join our team of passionate technologists. As a key member of our Data Engineering department, you will be responsible for designing, implementing, and maintaining our cloud-based database systems.Responsibilities:Design and implement...

  • Senior SQL Database Administrator

    6 months ago

    Cape Town, South Africa Capital Edge Recruitment Full time

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