Senior SQL Developer


Premium Job From Real Staffing

Recruiter

Real Staffing

Listed on

1st February 2018

Location

Buckingham

Salary/Rate

Upto £45000

Type

Permanent

Start Date

ASAP

This job has now expired please search on the home page to find live IT Jobs.

A software company that provides clinical software solutions to the healthcare sector is seeking a permanent Senior SQP DB Developer with a minimum of 4+ years commercial experience to help undertake SQL DB development and maintenance work for its core product and work closely with the development teams.

The role involves developing, maintaining, troubleshooting & optimising the SQL server instances and will provide an opportunity to work in an agile environment with software designed for critical systems used in the NHS involving large transactional data through the use of API's and web technology.

The role will also involve an element of 3rd/4th line assistance to help with the resolution of support calls and will require some data migration and major site upgrade work.

PURPOSE & MAIN RESPONSIBILITIES

* Managing the development and optimisation of Core & bespoke databases in SQL server including any implementation of new technologies.

* Assist with any maintenance and support of core and bespoke databases in SQL server including investigation any 3rd/4th line support calls.

* Triage assigned support incidents. Ensure that work on defect resolution does not impact on agreed product deliverables.

* Provide technical expertise when required to the development team in matters related to SQL server.

* Develop product expertise in your areas of responsibility such that you can act as the go-to expert from a DB perspective for multiple areas of the core product set.

* Ability to liaise with internal staff and customers at all levels (technical and non-technical) to ensure that development meets the requirements of the client.

* Escalate incidents/problems to Product Owners/Line Managers where required and provide appropriate solutions.

* Through the agile process, provide timely and accurate reporting of assigned work status as required through our internal JIRA system, reporting risks and issues.

* Taking part in all agile meetings and processes where necessary.

* Any other activities in support of the business which can reasonably be expected to fail within the capabilities of the employee.

ESSENTIAL SKILLS REQUIRED

* BSC or equivalent in a software engineering or DB discipline and/or professional qualifications appropriate to DB engineering roles such as the MCDBA or recent MCSE: Data Platform.

* Experience of working with large transactional databases.

* Excellent knowledge of the SQL database engine including strong T-SQL experience creating/administrating stored procedures, scripts, functions, triggers & other subjects)

* Excellent performance tuning skills (experience of Query Tuning, Indexing, Locking etc)

* Excellent communication skills, both to a technical & non-technical audience.

* Ability to work in a team environment with people of different skill-sets ranging from junior to senior levels.

* Experience in engaging at a commercial level with internal staff 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/2016.

* Experience in database installation, backup, restore & maintenance.

DESIRABLE SKILLS

* Experience of Source Control (Mercurial/Bitbucket)

* Experience of MS SQL Azure & data migration experience of SQL on-prem to SQL Azure advantageous.

* Data warehouse development, ETL and transformation into conformed design.

* Practical experience & knowledge of the Microsoft stack.

* Understanding of relational database design & dimensional Data-modelling.

* Some experience of using Visual Studio desirable (e.g. for debugging)

* Knowledge of NoSQL/Document DBs advantageous.

* Knowledge of 3rd party toolkits e.g. RedGate.

* Understanding of formal DB development and administration methodologies.

* Domain or product expertise in IT Healthcare would be advantageous but not essential.

Sthree UK is acting as an Employment Agency in relation to this vacancy.

You are currently using an outdated browser.

Please consider using a modern browser such as one listed below: