Database Administartor

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