のポスト: エンジニアリング に ミルトン・キーンズ | Posted: |
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