Senior SQL Developer

Dublin  ‐ Onsite
This project has been archived and is not accepting more applications.
Browse open projects on our job board.

Description

Job Title: Senior SQL Developer
Location: Dublin, IRL
Duration: 1 Year Contract

The successful candidate will be working at our Dublin office, in a hands-on capacity and immediate contact with application development teams of the Platform group responsible for Back End solutions. Emphasis of the role is on high solution performance and salacity in large data asset environments.

Key responsibilities

  • Advance knowledge of SQL Server data stores: row store and column store, optimisations.
  • Advanced knowledge of indexes, index management, index design, index optimisations and index statistics.
  • Advanced knowledge of SQL Server partitioning and file and filegroup design.
  • Advanced Knowledge of 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.
  • Good knowledge of query and query parallelism in SQL Server
  • Good knowledge of Column Store index and Column Store query optimisations
  • Good knowledge of SQL Server DMO's especially around statistics, data store and performance
  • Good knowledge of SQL Server settings and database setting and the impact on performance
  • Experience with Database Administration in general for MSSQL Server. Working closely with the DBA team to ensure smooth deployments of application updates.
  • Experience in troubleshooting and resolving general database problems.
  • Experience with database design & Datamodelling (experience with Erwin or similar data modeller tools is an advantage).
  • Experience in database source control and deployments. Examples: SVN, CVS, Git, TFS
  • Experience in testing/validating database components.
  • Experience with 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.
  • Successful experience with agile development practices.
  • Proven ability to influence technical discussions and provide technical leadership.
  • Wholistic 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.

Education and nice to haves

  • BSc computer science/engineering or similar.
  • Successful experience with large enterprise scale solutions.
  • Working experience or good understanding of C# data accessors.
  • Experience of SSRS and other reporting products
Start date
n.a
From
eTeam Inc.
Published at
19.02.2020
Project ID:
1895807
Contract type
Freelance
To apply to this project you must log in.
Register