SQL and Oracle Microsoft DBA, Midrand

Reference: CPT002484-AK-1

You will be responsible for supporting end users on SQL Database used in the company environment. Support data analysis and troubleshooting for issues raised from the applications. Duties&Responsibilities

Responsibilities: Operating Oracle and SQL database platform and actively troubleshooting any issues impacting the environments as well as analysing error logs. Analysing queries and advising on efficiency and improvements. Identifying and resolving database locks and lack of statistics, resolving data structure issues, i.e. invalid objects, tables, partitions, constraints, and performing deploy patches as required.Creating and maintaining SOPs. Collaborating with DBAs, developers, vendors, and professionals to deliver quality service. Performing as a subject matter expert for database implementations. Automating operational processes as needed, with accuracy and in compliance with security requirements. Providing service delivery in a timely and efficient manner.Ensuring continuous support is provided. Working with Incident Management, other support groups, and vendors to provide seamless support to customers. Participating in project work as assigned. Providing inputs to the Team Leader on the status of activities as required. Providing daily system check reports using the provided template.Requirements:

Grade 12. Formal IT qualification (National Diploma/Certificate, CompTIA, Microsoft or similar certification) or currently studying towards completing a Degree/Diploma or Certificate in IT. ITIL v3 Foundation. Microsoft Azure and Office 365. Own car and Driver’s License essential. MCSA: SQL Servers 2012 onwards.Oracle DBA support 11G onwards. 2-3 years’ experience with MSSQL and PLSQL. Sound knowledge of ITIL and SDLC. Strong technical aptitude and ability to research and solve complex issues independently. Exposure to Oracle version 11G and MSSQL from 2012 onwards. Experience in MSSQL manager, performing SQL queries and log management.Experience with Oracle RMAN and Oracle Enterprise Manager. Performance and tuning experience (Tools: ADDM / AWR and Oracle advisors). Experience with scripting and automation (Shell / Bash / PowerShell / PL / SQL / SQL / DBMS jobs). Please note only shortlisted candidates will be contacted. Package&Remuneration

Annually

#J-18808-Ljbffr