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 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) Hybrid role - two days in office