You focus on optimizing data structures and database performance while collaborating with an agile team to ensure efficient project delivery and effective communication with stakeholders.
Anforderungen
- •Expert PostgreSQL (5 years)
- •Aurora database experience focused on optimization
- •Bachelor's degree in computer science or life sciences
- •Strong background in database optimization
- •Basic scripting experience in Bash, Perl, or Python
- •Fluent English oral and written skills
- •Ability to work in a diverse team
- •Basic chemistry or life sciences knowledge (bonus)
- •Experience in Oracle / AWS / C/C++ / Linux (bonus)
- •Knowledge of Jenkins, JIRA, and Confluence (bonus)
Deine Aufgaben
- •Understand and optimize data structures and schemas.
- •Replicate data structures in the database.
- •Optimize database performance with indexes and queries.
- •Implement extensions and stored procedures for efficiency.
- •Participate actively in agile team ceremonies.
- •Collaborate with developers and stakeholders for timely deliveries.
Original Beschreibung
# Database Specialist (m/f/d) - Chemistry Solutions
**Frankfurt** | **Full time**
**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
-----------------------------------------------------------------------
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 or please contact 1-855-833-5120.
**Criminals may pose as recruiters asking for money or personal information. We never request money or banking details from job applicants.**
***USA Job Seekers:***
We are 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.
EEO Know Your Rights.