You will be responsible to support end user on SQL Database used in the company environment. Support data analysis and troubleshooting for issues raised from the applications.Responsibilities:Operating Oracle and SQL database platform and will actively troubleshoot any issues impacting the environments as well as analyse error logsAnalysing of queries and advise on efficiency and improvementsIdentify and resolve database locks and lack of statistics, resolve data structure issues, i.e. invalid objects, tables, partitions, constraints and perform deploy patches as and when required.Create and maintain SOP'sCollaborating with dbas, developers, vendors and professionals to deliver quality service.Performing as subject matter expert for database implementationsAutomation of operational processes as needed, with accuracy and in compliance with our security requirementsProvide service delivery in a timely and efficient mannerEnsure that there is continuous support providedTo work with Incident Management, other support groups and vendors to provide seamless support to customersParticipate in projects work as assignedProvide inputs to the Team Leader on status of activities as and when requiredProvide daily system check report using the provided templateRequirements:Grade 12Formal IT qualification (National Diploma/Certificate, CompTia, Microsoft or similar certification) or must be currently studying towards completing a Degree/Diploma or Certificate in ITITIL v3 FoundationMicrosoft Azure and Office 365Own car and Driver’s License essentialMCSA: SQL Servers 2012 onwardsOracle DBA support 11G onwards2 -3 years’ experience to MSSQL and PLSQLSound knowledge of ITIL and SDLCStrong technical aptitude and ability to research and solve complex issues independentlyExposure to Oracle version 11G and MSSQL from 2012 onwardsExperience in MSSQL manager, performing SQL queries and log managementExperience with Oracle RMAN and Oracle Enterprise ManagerPerformance and tuning experience (Tools: ADDM / AWR and Oracle advisors)Experience with scripting and automation (Shell / Bash / PowerShell / PL / SQL / SQL / DBMS jobs)https://www.manpower.co.za/job-listings
