Description

You will design, develop, and optimize complex database schemas and SQL objects for high-volume environments.

Responsibilities

• Design and optimize large-scale DB schemas and SQL scripts to meet performance requirements.
• Collaborate with application developers, product teams, and stakeholders to resolve data-related technical issues.
• Implement development and release processes to ensure high-quality, rapid deployment.
• Provide technical solutions to maintain data integrity across enterprise systems.
• Participate in code reviews and publish technical documentation using internal tools.

Required Skills

• 8+ years of experience with relational databases and SQL.
• 4+ years of experience coding complex SQL queries and stored procedures.
• Expertise in database architecture handling over 500 million new records daily.
• Deep knowledge of performance tuning, including query optimization, server optimization, and indexing strategies.
• Hands-on development experience with SQL Server 2016 or above, including SSIS and SSRS.
• Strong proficiency in data modeling and database design.
• Experience with database development methodologies including Source Control, Release Management, Agile, and Scrum.
• Ability to explain the internal mechanics of database performance tuning.
• BS or equivalent in engineering or a related technical area; Master's degree preferred.

Preferred Skills

• Experience with ETL job monitoring, Git, and Jira/Confluence.
• Familiarity with Business Intelligence tools such as Tableau and Power BI.
• Experience with Continuous Integration tools (Jenkins, TeamCity, Bamboo) and Test-Driven Development.
• Knowledge of Red Gate tools and the healthcare domain.

Key Skills

Education

Master's degree