Job Reference: CPT002484-AK-1You will be responsible for supporting end users on SQL Database used in the company environment, including data analysis and troubleshooting for issues raised from the applications.Duties & ResponsibilitiesResponsibilities:Operating Oracle and SQL database platforms and actively troubleshooting any issues impacting the environments, as well as analyzing error logs.Analyzing queries and advising on efficiency 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 needed.Creating and maintaining SOPs.Collaborating with DBAs, developers, vendors, and professionals to deliver quality service.Acting 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.RequirementsGrade 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 & RemunerationAnnually
#J-18808-Ljbffr