Sql database administrator

About the job SQL Database Administrator Experience 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-level A natural problem solver with excellent organisation and prioritisation skills Experience of decision making in a pressurised environment Excellent verbal and written communication skills University degree or equivalent from a knowledge & experience perspective

Nice to have: Experience in Microsoft Azure would be considered a strong asset Experience with any of the following considered an asset; Azure SQL, Azure Data Factory, Mongo DB, My SQL, Terraform, Databricks, Azure Data Lake Storage

Responsibilities: Working within a central DBA team whilst interfacing with an assigned dev squad Traditional MS SQL Server administration tasks such as backups, availability group maintenance, version upgrades, connectivity issues, infrastructure management etc Pre-emptive T-SQL optimisation, identification and tuning of high consuming queries achieved through in-depth query performance monitoring Partitioning and database size management T-SQL code review for an assigned dev squad as well as supporting developers with efficient database design Developing and maintaining archiving strategies, data extraction and data insertion pipelines using T-SQL and/or Azure Data Factory Code and infrastructure automation using tools such as Power Shell, Terraform and Azure Dev Ops Migrating to and creating managed database services such as Azure SQL Database and Azure SQL Managed Instances Participating in an on-call support roster #J-18808-Ljbffr