SQL and Oracle Microsoft DBA

Reference : CPT -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