Research, create, deliver, manage and administer technology-based solutions to enable the business to achieve its operational and strategic objectives. This is a 12 month contract position based at the Head Office in Cape Town City Centre.
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 technologies.Understanding 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 practicesStrong written and oral communication skills, and the ability to effectively communicate with technical and non-technical audiencesAbility to quickly comprehend the functions and capabilities of new technologiesInitiative and Problem-Solving ability in terms of Oracle software and its infrastructureAnalytical Thinking competency in terms of Oracle software and its infrastructurePre-emptive/Proactive approach to Oracle infrastructure and buildsAbility 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 weekSummarizing 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 supportedDaily tasks include root cause analysis of any developer SQL and or PL/SQL coding issuesDaily tasks include root cause analysis of any vendor application issues with regard to the databasesA 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 reportASM and GI command usage related to use of srvctl. crsctl and associated commands.Being able to understand and respond to database alerts (140+ custom Woolworths 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 useInstallations and upgrades are done periodically, thus competency is requiredOracle 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.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
Identify new industry trends, products, technologies, practices and processes by selecting and using appropriate sources of informationUnderstand and keep abreast of the Woolworths 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 ITS 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 ITSEnsure that solutions are built generically wherever possibleCommunicate progress, status, events, planned activities, 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 ITS 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
As a proud South African brand, Woolworths is committed to transformation. Meeting our employment equity goals will be taken into account in our recruitment decisions.