Triesten Technologies - Senior SQL Developer

Database Developer is needed in Walnut Creek, United States.

Client: Triesten Technologies

Location: Walnut Creek, CA

Contract: Contract

Job Description

This position will provide Clinical data solutions for Healthcare informatics efforts. We are looking for a highly motivated professional with strong organizational, analytical, and problem-solving skills.

Responsibilities

• Design, develop and optimize large, complex DB schemas, SQL scripts and objects to meet application functionality and performance requirements.
• Work with stakeholders including data, design, product, and executive teams and assist them with data-related technical issues.
• Collaborate closely with application developers and business teams to assist with data-related technical issues and ensure the successful design and delivery of data-driven solutions.
• 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 the effectiveness and quality of code.
• Liaise with developers to improve applications and establish best practices.
• Publish documentation and collaborative information using internal tools.

Requirements

• Expertise in Database Architecture in an environment that handles large volumes of data, exceeding 500 million new data records every day.
• Strong analytical and organizational skills.
• Demonstrated 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, and stored procedures.
• Expertise in understanding complex business needs, analyzing, designing, and developing solutions.
• Hands-on development experience in SQL Server 2016 or above using SSIS and SSRS.
• Experience in troubleshooting and resolving data-related issues.
• Excellent oral and written communication skills.
• Expertise in performance tuning, especially tuning complex queries, procedures, and indexing strategies.

Nice to Have

• Monitor and perform tuning on complex ETL jobs using meta-data/variables/parameters.
• Performance tuning experience using 3rd party tools.
• Audit/compliance experience in a highly regulated environment.
• Experience using Jira & Confluence as part of the development life cycle.
• Experience with Business Intelligence tools like Tableau, SSRS, Power BI, etc.
• Familiarity with Continual Improvement processes.
• Familiarity with Git.

Experience

• 15+ years of relational database and SQL experience.
• Creativity, curiosity, initiative, and self-management are key attributes the candidate should embody.
• 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) is a plus.
• Experience with Red Gate Tools (SQL Source Control, SQL Compare, SQL Data Compare, DLM) is a plus.
• Health care domain knowledge is a big plus.

Education

• BS or equivalent in engineering or a related technical area.
• Master’s degree preferred.

Job Type

Contract

Pay

$160,000.00 - $180,000.00 per year

Benefits

• 401(k)
• Health insurance

Compensation Package

• Yearly pay

Schedule

• Day shift
• Monday to Friday

Work Location

In person