Principal OLTP Architect for AI-Driven Systems

Showcify, Inc.; United States; Remote; USD 180,000 - 250,000; Full time

Job summary

Snowflake is seeking a Principal Software Engineer 2 to define and drive the architecture for OLTP across Snowflake Postgres, Unistore, and related infrastructure. You will lead critical decisions on transactions, storage, and scalability while shaping a low-latency, highly available platform for agent-driven workloads.

Ideal candidates bring 15+ years building databases or distributed systems, strong PostgreSQL expertise, and hands-on systems programming in C, C++, or Rust, with a track record

Qualifications

• 15+ years of experience in building databases or large-scale distributed systems.
• Deep expertise in OLTP, transactions, concurrency control, and high availability.
• Strong cloud infra knowledge for low-latency stateful services.
• Experience designing elastic, multi-tenant systems with safe lifecycle management.
• Proven track record taking ambitious systems to production at scale.

Responsibilities

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

Job description

Snowflake is seeking a Principal Software Engineer 2 to define and drive the architecture for OLTP across Snowflake Postgres, Unistore, and related infrastructure. You will lead critical decisions on transactions, storage, and scalability while shaping a low-latency, highly available platform for agent-driven workloads.

Ideal candidates bring 15+ years building databases or distributed systems, strong PostgreSQL expertise, and hands-on systems programming in C, C++, or Rust, with a track record