Contract: Permanent | Location: Woodmead JHB | Work Model: Hybrid
Minimum skills and knowledge required
• Diploma 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
• Experience with Windows Server 2016 upwards and SQL 2014, 2017, 2019 and the proper disk configuration and layout to support large, scalable SQL Server environments
• Data warehousing and transactional flows of data from different systems
• Microsoft SSRS, SSIS, SSAS
• Virtual Server experience, Azure or AWS experience a bonus
Key performance areas
• 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
• Database Reporting / dashboards / Build and maintain the company dashboards
• Ensure all company reports are accurate and running
• Develop custom database objects (T-SQL scripts, stored procedures, tables, views, functions)