About the job SQL Database AdministratorExperience as a MS SQL Server database administrator.Expertise with performance Tuning and T-SQL Optimisation.Experience with busy databases handling large volumes of transactions per day.Strong interpersonal skills and the ability to work with a broad range of stakeholders up to C-levelA natural problem solver with excellent organisation and prioritisation skillsExperience of decision making in a pressurised environmentExcellent verbal and written communication skillsUniversity degree or equivalent from a knowledge & experience perspectiveNice to have:Experience in Microsoft Azure would be considered a strong assetExperience with any of the following considered an asset; Azure SQL, Azure Data Factory, MongoDB, MySQL, Terraform, Databricks, Azure Data Lake StorageResponsibilities:Working within a central DBA team whilst interfacing with an assigned dev squadTraditional MS SQL Server administration tasks such as backups, availability group maintenance, version upgrades, connectivity issues, infrastructure management etcPre-emptive T-SQL optimisation, identification and tuning of high consuming queries achieved through in-depth query performance monitoringPartitioning and database size managementT-SQL code review for an assigned dev squad as well as supporting developers with efficient database designDeveloping and maintaining archiving strategies, data extraction and data insertion pipelines using T-SQL and/or Azure Data FactoryCode and infrastructure automation using tools such as PowerShell, Terraform and Azure DevOpsMigrating to and creating managed database services such as Azure SQL Database and Azure SQL Managed InstancesParticipating in an on-call support roster
#J-18808-Ljbffr