Massachusetts Veterans Jobs

MassHire JobQuest Logo

Job Information

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.

Requirements

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

Benefits

  • 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

Application process

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.

DirectEmployers