Senior Database Engineer Oakland, ca rec

Senior Database Engineer Oakland, Ca rec
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

1. Design and maintain objects in large clinical 2-3 TB SQL Server Databases (tables, views, procedures, functions etc).
2. Design and code a large number of SQL Queries and stored procedures.
3. Tune complex SQL Server queries, drive to best performance possible.
4. Implement processes and procedures for the development and release of products/projects that facilitate high quality and rapid deployment.
5. Provide solutions to promote data integrity in enterprise systems.
6. Participate in code reviews to validate effectiveness and quality of code.
7. Publish documentation and collaborative information using internal tools.
8. Research, discover, test and implement new solutions/tools.

Requirements

1. Expertise in Database Architecture in an environment that handles large volume of data, excess of 500 million every day.
2. Demonstrate expertise in performance tuning including both query and server optimization utilizing SQL tools and/or 3rd party solutions.
3. Strong knowledge and experience in data modeling, database design, optimization for performance, SQL, stored procedures.
4. Expertise in understanding complex business needs, analyzing, designing and developing solutions.
5. Hands-on development experience in SQL Server 2008 or above using SSIS and SSRS.
6. Experience in trouble shooting and resolving data issues.
7. Eager to learn clinical data and systems.
8. Excellent oral and written communication skills.

Nice to have

1. Monitor and perform tuning on complex ETL jobs using meta-data/variables/parameters.
2. Performance tuning experience using 3rd party tools.
3. Audit/development experience in highly regulated environment.
4. Experience using Jira & Confluence as part of development life cycle.
5. Familiar with Continual Improvement processes.
6. Familiar with Git.

Experience

1. 8 years + relational database and SQL experience.
2. Creativity, curiosity, initiative and self management are key attributes candidate embodies.
3. 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.
4. Strong understanding of database development methodologies (Source Control, Continual improvement, Release Management, Agile and Scrum).
5. Experience with Continuous Integration Tools (Jenkins, TeamCity, Bamboo) and Test Driven Development (TDD) a big plus.
6. Experience with Red Gate Tools a plus (SQL Source Control, SQL Compare, SQL Data Compare, DLM).
7. Health care domain knowledge a big plus.

Education

1. BS or equivalent in engineering or related technical area.
2. 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:

1. Candidate's full name.
2. Candidate's email address and phone number.

COMPLIANCE

You will need to confirm the following compliance terms when submitting this candidate:

1. You have directly communicated with this candidate.
2. This candidate wants to be considered for this position.
3. 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.