Description
Java, C# / Linq, T-SQL, SSIS, SSRS, SSAS, MDX, DMX or Power BISQL Server Database Developer
My client, A market leader in payment / loyalty solutions require an experienced SQL ServerDatabase Developer to deliver high quality functional software within agreed timescales.
As a member of the Loyalty development team you will be expected to participate in the design, development and test of enterprise software solutions. SKILLS Technical must have skills (4 years of experience minimum):
Deep knowledge and experience of writing (and refactoring) complex and high performance SQL in SQL Server (referred to as T-SQL). Our table sizes range up to of billions of rows.
Wide experience of designing different types of databases. We have database types of: OLTP (transactional), OLAP (analytic) and data-warehouse.
Extensive knowledge and experience of SQL and database best practices and how to refactor advanced / performant SQL, that may involve: CTE's (common table expressions), window functions, table valued functions, triggers, views, stored procedures, temporary tables and table variables.
Experience of debugging problems with: data consistency, data integrity, transactions, locking, blocking and deadlocking. Desirable (2 years where experience specified):
Knowledge of logical to physical design for performance and data management trade-offs for database storage, i.e. use of indexing, compression, table partitioning and filegroups.
Knowledge and experience of designing and implementing SQL Server database security (logins, users, groups, schemas, etc..).
Experience of working alongside OO developers who are using an ORM (for example one of, for either of the Java or C# versions: Hibernate, EJB, ActiveRecord, Kodo, ORMLite, nHydrate, Entity Framework, Dapper or Linq to SQL).
Participated in an extensive and detailed data analysis task, involving a defined statistical or algorithmic analysis methodology. Either for a reporting or other data processing component of a system.
Theoretical knowledge of OO (object oriented) software design and development techniques.Using either of SQL Profiler or SQL Server Extended Events for either debugging or reverse engineering.
Collaborating with either or both of: a DBA team to solve performance and other data issues, a development team to deliver data-driven systems. Nice to have (not required, but if you've got itput it on the CV):
Experience of Unit Testing.
Experience of working with a source control system (such as TFS, SVN, GIT or similar).
Any experience of programming in: any OO language (for example: Java, C#, Python, VB.NET, Ruby) or any functional language (for example: Python or Scala) or any statistics package (for example: R, Statistca or SAS).
To have written PowerShell scripts for database or other administration tasks.
Experience with one or more of SQL Server BI (Business Intelligence) toolset: SSIS, SSRS, SSAS, MDX, DMX or Power BI.
Knowledge or experience of data mining techniques. NOTE: We are looking for a genuinely "data-motivated" developer who wants to take their career to the next level.
For more information on this new and exciting role, Please get in touch.Lee Barham /