Senior SQL Server Developer
Posted on Jan 21, 2020 by eTeam Inc.
Job Title: Senior SQL Server Developer
Location: Dublin 18, 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.
Advance knowledge of SQL Server data stores: row store and column store, optimizations.
Advanced knowledge of indexes, index management, index design, index optimizations and index statistics.
Advanced knowledge of SQL Server partitioning and file and file group 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 optimizations
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