Database Administartor
Milton Keynes
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