We currently have a 12 Month Contract role available for a Senior Oracle Database Administrator based in Cape Town.
Research, create, deliver, manage and administer technology-based solutions to enable the business to achieve its operational and strategic objectives.
Identify new industry trends, products, technologies, practices and processes by selecting and using appropriate sources of informationUnderstand and keep abreast of the IT technical infrastructure by using the appropriate internal sources of informationUse applicable industry knowledge bases to find common causes and resolutions of technical problems and apply this knowledgeMaintain and analyse internal records of problem causes and resolutions, identify recurring problems and modify the resolution actions to prevent recurrenceProvide input into IT technical direction decisions in the area of expertiseMaximise the use and re-use of infrastructure that is already in place by determining to what extent parts of solutions already exist when new solutions are definedBuild solutions according to the solution definitionsEnsure that solutions are not designed and built in isolationEnsure correct protocols, tools and middleware solutions are correctly usedEnsure that solutions are built using the agreed tools, frameworks, processes and architectural principles that apply across all of ITEnsure that solutions are built generically wherever possibleCommunicate progress, status, events, planned activities and issues to all relevant partiesEnsure that team members, management and other staff members working in related areas of technical concern are informed on all relevant technical decisions, discoveries, practices, processes, knowledge and informationEstablish and maintain good working relationships with other IT structuresEnsure that sustainability and impact of the administration of technical solutions are understood and taken into account when technical solutions are proposedPerform the administration of technical solutions according to the agreed plans and processes and propose continuous enhancements to these processes where applicableManage own workload and deliver projects and operating plans within approved budgets
TECHNICAL AND FUNCTIONAL3-year IT or NQF aligned qualification5-8 years relevant experience working in an Oracle Database Administration roleHands-on Implementation and Support experience in a variety of infrastructure services and solutionsExposure to Infrastructure Security related technologiesUnderstanding of Project management methodologiesRelevant infrastructure management systems knowledgeExperience designing, integrating and managing complex database solutionsKnowledge of client-server networkingKnowledge and exposure to relational database systemsAbility to provide technical system solutions, determine overall design direction and provide hardware recommendations for complex technical issuesExperience planning and developing support processes and adhering to best practicesCritical 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 maintained24/7 availability during standby, every second weekSummarizing per database application, value that can be added by making suggestions to Developers and or Vendors regarding their application and code/SQL etcLogging with Oracle Support, being able to ensure viable solutions are forthcoming or able to find workarounds where software is no longer supportedDaily tasks include root cause analysis of any developer SQL and or PL/SQL coding issues and Vendor application issues with regard to databasesGood 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, etcUnderstanding 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 optimalSQL, PL/SQL Shell scripting and Sql*plus fluency to automate and reportASM and GI command usage related to use of srvctl. crsctl and associated commandsBeing able to understand and respond to database alerts (140+ custom alerts) related to space, performance, backups, triggers, procedures, log files, trace file contents, deadlocks, concurrency issues, etcSpace analysis/abuse per database, per schema, per tablespace, etcUsage of expdp and impdp for refreshes and backups for small databasesRMAN to duplicate/clone/backup/recover databases, EMC disk clones/snapsInstallations and upgrades are done periodically, thus competency is requiredOracle Diagnostic and Tuning Packs are available to production databasesPartitioning, Compression, RAC, Diagnostics and Tuning Packs are the Enterprise Options in use
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.2A 7+ TB RMS / Retek on version 11.25+ 7 TB planning system databases running versions 11.1 and 11.22.5 TB RAC 2 node cluster running version 12.1A JDA database at 1 TB running version 12.26 Scheduling databases running version 11.1/11.2, small at
Please note that only applicable candidates will be contacted.