SQL Database Designer

Analytical Wizards is part of the Definitive Healthcare family. We balance innovation with an open, friendly culture and the backing of a long-established parent company, known for its ethical reputation. We guide customers from what’s now to what’s next by unlocking the value of their data and applications to solve their challenges, achieving outcomes that benefit both business and society. Our people are our biggest asset, they drive our innovation advantage and we strive to offer a flexible and collaborative workplace where they can thrive. We offer industry-leading benefits packages to promote a creative and inclusive culture. If driving real change gives you a sense of pride and you are passionate about powering social good, we’d love to hear from you.

Definitive Healthcare is a rapidly growing data and analytics provider of the most up-to-date, comprehensive, and integrated information on hospitals, physicians, and other healthcare providers.

Recently honored by the Boston Business Journal as one of the 10 fastest-growing private companies in Massachusetts and named THE BEST large company to work for on Business Journal’s Best Places to Work list published in June 2019, Definitive Healthcare is on an incredibly exciting trajectory. The company has more than doubled in size in the past 2+ years and will have 600+ employees in the Framingham office by the end of the year. Our motivated and high-energy workforce is collaborative, kind, and engaged, which has led to exceptional retention rates. Our expansion has created the need for a talented and experienced SQL Database Engineer to lead our Database Engineering vertical. If you would like to develop a product that is in high demand, and evolving rapidly, keep reading!

Your challenge:

As a SQL Database Engineer, you will join our growing Engineering team. You will work with teams of engineers to help them all learn, grow and succeed. You will provide technical leadership to the team and hold accountability for technical decisions.

The SQL Database Engineer at Definitive Healthcare:

• Ensures solutions are built, according to business and technical specifications, supporting an error-free, predictable, high-performing platform
• Contributes significantly to architectural decisions around our data
• Performs code reviews
• Is always thinking of better ways to do something
• Isn’t afraid to fail
• Cares deeply about quality

Skills we’re looking for:

• Strong knowledge in database management and infrastructure engineering
• Extensive experience with at least one RDBMS: MS Sql Server, Oracle etc.

,

• Experienced in creating, optimizing, and troubleshooting procedures/functions/UDF’s (T-SQL, PL/SQL etc.,)
• Familiarity with state-of-the-art DB technologies and tradeoffs: distributed DBs, time-series DBs, columnar storage
• Knowledge and experience with Linux, must be comfortable using Linux/UNIX command line tools
• Solid scripting, performance troubleshooting, and networking knowledge
• Exceptional communication skills - this role will require cross-collaboration with various stakeholders across DHC
• Well versed in software development methodologies, testing, release management, and maintenance. take pride in optimizing and cleaning code, and leave a program in a better shape than you found it
• Good knowledge of DevOps and CI practices
• Excellent troubleshooting skills. Experience performing root cause analysis on internal and external data and processes to answer specific business questions and find opportunities for improvement.
• Strong analytic skills related to working with unstructured and structured datasets