Database Administrator
Share
Job Location:
Monthly Salary:
Posted on:
17 hours ago
Vacancies:
1 Vacancy
Job Summary
Work Schedule
Standard (Mon-Fri)Environmental Conditions
OfficeJob Description
ThermoFisher Scientific is looking for an experienceddatabaseadministrator to support microarray manufacturing and successful candidate will designimplementandmaintainPostgreSQL databases to support data storage and trending for microarray manufacturingquality control (QC) and custom microarray designs. High uptime and excellent query performance are crucial. New data modeling will be required in collaboration with laboratory scientists manufacturing specialists and our experienced data modeling and database engineering team.
Primary Duties and Responsibilities:
- Develop implement and maintain PostgreSQL and SQL Server databases supporting microarray manufacturing and QC workflows.
- Collaborate with multi-functional teams to model and integrate new data structures for evolving experimental and production requirements.
- Ensure database performance security and availability with emphasis on uptime and rapid data retrieval.
- Develop andmaintainbackup recovery and disaster recovery strategies to safeguard critical manufacturing data.
- Monitor database performance and proactivelyidentifyand resolve bottlenecks or failures.
- Implement and enforce data governance standards schemas and procedures for consistent and scalable database management.
- Support data trending analytics and reporting tools used by manufacturing and R&D teams.
Education/Experience Requirements:
- Bachelors or mastersdegreeinbioinformatics Computer ScienceComputer EngineeringITorrelatedfields.
- Minimum 2years of experiencemanagingPostgreSQL or Oracle databases (PostgreSQLstrongly preferred) including standing up new databases andrecovering fromsystem and database outages. Knowledge of Microsoft SQL Server is a plus.
- Experience withpgtablespacesand setting up custom database environments
- Familiarity with database backup methods hot replication and restoration from backup
- Fluency in Unix shell operations particularly in GNU/Linux (RHEL and similar) environmentsis essential.
- Demonstrated ability to work collaboratively with colleagues who are not experts in software and IT
Desired skills and experience:
- Expertisein query composition and optimization
- Training or experience with data modeling in a relational database setting
- Experience with scripting and pipelining in a Linux environment especially ETLs for loading data
- Familiarity with modern manufacturing processes and process control
- Interest or education in genetics biochemistry bioinformatics or related fields
Required Experience:
Unclear Seniority
Key Skills
- Databases
- Disaster Recovery
- SQL
- High Availability
- Microsoft SQL Server
- ssrs
- Database Design
- Performance Tuning
- SSIS
- Database Administration
- Sybase
- Oracle
About Company
Electron microscopes reveal hidden wonders that are smaller than the human eye can see. They fire electrons and create images, magnifying micrometer and nanometer structures by up to ten million times, providing a spectacular level of detail, even allowing researchers to view single a ... View more
