Description

Position: SQL DBA

Suitable for: SQL Database Administrator or SQL DBA ideally with min 3 years SQL Server experience

Location: Hybird (Milton Keynes once or twice a month)

Salary: to £45k + bens

Our client is looking to recruit a SQL DBA. They are an innovative, highly successful organisation supplying leading edge technology to the NHS. The role of the SQL DBA will require working in a local Operations Team interpreting requirements, providing 3rd line technical support for the deployment and release management functions and provide 2nd & 3rd line support for bug fixing and optimising existing software and hardware within the current product set.

Essential Experience / Skills / Attributes :
• Min 3 years' experience as SQL DBA or SQL Database Administrator
• Experience of large transactional databases (100GB+)
• Excellent knowledge of the SQL Database Engine
• Excellent 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 non-technical
• Experience of database release / upgrades with product releases
• Extensive experience of working with Microsoft SQL Server 2005/2008/2012/2014
• 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
• 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
• 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
• Understanding of formal DB development and administration methodologies

Desirable:
• 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
• 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
• BSc or equivalent in a software engineering / DB discipline and / or professional qualifications appropriate to DB engineering roles (desirable)

SQL DBA Responsibilities:
• Provide technical guidance and support to your colleagues ensuring DB products are resolved, designed, developed and tested according to established best practice principles
• Work with a team of Database developers to ensure projects are delivered in a timely fashion
• Monitor system's health and performance
• Ensure high levels of performance, availability, sustainability and security
• Analyse, solve, and correct issues in real time
• Ensure reviews are conducted on a regular basis to improve / enhance the database, and that the improvements are consistent with the departmental guidelines (collaborating 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 Maintenance
• Maintain 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

Full job description is available on request

To apply: Please follow the online application process and upload your CV, in Word format

Please note: You must be eligible to work in the UK for your application to be considered (sorry, our client is unable to offer sponsorship). Due to large numbers of applications, unfortunately we cannot provide detailed feedback to everyone, however, if you wish to find out how your application is progressing, please call or e-mail the office and someone will help you / get back to you.

Educational Requirements

• Bachelors Degree