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 without errors.

Duties and Responsibilities

1. Provide technical guidance and support to your colleagues ensuring DB products are resolved, designed, developed, and tested according to established best practice principles.
2. Work with a team of Database developers to ensure projects are delivered in a timely fashion.
3. Monitor system\'s health and performance.
4. Ensure high levels of performance, availability, sustainability, and security.
5. Analyse, solve, and correct issues in real time.
6. Conduct regular reviews to improve/enhance the database, ensuring improvements are consistent with departmental guidelines.
7. Triage assigned support incidents and ensure defect resolution does not impact agreed product deliverables.
8. Database troubleshooting and maintenance.
9. Maintain data integrity and security (manage roles and permissions of database users).
10. Generate traces, execution plans, identify performance issues, deadlocks/contention, and resolve them.
11. Keep abreast of technology trends and put forward suggestions for improvement to processes or tools where applicable.
12. Develop a level of product expertise across the solution architecture.

Skills and Experience

1. BSc or equivalent in a software engineering/DB discipline and/or professional qualifications appropriate to DB engineering roles.
2. Experience of large transactional databases (100GB+).
3. Excellent knowledge of the SQL Database Engine.
4. Excellent performance tuning skills (experience of Query Tuning, Indexing, Locking etc).
5. Excellent communication skills - both to a technical and non-technical audience.
6. Experience in engaging at a commercial level with customers, both technical and non-technical.
7. Experience of database release/upgrades with product releases.
8. Extensive experience of working with Microsoft SQL Server 2005/2008/2012/2014.
9. Strong T-SQL experience (creating/administrating stored procedures, scripts, functions, triggers, and other objects).
10. Experience in the manipulation, transformation, and exploration of large multi-dimensional datasets.
11. Experience in database installation, backup, restore, and maintenance.
12. Data Warehouse development, ETL and transformation into conformed design.
13. Knowledge of SSIS packages.
14. Excellent experience and knowledge of the Microsoft stack.
15. Understanding of relational database design & dimensional data modeling.
16. Some experience of using Visual Studio.
17. Knowledge of C# and .Net framework desirable.
18. Knowledge of NoSQL/Document DBs advantageous.
19. Knowledge of SSRS reports advantageous but not essential.
20. Knowledge of 3rd party toolkits e.g. RedGate desirable.
21. Experience of Source Control (BitBucket/Kiln/Mercurial).
22. 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 backups, security.
23. Understanding of formal DB development and administration methodologies.
24. Cloud Services (Azure) experience would be advantageous but not essential.
25. Any experience with bespoke software solutions, ITIL, Agile, and ISO 27001 will be advantageous but not necessary.
26. Domain or product expertise in IT Healthcare would be advantageous but not essential.

If this role sounds of interest, please don’t hesitate to apply.