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
