Database Specialist (m/f/d) - Chemistry Solutions

Elsevier; Deutschland; Vor Ort; EUR 50.000 - 80.000; Vollzeit

Zusammenfassung

Join a forward-thinking organization as a relational database specialist, where your expertise in PostgreSQL and database optimization will be crucial in enhancing the performance of a powerful data searching tool. This role offers the opportunity to work within an agile team, contributing to innovative solutions for complex queries on large datasets. With a commitment to work-life balance and personal development, you'll thrive in a supportive environment that values your contributions and nurtures your curiosity. Embrace this chance to make a meaningful impact in the fields of chemistry and data science.

Leistungen

Flexible working hours

Healthy work/life balance

Career development opportunities

Supportive work environment

Qualifikationen

• 5+ years of experience in PostgreSQL and database optimization.
• Bachelor's degree in Computer Science or related field is required.

Aufgaben

• Optimize database structures and schemas for complex queries.
• Collaborate with developers and stakeholders for timely deliveries.

Kenntnisse

PostgreSQL

Database Optimization

Data Structure Optimization

Bash Scripting

Python Scripting

Fluent English

Ausbildung

Bachelor in Computer Science

Master in Computer Science

Tools

Aurora Database

Jenkins

JIRA

Confluence

Oracle

AWS

C/C++

Linux

Jobbeschreibung

About Reaxys

Reaxys is a comprehensive and powerful cloud hosted and deep-tech data searching tool that is used by thousands of chemists, researchers, and students throughout the world to retrieve chemistry patents, chemical reactions, substance data, and other related chemistry information using a highly performant, bespoke, search engine. Supported by continuous updates and robust taxonomies, Reaxys can be searched using natural language, drawn chemical structures, formula, physical property parameters and more. Trusted for over 30 years by large pharma, innovative startups, large tech, private and public sector research hubs and universities alike, Reaxys is a partner to the pharma, medicinal chemistry, and chemical industries.

About the Role

The focus is on the database, schema, data structure optimization to provide an (almost) real-time experience to our customers, even for complex queries on continuously growing large datasets. You will be part of an agile development team supporting and continuously improving our chemical full text retrieval search to fulfill our customer's needs. You will be able to contribute and expand your expertise and skills in a variety of career paths at Elsevier.

About the Team

The Reaxys team is searching for a self-driven and enthusiastic relational database specialist with a passion for performance optimization of databases hosting large amounts of data.

Your Responsibilities:

• Understand different data structures and the corresponding data, and constantly optimize and adapt the data structures and schemas to fulfill customer use cases
• Replicate the data structures in our database, i.e., the implementation of an abstract data structure in a database
• Optimize the database, e.g., indexes, the data structure, and queries, and implement extensions, stored procedures for fast result retrieval even for complex queries
• Be an active member of the agile team, contributing to ceremonies and team decision making
• Work closely with developers, product owners, and other stakeholders to ensure timely deliveries

You should bring:

• Expert (5 years) PostgreSQL
• Aurora database experience with a strong focus on database, schema, data structure, and query optimization
• A bachelor's degree (master's preferred) in computer science, or life sciences with a strong background in database performance optimization
• Strong background in database optimization
• Basic scripting experience in Bash, Perl, or Python
• Fluent English oral and written communication skills
• The ability and passion to work in a diverse team

The following skills will be a bonus:

• Basic chemistry or life sciences knowledge
• Experience or training in Oracle / AWS / C/C++ / Linux
• Knowledge of Jenkins, JIRA, and Confluence

Work in a way that works for you

We promote a healthy work/life balance across the organization. We will help you meet your immediate responsibilities and your long-term goals.

• Working flexible hours - flexing the times when you work in the day to help you fit everything in and work when you are the most productive

Join Us

Purposeful Work
When you work with us, your work matters. You are part of an organization that nurtures your curiosity to stimulate innovation for the communities that we serve.

Growing Every Day
Like the communities we serve, you are on a constant path of discovery to shape your career and personal development.

Colleagues Who Care
You will be part of the Elsevier family. We will support your well-being and provide the flexibility you need to thrive at work and home.

Together, we create possibilities.

Elsevier is an equal opportunity employer: qualified applicants are considered for and treated during employment without regard to race, color, creed, religion, sex, national origin, citizenship status, disability status, protected veteran status, age, marital status, sexual orientation, gender identity, genetic information, or any other characteristic protected by law. We are committed to providing a fair and accessible hiring process. If you have a disability or other need that requires accommodation or adjustment, please let us know by completing our Applicant Request Support Form: https://forms.office.com/r/eVgFxjLmAK , or please contact 1-855-833-5120.

Please read our Candidate Privacy Policy.