SQL Database Developer




Permanent London £70,000 - 90,000 p/a

Our client is an industry leading software provider, working with organisations throughout the world developing cutting-edge technology solutions to support their businesses goals.

 

Role overview:

 

Working within the database team you will be involved in all aspects of database development from the transactional platform to the reporting platforms. Core responsibilities include the development and maintenance of high-volume transactional databases in addition to development in SSAS, SSRS and SSIS.

 

You will be joining a global team working in a dynamic agile creative development environment using the latest technologies.

 

 

Key responsibilities/experience:

 

  • Design and development of databases using Microsoft SQL Server Duty #2
  • T-SQL development: Stored procedures, Views, triggers, functions
  • Platform administrative tasks (adding configuration etc.)
  • Performance Tuning and Optimisation (PTO)
  • Native monitoring, utilising Profiler or XEvent Profile, Performance Monitor, Extended Events, Execution Plan
  • Development and maintenance of tables, indexes, stored procedures, views, triggers and other objects utilizing the latest DML and DDL syntax

 

Additional Skills:

 

  • Excellent knowledge of indexes, index management, statistics and partitioning
  • Familiarity with RDBMS principles, database design and normalization
  • Experience with SSDT (SQL Server Data Tools)
  • Experience with Visual Studio Data Tools, Data Flow tasks, Package configuration, ETL heterogeneous data sources setup, Deployment models, SSIS Data Catalog management, Environment setup
  • C#/.NET – C# scripts inside SSIS script task
  • Experience with SSRS or SSAS or Power Pivot
  • Understanding of the full development life cycle, development methodologies, and version control

In line with the Conduct Regulations 2003, when advertising permanent vacancies JNC Recruitment are acting as an Employment Agency, and when advertising temporary/contract vacancies JNC Recruitment are acting as an Employment Business.


Apply

Back

X

Apply for job

To apply for this job, please fill in the form opposite

X

Contact us

Telephone:
+ 44 (0) 1273 774738
Email:
info@jncrecruitment.com
Address:

JNC Recruitment,
Heversham House,
2nd Floor South,
18/22 Boundary Road,
Hove,
East Sussex,
BN3 4EF