Senior Database Administrator - Woodmead, South Africa - Asource
Description
Grade 12Diploma or Degree in IT administration, MCSE, MCDBA SQL and Database design, etc.
Minimum of 5+ years in database administration in advanced stage with proven track record.
Must have knowledge of:
Experience with Windows Server 2016 upwards and SQL 2014, 2017, 2019 and the proper disk configuration and layout to support large, scalable SQL Serverenvironments
Data warehousing and transactional flows of data from different systems
Microsoft SSRS, SSIS, SSAS
Virtual Server Experience, Azure or AWS experience a bonus
Roles and Responsibilities:
Database Administration
Provide administration of database systems including installation, upgrades, configuration, migration, consolidation, monitoring, tuning, and maintenance
Testing new versions of the database management system (DBMS)
Set up, maintain reporting and data integration processes using SSRS, SSIS and SSAS
Set and administer standards for overall organization's SQL Server relational database structure / architecture
Oversee all data generated, monitor server transaction speeds, and look for any service degradation in speeds due to SQL fragmentation or lack on maintenance
Oversee all SQL instances and databases
Patching and updating Software
Implement database backup, disaster recovery and high-availability solutions
Ensure the companies records are archived and secure and keep the companies database maintenance plan intact with the company records
Maintain data standards, including adherence to the Data Protection Act
Write database documentation, including data standards, procedures and definitions for the data dictionary (metadata)
Implement and maintain a working high availability environment with all SQL instances
Job Types:
Full-time, Permanent
Salary:
R20, R60,000.00 per month
Education:
- Diploma (required)
More jobs from Asource
-
Compliance Manager
Sandton, South Africa - 1 week ago
-
Accounts Administrator
Midrand, South Africa - 1 week ago
-
Finance Assistant
Durban, South Africa - 1 week ago
-
Claims Negotiator
Randburg, South Africa - 5 days ago
-
Azure Integration Specialist
Pretoria, South Africa - 1 week ago
-
Warehouse Manager
Sandton, South Africa - 1 day ago