SQL Server DBA - Remote

Our Client, working closely with the NHS requires a skilled SQL DBA to join the team on a permanent basis. The role is fully remote and previous NHS experience is desirable.The role is primarily as a SQL DBA, but there is an element of providing 2nd and 3rd line support, dealing with client queries, running data checks, making sure the systems are running efficiently and no errors what so ever…Duties and responsibilitiesProvide technical guidance and support to your colleagues ensuring DB products are resolved, designed, developed and tested according to established best practice principlesWork with a team of Database developers to ensure projects are delivered in a timely fashionMonitor system''s health and performanceEnsure high levels of performance, availability, sustainability and securityAnalyse, solve, and correct issues in real timeEnsure reviews are conducted on a regular basis to improve / enhance the database, and that the improvements are consistent with the departmental guidelines (working closely with other members of the DB team). Where no formal guidelines exist, work with peers to formulate and enforce such guidelines.Triage assigned support incidents. Ensure that work on defect resolution does not impact on agreed product deliverables.Database Troubleshooting and MaintenanceMaintain data integrity and security (manage roles and permissions of database users).Generate traces, execution plans, identify performance issues, deadlocks/contention and resolve them.Keep abreast of technology trends and how they apply to your area. Put forward suggestions for improvement to processes or tools where applicable.Develop a level of product expertise across the solution architecture.Skills and experienceBSc or equivalent in a software engineering / DB discipline and / or Professional qualifications appropriate to DB engineering roles.Experience of large transactional databases (100GB+)Excellent knowledge of the SQL Database EngineExcellent performance tuning skills (experience of Query Tuning, Indexing, Locking etc).Excellent communication skills - both to a technical and non-technical audience.Experience in engaging at a commercial level with customers both technical and nontechnical.Experience of database release / upgrades with product releasesExtensive experience of working with Microsoft SQL Server 2005/2008/2012/2014Strong 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 maintenanceData Warehouse development, ETL and transformation into conformed designKnowledge of SSIS packagesExcellent experience and knowledge of the Microsoft stackUnderstanding of relational database design and dimensional Data-modellingSome experience of using Visual StudioKnowledge of C# and .Net framework desirableKnowledge of NOSQL / Document DBs advantageousKnowledge of SSRS reports advantageous but not essentialKnowledge of 3rd party toolkits e.g. RedGate desirableExperience 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, securityUnderstanding of formal DB development and administration methodologies.Cloud Services (Azure) experience would be advantageous but not essential.Any experience with Bespoke Software Solutions, ITIL, Agile and ISO 27001 will be advantageous but not necessary.Domain or Product expertise in IT Healthcare would be advantageous but not essential.If this role sounds of interest, please don’t hesitate to ..... full job details .....