Senior MS SQL Database Engineer - Performance Optimization!
Company: DISYS - Digital Intelligence Systems, LLC
Location: Walnut Creek
Posted on: March 28, 2020
Digital Intelligence Systems (DISYS) is seeking a Senior
Database Engineer to be a key resource for a dynamic Systems
Infrastructure team at a leading IT Healthcare organization in
Walnut Creek, California. For this multi-year engagements, only
Candidates who reside in the San Francisco Bay Area will be
considered. Remote work options are offered at this time! This key
resource will provide Clinical data solutions for Health Care
informatics efforts. We are looking for a highly motivated
professional with strong organizational, analytical and problem-
solving skills. RESPONSIBILITIES Design and maintain objects in
large clinical 2-3 TB SQL Server Databases (Tables, Views,
Procedures, Functions). 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 productsprojects 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 solutionstools.
REQUIREMENTS 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 andor 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. Monitor and perform tuning on complex ETL
jobs using meta-data, variables and parameters. Performance tuning
experience using 3rd party tools. Auditdevelopment 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 8 years + of
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 with 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 Bachelor of Science degree or equivalent in
Engineering or related technical area Masterrsquos degree preferred
For more details regarding this immediate, long-term engagement,
please contact Nicole Foster at 925.788.5655. Thank you for your
Keywords: DISYS - Digital Intelligence Systems, LLC, Walnut Creek , Senior MS SQL Database Engineer - Performance Optimization!, IT / Software / Systems , Walnut Creek, California
Didn't find what you're looking for? Search again!