Senior SQL Server Software Engineer

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

As a Senior SQL Server Engineer you will be working with the application development teams for the Platform group responsible for backend solutions. Emphasis of the role is on high solution performance and salacity in large data asset environments.

Responsibilities

* SQL Server data stores: row store and column store, optimisations.

* Knowledge of indexes, index management, index design, index optimisations and index statistics.

* SQL Server performance tuning, especially around stored procedures

* Acting as SME (subject matter expert) for the teams implementing features or changes using SQL Server platforms

* Technical design and implementation of new application features, rework and upgrades of the existing functionality.

* SQL Server DMO's especially around statistics, data store and performanc

* Knowledge of SQL Server settings and database setting and the impact on performance

* Database Administration in general for MSSQL Server. Working closely with the DBA team to ensure smooth deployments of application updates.

* Troubleshooting and resolving general database problems.

* Database design & data modelling (experience with Erwin or similar data modeller tools is an advantage).

* Database source control and deployments. Examples: SVN, CVS, Git, TFS

* Testing/validating database components.

* Monitoring either native or via 3rd party

Essential Skills & Experience

* 5 + years of design and development of relational data store solutions using Microsoft SQL Server in a production environment.

* BSc computer science/engineering or similar.

* Successful experience with agile development practices.

* Proven ability to influence technical discussions and provide technical leadership.

* Holistic approach to the application development and strong owner attitude of the functionality provided to the customers.

* Ability to comprehend complex business and technical scenarios.

* Expert knowledge of SQL and T-SQL.

* Experience in Performance Tuning and Optimization (PTO), using monitoring and troubleshooting tools.

* Industry experience working high volumes of data in 24/7 environment.

* Experience with SSIS packages development and maintenance.

* Successful experience with large enterprise scale solutions.

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