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 of 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
#J-18808-Ljbffr