Skip to content
Black Canyon ConsultingBlack Canyon ConsultingBethesda, MD

Database Architect (Cloud) for SRA

Designs and optimizes cloud-based database architectures for petabyte-scale biomedical datasets, implementing partitioning, sharding, and query tuning. Requires 5+ years experience with SQL, cloud services, Linux scripting, and production database operations.

120k – 160k/yr
On-site5+ YOEDevOps / SRE

About the role

Duties & Responsibilities

  • Design and optimize cloud-based database architectures to support petabyte-scale biomedical datasets.
  • Implement and manage database partitioning, sharding, and replication strategies to ensure performance, scalability, and reliability.
  • Tune queries, schemas, and indexing strategies for high-throughput workloads.
  • Support production-level data operations in complex, high-availability environments.
  • Work with cross-functional teams to integrate cloud-native data services with pipelines and APIs.
  • Troubleshoot database performance issues and implement proactive monitoring solutions.

Core Expertise

  • 5+ years of professional database experience with large, distributed, or cloud-hosted databases.
  • Advanced proficiency in SQL: schema design, query optimization, indexing, stored procedures.
  • Deep knowledge of database partitioning and sharding strategies in cloud environments.
  • Hands-on experience with Linux/UNIX environments and scripting (Bash, Python).
  • Familiarity with cloud database services (AWS RDS, Aurora, Athena, Google BigQuery, or equivalent).
  • Experience operating databases in production with high concurrency and large-scale data ingestion.
  • Strong troubleshooting skills for performance bottlenecks, query execution plans, and distributed systems.

Preferred Qualifications

  • Experience with Microsoft SQL Server and advanced features (partitioning, indexing strategies).
  • Familiarity with bioinformatics databases or large scientific datasets.
  • Experience with containerized workloads (Docker) and orchestration (Kubernetes).
  • Knowledge of XML schemas and structured/unstructured data integration.
  • Exposure to Data Warehouse, Data Lake, or Data Lakehouse concepts.
  • Interest in learning Big Data platforms (Apache Spark, Hadoop) and data science tools (Jupyter).
  • Proficiency in additional programming languages (Python, C++).

Salary

$120,000 - $160,000

Skills

SQLAws RdsAmazon AuroraGoogle BigqueryLinuxBashPythonMicrosoft Sql ServerDockerKubernetes

Similar roles

DevOps / SRE jobs
Nominal

Baremetal Infrastructure Engineer

NominalNew York, NY +3

Deploy and support Nominal's self-hosted platform in customer environments including air-gapped and regulated sites. Own Linux, Kubernetes, and bare-metal infrastructure reliability while partnering directly with customer IT and security teams.

120k – 230k/yr
On-site5+ YOEDevOps / SRE
LiveKit

Distributed Systems Engineer

LiveKitUnited States

As a Senior/Staff Distributed Systems Engineer, you will design and evolve core control, data, and observability systems for LiveKit's platform, focusing on latency, availability, and operational simplicity. You will implement resilient architectures and build tools to enhance reliability and developer velocity.

120k – 250k/yr
Remote5+ YOEDevOps / SRE
Metriport

Software Engineer, Internal Tools

MetriportSan Francisco, CA

Build and maintain internal tooling and automations to improve operational efficiency across engineering, operations, and business teams. Own end-to-end integrations, developer experience improvements, and security-compliant tool adoption.

120k – 160k/yr
On-site3+ YOEDevOps / SRE
Tessera Labs

Systems Engineer - SaaS

Tessera LabsSan Jose, CA +1

Designs, modernizes, and migrates CRM platforms like Salesforce in large enterprises, focusing on Data Cloud, Agentforce, and ERP integrations such as SAP via MuleSoft. Requires 3+ years hands-on Salesforce development and CRM migration experience.

120k – 180k/yr
Hybrid3+ YOEDevOps / SRE
Tessera Labs

Systems Engineer – Oracle ERP

Tessera LabsSan Jose, CA +1

Delivers and modernizes Oracle ERP systems (EBS R12 and Fusion Cloud) at client sites using Tessera AI platform for migrations, customizations, integrations, and troubleshooting across financials, procurement, and supply chain modules. Requires hands-on expertise in Oracle tools and AI-driven automation.

120k – 180k/yr
HybridDevOps / SRE