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.
About the job
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
SQL, Aws Rds, Amazon Aurora, Google Bigquery, Linux, Bash, Python, Microsoft Sql Server, Docker, Kubernetes
Similar jobs
DevOps / SRE jobs
Fusion Health
Woodbridge, NJ
Owns secure, scalable Azure infrastructure for healthcare applications, including cloud migrations, Terraform-based automation, CI/CD pipelines, monitoring, and compliance. Requires 3–5+ years of Azure experience and strong DevOps and cloud-security expertise.
Kong
United States
Operate and scale Kong’s multi-region SaaS platform across major cloud providers, Kubernetes, and distributed data systems. The role requires strong infrastructure automation, observability, CI/CD, and production reliability experience, with participation in a global on-call rotation.
PagerDuty
Atlanta, GA
Operates and evolves foundational networking, compute, Kubernetes, and ingress infrastructure for PagerDuty’s real-time platform. Requires 3+ years in SRE, DevOps, or platform engineering, with Linux production operations, cloud infrastructure, programming, and Infrastructure as Code experience.
Mercor
San Francisco, CABuilds and scales highly available infrastructure using AWS, Terraform, and Docker to support rapid growth and AI workloads. Collaborates with product and research teams on architectures, CI/CD, monitoring, and performance optimization.
Mercor
San Francisco, CA
Build and operate Mercor’s enterprise agent platform across security, routing, isolated execution, orchestration, deployment, and production scalability. The role requires 5+ years building high-scale platforms, architectural ownership, and experience with core infrastructure primitives across multiple clouds.