IT Database Administrator

Eurofins USA Genomic Services; Indaiatuba; Presencial; BRL 80.000 - 120.000; Tempo integral

Resumo da oferta

A leading life sciences company in Indaiatuba, Brazil, is seeking a skilled Database Administrator (DBA) with over 5 years of experience in database management. The ideal candidate will have expertise in Oracle and PostgreSQL, strong analytical abilities, and excellent communication skills. You will be responsible for maintaining database systems, ensuring data security, and collaborating with teams for optimal performance. This position offers an opportunity to work in a dynamic environment focused on safety and sustainability.

Qualificações

• 5+ years experience in database deployment, tuning and administration.
• Very good knowledge of Oracle and PostgreSQL databases.
• Outstanding communication and collaboration skills.

Responsabilidades

• Maintain database systems, ensuring performance and security.
• Collaborate with IT project managers and developers on database needs.
• Create automation for database tasks.

Conhecimentos

Database management systems

Performance optimisation

Data security

Backup and disaster recovery

Strong analytical skills

Formação académica

Bachelor’s degree in Computer Science or IT

Ferramentas

Oracle

PostgreSQL

Amazon RDS

Microsoft Azure

Descrição da oferta de emprego

Eurofins Scientific is an international life sciences company, providing a unique range of analytical testing services to clients across multiple industries, to make life and our environment safer, healthier and more sustainable. From the food you eat, to the water you drink, to the medicines you rely on, Eurofins laboratories work with the biggest companies in the world to ensure the products they supply are safe, their ingredients are authentic, and labelling is accurate.

The Eurofins network of companies is the global leader in food, environment, pharmaceutical and cosmetic product testing and in agro-science Contract Research Organization services. It is one of the market leaders in certain testing and laboratory services for genomics, discovery pharmacology, forensics, advanced material sciences and in the support of clinical studies, as well as having an emerging global presence in Contract Development and Manufacturing Organizations. It also has a rapidly developing presence in highly specialized and molecular clinical diagnostic testing and in-vitro diagnostic products.

In over 30 years, Eurofins has grown from one laboratory in Nantes, France to 58,000 staff across a decentralized and entrepreneurial network of 900 laboratories in over 54 countries. Eurofins companies offer a portfolio of over 200,000 analytical methods to evaluate the safety, identity, composition, authenticity, origin, traceability and purity of biological substances and products.

In 2021, Eurofins generated total revenues of EUR 6.72 billion, and has been among the best performing stocks in Europe over the past 20 years.

Job Description

As a DBA, you will be responsible for building and maintaining database systems and ensuring data security. Your role will also entail deploying, optimisation troubleshooting issues in our database management software and providing quick resolution. You’ll be required to work individually as well as collaborate with Developers, IT Operations and end-users to maintain databases. Thus, your ability to communicate fluently in one or more database management languages will be vital for project-related analyses.

Tasks:

• Design, install, configure and maintain database systems, including monitoring, tuning and troubleshooting issues.
• Provide a seamless flow of information by keeping the database running smoothly in collaboration with the Group CoC Database team.
• Ensure data security and integrity, including implementation of access controls, backups and recovery plans.
• Execute disaster recovery plans and procedures to ensure database availability during system outages or dysfunction.
• Establish the needs of users and monitor user access and security.
• Monitor performance and manage parameters to provide fast responses to front-end users.
• Map out the conceptual design for a planned database.
• Consider both back-end organisation of data and front-end accessibility for end-users.
• Refine the logical design so that it can be translated into a specific data model.
• Further refining the physical design to meet system storage requirements.
• Install and test new versions of the database management system (DBMS).
• Maintain data standards, including adherence to the Data Protection Act.
• Write database documentation, including data standards, procedures and definitions for the data dictionary (metadata).
• Control access permissions and privileges.
• Develop, manage and test back-up and recovery plans (import/exports/DB reorganizations, etc.).
• Ensure that storage and archiving procedures are functioning correctly.
• Carry out capacity planning.
• Work closely with IT project managers, database programmers (database development teams)
• Communicate regularly with technical, applications and operational staff to ensure database integrity and security.
• Commission and install new applications and customise existing applications to make them fit for purpose.
• Manage the security and disaster recovery aspects of a database.
• Create and manage database reports, visualizations, and dashboards.
• Create automation for repeating database tasks.
• Be available for on-call support as needed.

Ownership:

• Develop and maintain database documentation, including data standards, procedures and definitions for data elements and tables in the company.
• Identify and implement database requirements for new or existing applications by working collaboratively with other teams.
• Optimise database performance and efficiency by evaluating and recommending new database technologies.
• Support users and developers by resolving data-related technical issues and troubleshooting queries by guiding them with best practices.
• Execute regular database maintenance tasks, including database defragmentation, backups, and database replication.

Qualifications

Mandatory Experience:

• Bachelor’s degree in Computer Science, Information Technology or a related field.
• 5 years+ experience in database, deployment, tuning and administration.
• Experience in database backup, disaster recovery planning, performance optimisation and data security.
• Very good knowledge of database management systems in particular, Oracle, and PostgreSQL.
• Strong analytical and problem-solving skills to provide quick solutions to issues.
• Outstanding communication and collaboration skills to work in a team environment.

Nice to Have:

• Experience of migration from Oracle to PostgreSQL
• Working in a multi geographic environment

Specific skills and certifications:

• Ability to automate Database administrative tasks
• Relevant database administration certificates, such as Oracle Certified Professional (OCP), Microsoft Certified Database Administrator (MCDBA) or Postgres Certification (CPSDBA).
• Experience in cloud database technologies, like Amazon RDS or Microsoft Azure.

Additional Information:

Professional working proficiency in English is a requirement, including the ability to read, write and speak in English.