Database Administrator

Description:

Technical Skills:

* Cloud Services (ideally Azure) experience is essential – including Azure Data Factory and Azure DevOps

* Excellent performance tuning skills (experience of Query Tuning, Indexing, Locking etc.)

* Strong T-SQL Experience (creating / administrating stored procedures, scripts, functions, triggers and other objects)

* Experience in the manipulation, transformation, and exploration of large multi-dimensional datasets

* Experience in database installation, backup, restore and maintenance

* BSC or equivalent in a software engineering / DB discipline and / or Professional qualifications appropriate to DB engineering roles is desirable.

* Experience of large transactional databases (100GB+)

* Excellent knowledge of the SQL Database Engine

* Experience of database release / upgrades with product releases

* Extensive experience of working with Microsoft SQL Server 2005/2008/2012/2014

* Data Warehouse development, ETL and transformation into conformed design

* Knowledge of SSIS packages

* Excellent experience and knowledge of the Microsoft stack

* Understanding of relational database design & dimensional Data-modelling

* Some experience of using Visual Studio

* Knowledge of C# and .Net framework desirable

* Knowledge of NOSQL / Document DBs advantageous

* Knowledge of SSRS reports advantageous but not essential

* Knowledge of 3rd party toolkits e.g. RedGate desirable but not essential

* Experience of Source Control (BitBucket/Kiln / Mercurial)

* Strong SQL Skills (SQL server 2012/2016, T-SQL) and development skills in T-SQL, writing scripts, Log Shipping, producing reports (SSRS), performance tuning, automated back-ups, security

* Any experience with Bespoke Software Solutions, ITIL, Agile, Jira and ISO 27001 will be advantageous but not essential

* Domain or Product expertise in IT Healthcare would be advantageous but not essential