# Database Architect (Cloud) for SRA

**Company:** [Black Canyon Consulting](https://hotfix.jobs/companies/blackcanyonconsulting)
**Location:** Bethesda, MD
**Role:** DevOps / SRE
**Salary:** $120k – $160k/yr
**Experience:** 5+ years
**Skills:** SQL, Aws Rds, Amazon Aurora, Google Bigquery, Linux, Bash, Python, Microsoft Sql Server, Docker, Kubernetes
**Posted:** 2026-02-20

> 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.

## Job Description

## 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

## Similar roles

- [Baremetal Infrastructure Engineer](https://hotfix.jobs/jobs/512457ea-552b-41f5-b221-e6676afd807f) - Nominal - New York, NY - $120k – $230k/yr
- [Distributed Systems Engineer](https://hotfix.jobs/jobs/ab6d684b-b8b2-40a3-a957-34e9084aac73) - LiveKit - Remote - $120k – $250k/yr
- [Software Engineer, Internal Tools](https://hotfix.jobs/jobs/326e954a-0256-4db1-b40c-efa6903c47b1) - Metriport - San Francisco, CA - $120k – $160k/yr
- [Systems Engineer - SaaS](https://hotfix.jobs/jobs/fecc1d43-5057-4f7b-8b57-0f5d76b8afaa) - Tessera Labs - San Jose, CA - $120k – $180k/yr
- [Systems Engineer – Oracle ERP](https://hotfix.jobs/jobs/14ba77b4-9e65-4f54-9473-446c42b10a22) - Tessera Labs - San Jose, CA - $120k – $180k/yr

**Apply:** https://hotfix.jobs/jobs/29c9bca9-11e5-4cbb-8936-269e9a669e84
**Canonical:** https://hotfix.jobs/jobs/29c9bca9-11e5-4cbb-8936-269e9a669e84