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
