> Markdown version of [/jobs/ext/1894603-staff-application-database-architect](https://www.wearedevelopers.com/jobs/ext/1894603-staff-application-database-architect). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Staff Application Database Architect - **Company:** HeartFlow, Inc - **Location:** San Francisco, CA, United States - **Experience:** Expert - **Salary:** $190,000.0 - $250,000.0 - **Contract:** Permanent contract - **Skills:** Third Normal Form, Artificial Intelligence, Airflow, Amazon Web Services, Amazon S3, Data Analysis, Systems Engineering, Backup Devices, Cloud Computing, Cyber Security, Databases, Data Architecture, Extract Transform Load (ETL), Data Security, Data Systems, Data Warehousing, Database Applications, Relational Databases, Dicom, Django Web Framework, Python (Programming Language), PostgreSQL, Memcached, MySQL, Operational Data Store, Online Transaction Processing, Performance Tuning, Query Optimization, Redis, Reference Data, Application Data, SQLAlchemy, Transaction Data, Web Applications, Web Services, Amazon ElastiCache, Fast Healthcare Interoperability Resources, Apache Spark, Caching, Database Performance, Indexer, Backend, Data Layers, Data Lakes, Information Technology, Health Level Seven International, Operational Systems, Physical Data Models, Virtual Agents - **Published:** August 1, 2026 - **Apply:** https://www.dice.com/job-detail/3980e480-7b71-47f7-a564-76f1416d1ada ## About the Role * OLTP Database Engineering (Primary): Deep, hands-on expertise in relational databases (PostgreSQL, MySQL, Aurora, or equivalent) supporting production web applications - schema design, query optimization, indexing, partitioning, replication, and HA/DR. * Application & Web Service Data Access: Strong experience building backend data layers for web applications and services in Python, with expert-level fluency in SQLAlchemy and/or the Django ORM. Deep understanding of connection pooling, caching (Redis/Memcached), transaction management, and common ORM pitfalls at scale. * Data Modeling: Expert-level conceptual, logical, and physical modeling for transactional/OLTP workloads (3NF or equivalent), including modeling for healthcare/clinical domains. * Database Engineering & DBA Leadership: Performance tuning, partitioning, indexing strategy, replication, HA/DR, and operational excellence for production relational databases. * Cloud Platforms: Building data systems in modern cloud ecosystems - AWS preferred (RDS/Aurora, ElastiCache, etc.) - with a strong grasp of cost, security, and reliability tradeoffs at scale. * Healthcare Data & Compliance: Working with clinical, imaging, or device data under regulatory regimes such as FDA, HIPAA, and GDPR; familiarity with healthcare data standards (e.g., FHIR, HL7, DICOM) is a strong plus. * Technical Leadership: Mentoring senior engineers, driving cross-team architectural decisions, establishing engineering standards, and influencing technology selection across multiple teams and programs. Nice to have (bonus, not required): * Analytics / Data Lake Exposure: Familiarity with Data Lake or lakehouse concepts (e.g., S3, Glue, Spark, Airflow) for the minor analytics-handoff portion of the role. * AI Enablement & Semantic Data: Exposure to metadata, schema registries, ontologies, or semantic layers that make data usable by AI/agentic systems., * Bachelor's degree in Computer Science, Engineering, or a related discipline, or equivalent experience. Master's preferred. * 10+ years of relevant industry experience as a backend/application database engineer or data architect, with deep, hands-on OLTP experience supporting production web applications or web services. Data warehousing/ETL experience is a plus. ## Description As a Staff Application Database Architect, you will be the backend database expert behind the production applications and web services that power Heartflow's clinical and operational platform. This is a hands-on role: the majority of your time will be spent designing OLTP schemas, writing and tuning high-performance queries, and working directly inside our Python/Django services to solve real data access problems - alongside setting the architectural direction for how clinical, imaging, and operational data is structured, accessed, and governed across our AWS-based platform. Exposure to Data Lake, analytics pipelines, or AI-enablement work is a plus., * Design, Build & Own OLTP Database Systems: Take hands-on ownership of the transactional (OLTP) databases powering Heartflow's clinical and operational applications. Design schemas, write and optimize complex queries, and directly implement performance improvements - indexing, partitioning, connection pooling, caching - for high-throughput, low-latency web services. * Drive Application Data Access & ORM Strategy: Define and implement best practices for how our Python/Django services interact with the database via the Django ORM. Solve real-world problems like N+1 queries, lazy-loading pitfalls, transaction isolation, connection pool exhaustion, and read/write splitting; review and directly contribute to high-impact schema and query changes in application code. * Own Database Performance & DBA Excellence: Set direction for database operations - uptime, capacity, backups, recovery, schema evolution, and incident response. Establish SLOs, observability, and runbooks; partner with engineering and SRE teams to keep mission-critical clinical workloads fast, reliable, and secure. * Lead Transactional Data Modeling: Own conceptual, logical, and physical data models for our operational systems. Drive consistent representation of patients, studies, cases, results, and devices, and steward the master and reference data needed for high-integrity clinical applications. * Advance the Semantic Structure for AI Agent Context: Contribute to enriching Heartflow's transactional data model with semantics - metadata and controlled vocabularies - so AI agents and downstream consumers can reliably retrieve and reason over clinical and operational information. * Champion Compliance, Security & Privacy: Ensure data architectures, flows, and access controls strictly adhere to FDA, HIPAA, GDPR, and other applicable standards. Partner with Quality, Regulatory, InfoSec, and Privacy teams to embed compliance into the data lifecycle by design. * Support the Data Lake & Analytics Handoff (minor, bonus scope): For candidates with the background, partner with IT, Research, and Systems Engineering to ensure OLTP source systems produce clean, well-modeled data that feeds downstream Data Lake and analytics pipelines. This is a supporting responsibility for the right candidate, not a requirement of the role. * Advance the Semantic Structure for AI Agent Context (minor, bonus scope): For candidates with the background, contribute to enriching Heartflow's transactional data model with semantics - metadata and controlled vocabularies - so AI agents and downstream consumers can reliably retrieve and reason over clinical and operational information. Skills Needed, * Application-Grade Data Systems: Building rock-solid transactional databases that real clinicians and applications depend on every day. * Engineering Excellence: Championing high-quality data systems, rigorous review and testing practices, and elevating the technical baseline of the team. * Hands-On Ownership: Staying close to the code and the query plan - you'd rather fix the slow query yourself than just write a standard for it. * Constructive Collaboration: Fostering open communication across Engineering, IT, Research, and Systems Engineering, and guiding healthy technical debates that result in better outcomes. ## Related Videos - [ZEISS & Microsoft - Building the Next Generation Medical Ecosystem in the Cloud](https://www.wearedevelopers.com/videos/424-zeiss-microsoft-building-the-next-generation-medical-ecosystem-in-the-cloud) - [MySQL Protocol Features You Should Be Aware Of](https://www.wearedevelopers.com/videos/100267-mysql-protocol-features-you-should-be-aware-of) - [Reducing LLM Calls with Vector Search Patterns - Raphael De Lio (Redis)](https://www.wearedevelopers.com/videos/1714-reducing-llm-calls-with-vector-search-patterns-raphael-de-lio-redis) - [Modern Data Architectures need Software Engineering](https://www.wearedevelopers.com/videos/1030-modern-data-architectures-need-software-engineering) - [Coding for Good: Achieving social change with an app](https://www.wearedevelopers.com/videos/1645-coding-for-good-achieving-social-change-with-an-app) - [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works) ## Related Articles - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers) - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [The Most Popular IT Jobs on the Market](https://www.wearedevelopers.com/magazine/376-the-most-popular-it-jobs-on-the-market) - [Is Software Engineering Over-Saturated?](https://www.wearedevelopers.com/magazine/418-is-software-engineering-over-saturated) - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [7 Most Popular Web Developer Jobs in Europe](https://www.wearedevelopers.com/magazine/163-7-most-popular-web-developer-jobs-in-europe)