SOPHiA GENETICS Database Administrator (DBA) in Boston, Massachusetts
Would you like to join a dynamic and exciting Software Engineering and Technical Operations organization that uses cutting edge technologies to deliver a world changing product that has a direct impact on the lives of cancer and rare disease patients worldwide? Join our growing team and use your exceptional technical and leadership skills to help us deliver on our mission of democratizing Data-Driven Medicine. Our products are used by thousands of healthcare institutions globally and provide world leading capabilities for the analysis of genomic, clinical, and imaging data.
In order to augment our Data Services team we are looking for a Software Development Engineer (Database Administrator) in USA.
As a Database Administrator you will support both engineering and operations teams in developing, deploying, and operating data services powering our platform in the digital healthcare sector.
Our platform is a one-of-a-kind globally distributed information system that brings together hospitals and labs to provide data ingestion and processing, analysis and modeling, reporting and intelligence, distribution and sharing of a multitude of complex sources of structured and unstructured data, including genomics, imaging, and clinical data, delivered as a multi-tenant SaaS platform on the cloud.
You will provide expertise to Engineering teams in database design, including the modeling of data and domain, query optimization, writing stored procedures and SQL scripts, and inform performance-driven design choices for physical data models. You will support the operations teams by developing and performing database deployments and migrations as part of our software development lifecycle. You will also monitor and optimize databases in production, as well as implement architectural and configuration changes for storage backends to achieve performance, stability, and recoverability. You will perform performance evaluations of new technologies and help in designing, implementing and deploying storage backends for POCs of future services. As needed for projects, you will participate in estimation and risk-assessment, and exchange with stakeholders in Product and Project Management and other departments.
You will participate in the team’s recurring activities and help organize them. You will share your knowledge with Engineers in trainings to increase their database related skills, share best practices in the team and support more junior team members.
You have demonstrated experience in developing reliable and performant data services and also have a firm grasp on the underlying storage challenges. You are excited by the prospect of designing and implementing the delivery of large amounts of data from and to cloud applications. You have a basic understanding of the domain of genomics and digital healthcare and care for the impact you can have in this field. You know modern software engineering processes, have good knowledge of tools, technologies, and best practices. You seek to exchange regularly and communicate effectively with other members of your team.
Bachelor’s degree in Computer Science or Engineering or equivalent professional experience
2 years’ experience in software engineering or database administration
Excellent knowledge of MariaDB and PostgreSQL
Excellent knowledge of modern scalable database technologies
Good knowledge of: backup & restore, database replication, crash & disaster recovery, connection pooling and load balancing
Good knowledge of data modeling and database design, UML
Good knowledge in Database Performance Tuning and Database Security
Experience managing data migrations using either Flyway, Liquibase, Alembic, or Redgate
Knowledge in data optimization techniques such as materialized views, advanced index schemes, denormalization, vertical partitioning, horizontal partitioning and parallel processing
Experience in developing, maintaining, optimizing stored procedures using PL/SQL, PLPgSQL, etc.
Experience in data integration and ETL
Experience with Docker and Kubernetes (or any orchestrator)
Experience with infrastructure as code, using CloudFormation, Terraform, etc.
Experience with distributed Data Warehouses is a plus
Experience in Graph-oriented technologies, semantic technologies is a plus
Knowledge of digital healthcare, genomics and digital image analysis is a plus
Good knowledge of software engineering best-practices, Agile, CI/CD
Good interpersonal and communication skills
Excellent level of English
A flexible, friendly and international working environment with a collaborative atmosphere
An exciting company mission that brings together science and technology to directly impact the lives of patients with life threatening illness.
A fast-growing company with plenty of opportunity for personal growth and development
A hard technical challenge to solve with exciting modern technology - cloud computing, Big Data, DevOps, machine learning
Location: HOME OFFICE (Massachusetts and the surrounding states, 2-3h from Boston)
Start: ASAP (or as agreed)
Contract type: permanent full-time
If you think you fit this position, please send a CV and a cover letter. Please note that incomplete applications will not be considered.
After an initial screening process, candidates will be invited for remote interviews. Selected candidates will then be invited for personal interviews.