Oracle DBA CONTRACT

Ref No. CLGJD008
Location Cape Town, South Africa
Start date ASAP
Job type Contract (12 months)
Job Status Closed
You can not apply for this job as its status is Closed.
  • Share:

Introduction

This is not just an infrastructure role where OS and DB uptime is maintained, with the odd refresh taking place - your will do analysis and offer solutions.

Important

Oracle DBA

The Job

  • Designing, integrating and managing complex database solutions
  • Client-server networking
  • Knowledge and exposure to relational database systems
  • Provide technical system solutions, determine overall design direction and provide hardware recommendations for complex technical issues
  • Planning and developing support processes and adhering to best practices
  • Problem identification and problem solving in terms of Oracle software and its infrastructure
  • Oracle infrastructure and builds
  • Critical batch standby needed, being able to understand and provide root cause analysis and provide working solutions within the hour of a call out is expected, reporting and other system OLAs need to be maintained.
  • 24/7 availability during standby, every second week
  • Summarizing per database application, value that can be added by making suggestions to developers and or vendors regarding their application, their code/SQL etc.
  • Logging of good quality SRs with Oracle Support, being able to ensure viable solutions are forthcoming or able to find workarounds where software is no longer supported
  • Daily tasks include root cause analysis of any developer SQL and or PL/SQL coding issues
  • Daily tasks include root cause analysis of any vendor application issues with regard to the databases
  • Understanding of full hardware and software stack from OS to UNIX to network to storage to be able to do root cause analysis as to why batch or end user reports or backups etc. are not optimal.
  • SQL, PL/SQL Shell scripting and Sql*plus fluency to automate and report
  • ASM and GI command usage related to use of srvctl. crsctl and associated commands.
  • Being able to understand and respond to database alerts related to space, performance, backups, triggers, procedures, log files, trace file contents, deadlocks, concurrency issues etc.
  • Space analysis/abuse per database, per schema, per tablespace etc.
  • Usage of expdp and impdp for refreshes and backups for small databases.
  • RMAN to duplicate/clone/backup/recover databases, EMC disk clones/snaps are also in use
  • Installations and upgrades are done periodically, thus competency is required
  • Oracle Diagnostic and Tuning Packs are available to production databases.
  • Partitioning, Compression, RAC, Diagnostics and Tuning Packs are the Enterprise Options in use.

Key skills:

  • 3-year IT or NQF aligned qualification
  • 5-8 years relevant experience working in an Oracle Database Administration role
  • Hands-on Implementation and Support experience in a variety of infrastructure services and solutions
  • Experience designing, integrating and managing complex database solutions
  • Analytical Thinking competency in terms of Oracle software and its infrastructure
  • Root cause analysis of any developer SQL and or PL/SQL coding issues
  • A good Oracle database architecture knowledge is expected relating to at least: memory pools, online logs, data files, redo logs, partitioning, logging and no logging operations, parallel ddl, parallel dml, parallel query, sql tuning, sql hints addition/removal, explain plan evaluation etc.
  • SQL, PL/SQL Shell scripting and Sql*plus fluency to automate and report

Networkers acts as an employment agency for permanent recruitment and employment business for the supply of temporary workers and is part of Gattaca Plc.

Gattaca Plc provides support services to Networkers and may assist with processing your application.

You can not apply for this job as its status is Closed.
  • Share:

Related jobs

 

Jacqui Dill
manages this role


 

Related articles

What are you looking for most from your next employment or assignment?

Back to top