Senior Database Developer at Guru Schools California City, CA

Guru Schools; California City (CA); Hybrid; USD 130,000 - 170,000; Full time

Job summary

Guru Schools in California City, CA, is seeking a Senior Database Developer to design, optimize and manage large-scale databases in a healthcare IT setting.

The role involves collaborating with product and engineering teams, implementing robust data solutions, and ensuring data integrity across enterprise systems. Strong SQL, ETL and CI/CD practices are highly valued.

Qualifications

• Expertise in database architecture handling large data volumes.
• Strong analytical and organizational skills.
• Proficiency in performance tuning of queries and server.
• Experience with data modeling, database design, and indexing strategies.
• Hands-on development with SQL Server 2016+ using SSIS/SSRS.
• Experience troubleshooting data issues.
• Excellent communication skills.
• Experience with CI tools and TD D is a plus.

Responsibilities

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

Skills

SQL

Database architecture

Performance tuning

Data modeling

Stored procedures

SSIS/SSRS

SQL Server

ETL

Education

BS in engineering or related field

Master's degree preferred

Tools

JIRA

Confluence

Git

Red Gate Tools

Job description

Senior Database Developer job at Guru Schools. California City, CA.

Senior Database Developer

We are seeking Senior Database Developer/Engineers who can interview and work onsite in a hybrid arrangement at a major Healthcare IT Group in Pleasanton, California.

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.

Scope of Responsibilities

• Design, develop and optimize large, complex DB schemas, SQL scripts and objects to meet application functionality and performance requirements.
• Working with stakeholders including data, design, product, and executive teams and assisting them with data-related technical issues.
• Working closely with application developers and business teams at all levels to assist with data-related technical issues and help ensure the successful designing and delivering 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 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 volume of data, excess of 500 million of new data records every day.
• Strong analytical and organizational skills. This job involves analyzing existing databases and the client's needs to develop effective data driven solutions.
• 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 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, procedure, and indexing strategies

Also desired

• Monitor and perform tuning on complex ETL jobs using meta-data/variables/parameters.
• Performance tuning experience using 3rd party tools
• Audit/compliance experience in highly regulated environment.
• Experience using JIRA & Confluence as part of development life cycle
• Experience with Business Intelligence tools like Tableau, SSRS, Power BI etc.
• 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