Sr. Database Engineer

Sr. Database Engineer
Company:

(Confidential)


Sr. Database Engineer

Details of the offer

stylemargin: 0px 0px 20px; padding: 0px 0px 0px 15px; color: rgb(85, 85, 85); font:family: Roboto, Open Sans, sans:serif; font:size: 16px; font:style: normal; font:weight: 400; letter:spacing: normal; orphans: 2; text:indent: 0px; text:transform: none; white:space: normal; widows: 2; word:spacing: 0px; background:color: rgb(249, 249, 249):
:Design and maintain objects in large clinical 2:3 TB SQL Server Databases (tables, views, procedures, functions etc

:Design and code a large number of SQL Queries and stored procedures

:Tune complex SQL Server queries, drive to best performance possible.

:Implement processes and procedures for the development and release of products/projects that facilitate high quality and rapid deployment

:Provide solutions to promote data integrity in enterprise systems.

:Participate in code reviews to validate effectiveness and quality of code.

:Publish documentation and collaborative information using internal tools.

:Research, discover, test and implement new solutions/tools.
Requirements
Requirements:

stylemargin: 0px 0px 20px; padding: 0px 0px 0px 15px; color: rgb(85, 85, 85); font:family: Roboto, Open Sans, sans:serif; font:size: 16px; font:style: normal; font:weight: 400; letter:spacing: normal; orphans: 2; text:indent: 0px; text:transform: none; white:space: normal; widows: 2; word:spacing: 0px; background:color: rgb(249, 249, 249):
:Expertise in Database Architecture in an environment that handles large volume of data, excess of 500 million every day

:Demonstrate expertise in performance tuning including both query and server optimization utilizing SQL tools and/or 3rd party solutions

:Strong knowledge and experience in data modeling, database design, optimization for performance, SQL, stored procedures

:Expertise in understanding complex business needs, analyzing, designing and developing solutions

:Hands:on development experience in SQL Server 2008 or above using SSIS and SSRS

:Experience in trouble shooting and resolving data issues

:Eager to learn clinical data and systems

:Excellent oral and written communication skills

Nice to have:

stylemargin: 0px 0px 20px; padding: 0px 0px 0px 15px; color: rgb(85, 85, 85); font:family: Roboto, Open Sans, sans:serif; font:size: 16px; font:style: normal; font:weight: 400; letter:spacing: normal; orphans: 2; text:indent: 0px; text:transform: none; white:space: normal; widows: 2; word:spacing: 0px; background:color: rgb(249, 249, 249):
:Monitor and perform tuning on complex ETL jobs using meta:data/variables/parameters.

:Performance tuning experience using 3rd party tools

:Audit/development experience in highly regulated environment.

:Experience using Jira and Confluence as part of development life cycle

:Familiar with Continual Improvement processes

:Familiar with Git

Experience

stylemargin: 0px 0px 20px; padding: 0px 0px 0px 15px; color: rgb(85, 85, 85); font:family: Roboto, Open Sans, sans:serif; font:size: 16px; font:style: normal; font:weight: 400; letter:spacing: normal; orphans: 2; text:indent: 0px; text:transform: none; white:space: normal; widows: 2; word:spacing: 0px; background:color: rgb(249, 249, 249):
:8 years + relational database and SQL experience

:Creativity, curiosity, initiative and self management are key attributes candidate embodies.

:Solid experience (4 years +) in coding complex SQL queries and stored procedures. The ability to explain the details of performance tuning internals of the database.

:Strong understanding of database development methodologies (Source Control, Continual improvement, Release Management, Agile and Scrum)

:Experience with Continuous Integration Tools (Jenkins, TeamCity, Bamboo) and Test Driven Development (TDD) a big plus

:Experience with Red Gate Tools a plus (SQL Source Control, SQL Compare, SQL Data Compare, DLM

:Health care domain knowledge a big plus.

Education

stylemargi


Source: Tiptopjob_Xml


Area:

Requirements

Haul unit operator

WE GIVE DOWN-TO-EARTH A WHOLE NEW MEANING We're Lehigh Hanson. Our products build cities and towns, including stadiums that hold thousands of fans, and bridges...


Indiana

Published a month ago

Phoenix- metallurgical lab technician

var jobGraphicURL = '/images/job%20descriptions/1841077'; $(document).ready(function () { $(window).resize(function () { if ($('#job-description-graphic...


Nevada

Published a month ago

Long canyon chief engineer

var jobGraphicURL = '/images/job%20descriptions/1841078'; $(document).ready(function () { $(window).resize(function () { if ($('#job-description-graphic...


Nevada

Published a month ago

Smelter operator 3 trainee

var jobGraphicURL = '/images/job%20descriptions/1841073'; $(document).ready(function () { $(window).resize(function () { if ($('#job-description-graphic...


Montana

Published a month ago