REF # 2002223
Views:

234 total views, 18 views today

Location:
Cape Town

Oracle Database Administrator (Ref: ITSCLD0003) (Contract)

Enquire / Apply

ENVIRONMENT:

Research, create and execute tech-based solutions as the next Oracle Database Administrator sought by a leading retail company. You will require a 3-year IT / NQF aligned qualification, at least 5 years in a similar role, SQL, PL/SQL Shell scripting and SQL*plus and understand the full hardware and software stack from OS to UNIX to network to storage to be able to do root cause analysis. Please note this is a 12-month contract.

 

DUTIES:

Identify new industry trends, products, technologies, practices and processes by selecting and using appropriate sources of information.

Understand and keep abreast of the IT technical infrastructure by using the appropriate internal sources of information.

Use applicable industry knowledge bases to find common causes and resolutions of technical problems and apply this knowledge.

Maintain and analyse internal records of problem causes and resolutions, identify recurring problems and modify the resolution actions to prevent recurrence.

Provide input into technical direction decisions in the area of expertise.

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

Build solutions according to the solution definitions.

Ensure that solutions are not designed and built in isolation.

Ensure correct protocols, tools and middleware solutions are correctly used.

Ensure that solutions are built using the agreed tools, frameworks, processes and architectural principles that apply across all departments.

Ensure that solutions are built generically wherever possible.

Communicate progress, status, events, planned activities, issues to all relevant parties.

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

Establish and maintain good working relationships with other departments structures.

Ensure that sustainability and impact of the administration of technical solutions are understood and taken into account when technical solutions are proposed.

Perform the administration of technical solutions according to the agreed plans and processes and propose continuous enhancements to these processes where applicable.

Manage own workload and deliver projects and operating plans within approved budgets.

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.

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

 

REQUIREMENTS:

Qualifications –

3-Year IT or NQF aligned qualification.

 

Experience/Skills –

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.

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.

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 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 an infrastructure role where OS and DB uptime is maintained, with the odd refresh taking place.

24/7 availability during standby, every second week.

 

ATTRIBUTES:

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.

 

While we would really like to respond to every application, should you not be contacted for this position within 10 working days please consider your application unsuccessful.

 

COMMENTS:

When applying for jobs, ensure that you have the minimum job requirements. Only SA Citizens will be considered for this role. If you are not in the mentioned location of any of the jobs, please note your relocation plans in all applications for jobs and correspondence. Please e-mail a word copy of your CV to taryn@datafin.com and mention the reference numbers of the jobs.

Tags
Contract

Apply for this vacancy:

Attach CV