Minimum skills and knowledge requiredDiploma or Degree in IT administration, MCSE, MCDBA SQL and database design, etc.Minimum of 5+ years in database administrationExperience with Windows Server 2016 upwards and SQL 2014, 2017, 2019 and the proper disk configuration and layout to support large, scalable SQL Server environmentsData warehousing and transactional flows of data from different systemsMicrosoft SSRS, SSIS, SSASVirtual Server experience, Azure or AWS experience a bonusKey performance areasDatabase AdministrationProvide administration of database systems including installation, upgrades, configuration, migration, consolidation, monitoring, tuning, and maintenanceTesting new versions of the database management system (DBMS)Set up, maintain reporting and data integration processes using SSRS, SSIS and SSASSet and administer standards for overall organization's SQL Server relational database structure / architectureOversee all data generated, monitor server transaction speeds, and look for any service degradation in speeds due to SQL fragmentation or lack of maintenanceOversee all SQL instances and databasesPatching and updating SoftwareImplement database backup, disaster recovery and high-availability solutionsEnsure the company's records are archived and secure and keep the company's database maintenance plan intact with the company recordsMaintain data standards, including adherence to the Data Protection ActWrite database documentation, including data standards, procedures and definitions for the data dictionary (metadata)Implement and maintain a working high availability environment with all SQL instancesDatabase Reporting / dashboards / Build and maintain the company dashboardsEnsure all company reports are accurate and runningDevelop custom database objects (T-SQL scripts, stored procedures, tables, views, functions)Hybrid role - two days in office
#J-18808-Ljbffr