Database Architect (Cloud) for SRA

The role

The Database Architect will design, optimize, and maintain large-scale, distributed database systems for NCBI. The role focuses on scalable database architectures, partitioning strategies, and cloud-native solutions for biomedical and public health research datasets.

What you will do

• Design and optimize cloud-based database architectures to support petabyte-scale biomedical datasets.
• Implement and manage database partitioning, sharding, and replication strategies.
• 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.

Required qualifications

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

Nice to have

• 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++)

Benefits

• medical, dental and vision coverage
• 401k plan with employer contribution
• paid holidays
• vacation
• tuition reimbursement

About the company

Black Canyon Consulting (BCC) is a professional service and technology focused organization.