Black Canyon Consulting LLC ยท 2 months ago
Database Architect (Cloud) for SRA
Black Canyon Consulting (BCC) is searching for a Database Architect with expertise in Cloud Technologies to support the National Center for Biotechnology Information (NCBI). The role involves designing, optimizing, and maintaining large-scale, distributed database systems for biomedical data resources, focusing on scalable architectures and cloud-native solutions.
ConsultingInformation TechnologyProject Management
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
Qualification
Required
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
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
Company
Black Canyon Consulting LLC
Black Canyon Consulting, LLC (BCC) is a privately held, Woman-Owned Small Business, whose team of professionals bring over 125 years of experience providing innovative, tactical, and strategic Program and IT Management Support Services.
H1B Sponsorship
Black Canyon Consulting LLC has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (8)
2024 (10)
2023 (1)
Funding
Current Stage
Growth StageRecent News
Washington Business Journal
2025-01-10
2024-10-29
Company data provided by crunchbase