Administer and optimize PostgreSQL (and SQL Server) databases for microarray manufacturing and QC. Design data models, ensure high uptime, implement backup/recovery and replication, monitor performance, and support analytics and reporting for R&D and manufacturing teams.
Work Schedule
Standard (Mon-Fri)Environmental Conditions
OfficeJob Description
Thermo Fisher Scientific is looking for an experienced database administrator to support microarray manufacturing and design. The successful candidate will design, implement and maintain PostgreSQL databases to support data storage and trending for microarray manufacturing, quality 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 and maintain backup, recovery, and disaster recovery strategies to safeguard critical manufacturing data.
- Monitor database performance and proactively identify and 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:
- Bachelor’s or master’s degree in bioinformatics, Computer Science, Computer Engineering, IT, or related fields.
- Minimum 2 years of experience managing PostgreSQL or Oracle databases (PostgreSQL strongly preferred), including standing up new databases and recovering from system and database outages. Knowledge of Microsoft SQL Server is a plus.
- Experience with pg_tablespaces and 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) environments is essential.
- Demonstrated ability to work collaboratively with colleagues who are not experts in software and IT
Desired skills and experience:
- Expertise in 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
Top Skills
Postgresql,Oracle,Microsoft Sql Server,Pg_Tablespaces,Gnu/Linux (Rhel),Unix Shell,Hot Replication,Backup And Restore Methods,Etl
Similar Jobs
Cloud • Information Technology • Software
The Database Administrator provisions databases, ensures security, optimizes performance, implements recovery measures, and supports compliance for government IT projects.
Top Skills:
Aws RdsAzureMongoDBMySQLOraclePostgresSQL
Big Data • Cloud • Mobile • Business Intelligence
The MS SQL DBA will install, configure, and manage SQL Server databases, perform migrations and updates, and ensure high availability. The role also involves server performance tuning, capacity management, and client handling in a 24x7 support environment.
Top Skills:
DatapumpOracle 10GOracle 11GOracle 12COracle AsmOracle Data GuardOracle GoldengateOracle RacPl/SqlRmanSql LoaderSQL ServerUnix Scripting
Big Data • Cloud • Mobile • Business Intelligence
The Sybase DBA role involves installation, configuration, migrations, patch applications, performance tuning, and managing database solutions. The role also includes client handling and team leadership responsibilities in a 24x7 support environment.
Top Skills:
OracleSQLSybase 12.5Sybase 15Sybase 15.5Sybase 15.7
What you need to know about the Singapore Tech Scene
The digital revolution has driven a constant demand for tech professionals across industries like software development, data analytics and cybersecurity. In Singapore, one of the largest cities in Southeast Asia, the demand for tech talent is so high that the government continues to invest millions into programs designed to develop a talent pipeline directly from universities while also scaling efforts in pre-employment training and mid-career upskilling to expand and elevate its workforce.
