Description:
You will be responsible for the operational support, maintenance, testing and certain project activities for our client’s business application environment. The position combines analysis responsibility with solid hands-on technical expertise and management of the SQL and reporting environments. The Database Administrator will be called upon to assist the support team with queries as and when required. The database administrator is also responsible for guiding the application team and vendors to ensure adherence to service levels, end-user satisfaction, and continuous service improvement along with process adherence and applications technical management on a day-to-day basis.
Qualifications & Experience
Tech, B.Com or B.Sc. Computer Science or Information Systems or B.Eng (Advantageous) Knowledge of Project Management (PMBOK, Prince II, Agile) principles would be advantageous Experience of both the theoretical and practical aspects of applications management and database administration as well as report writing Direct work experience as a database administrator (5 years) In-depth knowledge of the MS-SQL platform and Postgre Knowledge of Linux advantageous Good understanding of replication and availability groups (Always-on) Good understanding of SQL and report writing Self-managed and driven individual with a large focus on solution delivery Great Communication Skills Efficiency, delivering accurate results Ability to analyse and troubleshoot environments highlighting poor performance Ability to report on environmental health, maintenance activities and performance of databases Strong Microsoft SQL Server knowledge including licensing Database maintenance including job management, space management, automated backups and automated restores Database availability including process management, index maintenance Database security including surface area management, database integrity and user access control Maintain backups and restore databases Maintain database access Database restore, deployment and structural changes Database monitoring using a variety of tools Implement data change requests Performance tuning Assist with database errors Good understanding of T-SQL Responsible for keeping the database software up to date (Patch Management) Responsible for maintaining SQL security access for staff and vendors. (Using the Principle of Least Privilege)Technologies
Integration Services (SSIS) SQL Server Reporting Services (SSRS) SQL Server Analysis Services – Cubes (SSAS) SQL Availability Groups, Mirroring, replication, and log shipping Management of files and file groups, table archiving and partitioning S...
12 Aug 2022;
from:
gumtree.co.za