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
– Exposure to Infrastructure Security related technologies.
– Understanding of Project management methodologies
– Relevant infrastructure management systems knowledge
– Experience designing, integrating and managing complex database solutions
– Knowledge of client-server networking
– Knowledge and exposure to relational database systems
– Ability to provide technical system solutions, determine overall design direction and provide hardware recommendations for complex technical issues
– Experience planning and developing support processes and adhering to best practices
– Strong written and oral communication skills, and the ability to effectively communicate with technical and non-technical audiences
– Ability to quickly comprehend the functions and capabilities of new technologies
– Initiative and Problem-Solving ability in terms of Oracle software and its infrastructure
Analytical Thinking competency in terms of Oracle software and its infrastructure
– Pre-emptive/Proactive approach to Oracle infrastructure and builds
– Ability to deal well with other team members i.e. across OS, storage, backup and recovery, security, scheduling and network teams.
– 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
– 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.
– 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 (140+ custom Client 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.
– It is not just a infrastructure role where OS and DB uptime is maintained, with the odd refresh taking place
Details of the environment:
– 60 databases in TOTAL (3-4 dev/tst/uat databases for each production database.)
– 110+ TB data warehouse running version 12.2
– A 7+ TB RMS / Retek on version 11.2
– 5+ 7 TB planning system databases running versions 11.1 and 11.2
– 2.5 TB RAC 2 node cluster running version 12.1
– A JDA database at 1 TB running version 12.2
– 6 Scheduling databases running version 11.1/11.2, small at