SENIOR DATABASE ENGINEER OAKLAND, CA REC

Company: ESR Healthcare
Location: Oakland
Posted on: November 11, 2024

Job Description:

Senior Database Engineer Oakland, Ca rec

Experience, qualification, and soft skills, have you got everything required to succeed in this opportunity Find out below.
REC10019069 - Updated: May 15, 2020
OPENINGS: 1
JOB TYPE: Contract
LOCATION: Oakland, California, United States, 94612
INDUSTRY: Information Technology
CATEGORY: Information Technology
EDUCATION: Bachelor's Degree
EXPERIENCE: 7-10 years
TRAVEL: Never
RELOCATION ASSISTANCE: No - Local candidates only
WORK ELIGIBILITY: Green Card, US Citizen
CANDIDATE PAY RANGE: $68 /hr to $73 /hr
JOB DESCRIPTION
Responsibilities

• 
  
• 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
  
• 
  
• 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
  
• 
  
• 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 & Confluence as part of development life cycle.
  
• Familiar with Continual Improvement processes.
  
• Familiar with Git.
  
  Experience
  
• 
  
• 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
  
• 
  
• BS or equivalent in engineering or related technical area.
  
• Masters degree preferred.
  
  BENEFITS
  Health, Dental, Vision
  QUESTIONS FROM THE EMPLOYER
  You will be required to answer the following questions when submitting a candidate to this job:
  
• 
  
• Candidate's full name.
  
• Candidate's email address and phone number.
  
  COMPLIANCE
  You will need to confirm the following compliance terms when submitting this candidate:
  
• 
  
• You have directly communicated with this candidate.
  
• This candidate wants to be considered for this position.
  
• This candidate was obtained in a manner that complies with OFCCP regulations at 41 CFR Part 60-1.
  
  Additionally, you'll need to write an introductory note about this candidate, telling the employer why this person is a right fit for the job.
  #J-18808-Ljbffr

Keywords: ESR Healthcare, West Sacramento , SENIOR DATABASE ENGINEER OAKLAND, CA REC, Engineering , Oakland, California