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, MySQL, 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