Principal Software Engineer 2 - OLTP

At Snowflake, we are powering the era of the agentic enterprise. To usher in this new era, we seek AI-native thinkers across every function who are energized by the opportunity to reinvent how they work. You don’t just use tools; you possess an innate curiosity, treating AI as a high-trust collaborator that is core to how you solve problems and accelerate your impact. We look for low-ego individuals who thrive in dynamic and fast-moving environments and move with an experimental mindset — who rapidly test emerging capabilities to discover simpler, more powerful ways to deliver results. At Snowflake, your role isn't just to execute a function, but to help redefine the future of how work gets done.

Principal Software Engineer 2 - OLTPSnowflake is building the next generation of transactional systems for applications, AI and agents. Across Snowflake Postgres and Unistore, we are combining the performance, reliability and developer experience expected from modern operational databases with Snowflake's cloud-native architecture and governed data platform.

We're looking for a Principal Engineer 2 to help define and drive the architecture across database internals, storage, compute and cloud infrastructure. A core part of the role is designing transactional systems for agent-driven workloads, where isolated state, rapid database lifecycle, safe autonomous operations, and deep integration with enterprise data are first-class requirements.

What You'll Do- Define and drive the long-term technical architecture for OLTP across Snowflake Postgres, Unistore and the infrastructure they depend on.

• Lead major architectural decisions across transactions, storage, concurrency control, replication, recovery, query execution and database scalability.

• Shape the compute and storage architecture for low-latency, highly available transactional systems, including resource isolation, elasticity, networking, caching and container infrastructure.

• Build database primitives for agent-driven workloads, including fast creation of isolated transactional environments, checkpointing and rollback, and efficient lifecycle management.

• Define how agents safely read and modify operational state, with strong guarantees around consistency, recovery, access control and governance.

• Determine where PostgreSQL architecture and compatibility provide leverage and where alternative approaches can deliver meaningful advantages.

• Design for workloads where databases and transactional environments are created and operated programmatically at machine speed rather than primarily through human administration.

• Lead complex, cross-organizational engineering efforts and establish technical direction across multiple teams.

• Work closely with product leaders, senior engineering leadership, and strategic customers on the most important technical and product decisions.

• Raise the technical bar through architecture reviews, mentoring and hands-on leadership on the hardest systems problems.

What We're Looking For- 15+ years of experience building databases, distributed systems, storage systems or large-scale cloud infrastructure, with sustained impact at significant technical scope.

• Deep expertise in OLTP and database systems, including areas such as transactions, concurrency control, storage engines, indexing, query processing, replication, recovery and high availability.

• Strong understanding of cloud infrastructure for low-latency stateful systems, including compute, storage, networking, resource isolation and failure handling.

• Experience designing highly elastic, multi-tenant, or rapidly provisioned stateful systems where isolation and efficient lifecycle management are first-class concerns.

• Strong instincts for how database architecture should evolve for AI-native applications and autonomous agents, including ephemeral state, sandboxing, safe transactional actions and programmatic database lifecycle.

• Experience making difficult architectural tr...