Principal Software Engineer 2 - OLTP
Principal Engineer · Principal · Full Time
Opens Snowflake's application page
Role
What you'll do.
Principal Software Engineer 2 - OLTP is a staff-level architecture role at Snowflake leading the design and development of next-generation transactional database systems. This position requires deep expertise in OLTP systems, distributed database architecture, cloud infrastructure, and 15+ years of experience building large-scale database or infrastructure systems. The role involves architecting transactional systems optimized for agent-driven workloads while integrating with Snowflake's cloud-native data platform.
Responsibilities
- Define and Drive Long-Term Technical Architecture: Establish comprehensive technical direction for OLTP systems across Snowflake Postgres, Unistore, and underlying cloud infrastructure, making strategic decisions that shape product direction for years to come.
- Lead Architectural Decision-Making: Make critical architectural choices across transactions, storage engines, concurrency control, replication, recovery mechanisms, query execution strategies, and database scalability to optimize for agent-driven workloads.
- Design Compute and Storage Infrastructure: Engineer low-latency, highly available transactional systems with optimized resource isolation, elasticity, networking, caching strategies, and container infrastructure to support rapid operational requirements.
- Build Agent-Optimized Database Primitives: Develop specialized database capabilities for autonomous agent workloads, including fast isolated transactional environment creation, checkpointing, rollback mechanisms, and efficient lifecycle management.
- Design Safe Agent State Management: Architect secure mechanisms for agents to read and modify operational state with strong consistency guarantees, recovery assurances, access control policies, and governance frameworks.
- Evaluate PostgreSQL Architecture and Innovation: Assess where PostgreSQL architecture provides strategic advantage versus where novel approaches deliver superior performance and capabilities for Snowflake's specific use cases.
- Design for Programmatic Database Operations: Create systems architecture enabling databases and transactional environments to be created, provisioned, and operated at machine speed through programmatic interfaces rather than manual administration.
- Lead Cross-Organizational Engineering Efforts: Direct complex, multi-team technical initiatives, establishing technical standards and strategic direction across multiple engineering organizations and product areas.
- Collaborate with Leadership and Customers: Work closely with product leaders, senior engineering executives, and strategic enterprise customers on critical technical decisions and product roadmap planning.
- Raise Technical Excellence Standards: Elevate engineering quality through architecture reviews, technical mentoring, and hands-on involvement in solving the organization's most challenging systems problems.
Qualifications
What we look for.
Technical
Systems Programming
Strong systems programming capability with preferred experience in C, C++, or Rust for performance-critical infrastructure development.
Distributed Systems Architecture
Comprehensive understanding of distributed system design patterns, consensus protocols, replication strategies, and fault tolerance mechanisms.
Transaction Processing
Advanced knowledge of transaction semantics, isolation levels (ACID properties), MVCC (Multi-Version Concurrency Control), and conflict resolution strategies.
Query Execution and Optimization
Expertise in query planning, execution engines, indexing strategies, cost-based optimization, and performance profiling for analytical and transactional workloads.
Storage Engine Design
Deep understanding of storage layer architecture, buffer management, compression techniques, WAL (Write-Ahead Logging), and persistent data structure optimization.
Concurrency Control Mechanisms
Advanced knowledge of locking strategies, optimistic concurrency control, timestamp-based ordering, and contention resolution in multi-threaded database systems.
Database Recovery and High Availability
Expertise in crash recovery algorithms, log-based recovery, replication topologies, failover mechanisms, and ensuring durability guarantees.
Education
Computer Science or Related Field
Bachelor's degree in Computer Science, Computer Engineering, or equivalent practical experience demonstrating mastery of computer systems fundamentals.
Advanced Systems Knowledge
Evidence of continued advanced education through professional development, published technical work, open-source contributions, or architectural documentation.
Experience
Database and Distributed Systems Experience
15+ years building databases, distributed systems, storage systems, or large-scale cloud infrastructure with demonstrated sustained impact at significant technical scope and scale.
OLTP and Database Systems Expertise
Deep technical proficiency in OLTP systems with specialized knowledge across transactions, concurrency control, storage engines, indexing, query processing, replication, recovery, and high availability patterns.
Cloud Infrastructure Knowledge
Strong understanding of cloud infrastructure architecture for low-latency stateful systems, including compute optimization, storage strategies, networking, resource isolation, and failure handling.
Elastic Multi-Tenant Systems Design
Proven experience designing highly elastic, multi-tenant, or rapidly provisioned stateful systems where isolation boundaries and efficient lifecycle management are fundamental architectural concerns.
AI and Agent System Architecture
Strong instincts for how database architecture must evolve to support AI-native applications and autonomous agents, including ephemeral state management, sandboxing, safe transactional actions, and programmatic lifecycle control.
Architectural Trade-off Analysis
Track record of making difficult architectural decisions balancing latency, throughput, consistency, availability, durability, scalability, isolation, and cost considerations.
Production Systems at Scale
Documented history of taking technically ambitious systems from architecture and design through successful production deployment at meaningful scale.
Technical Leadership and Influence
Demonstrated ability to influence and establish technical direction across multiple teams or broad product areas, with clear examples of technical leadership impact.
PostgreSQL Expertise
Deep PostgreSQL knowledge representing a significant advantage, or equivalent expertise building other sophisticated transactional or distributed database systems.
Skills
Required
Database Architecture Design
Strategic ability to design complete database systems balancing performance, scalability, reliability, and developer experience across multiple layers of the stack.
Systems Engineering
Ability to work effectively across multiple abstraction levels from low-level database internals through distributed infrastructure, understanding interdependencies and optimization opportunities.
Technical Communication
Exceptional ability to communicate complex technical concepts clearly to engineers, executives, and customers, influencing decisions through articulate technical reasoning.
OLTP Systems Expertise
Deep knowledge of Online Transaction Processing systems, including concurrency control, indexing, query optimization, and low-latency response requirements.
Distributed Systems Design
Proficiency designing highly reliable distributed systems with clear understanding of consistency models, partition tolerance, replication strategies, and failure recovery.
Technical Leadership and Mentorship
Demonstrated ability to lead complex technical initiatives, mentor engineers, establish technical standards, and influence product direction across organizational boundaries.
Cloud Infrastructure Architecture
Deep understanding of cloud-native systems design, container orchestration, resource isolation, auto-scaling, and infrastructure-as-code principles.
Architectural Trade-off Analysis
Expert judgment in evaluating and making difficult architectural decisions considering latency, throughput, consistency, availability, scalability, and cost implications.
Preferred
PostgreSQL Internals
Nice to haveSpecialized knowledge of PostgreSQL architecture, query planning, storage format, concurrency mechanisms, and extension points for custom functionality.
Machine Learning and Agent Systems
Nice to haveUnderstanding of ML/AI system requirements, autonomous agent architecture, state management for agents, and integration patterns with data platforms.
Multi-Tenant Database Systems
Nice to haveExperience designing databases that serve multiple tenants with strong isolation guarantees, resource quotas, and efficient data separation strategies.
Programmatic Infrastructure
Nice to haveExperience designing systems intended for programmatic control and operation at scale, including API-first design and machine-driven provisioning.
Rust Systems Programming
Nice to haveProficiency in Rust for systems programming, understanding of memory safety guarantees, and experience with Rust for performance-critical infrastructure.
Open Source Contributions
Nice to haveActive involvement in open-source database or infrastructure projects, demonstrating commitment to the engineering community and collaborative development.
Published Technical Work
Nice to havePublished papers, technical blogs, conference presentations, or architectural documentation demonstrating thought leadership in database systems or distributed infrastructure.
Enterprise Data Platform Experience
Nice to haveBackground working on enterprise-scale data platforms integrating analytics, governance, and operational capabilities across diverse workloads.
Compensation
Pay and benefits.
Base·USD 304,000 – 380,000
Equity·Stock options
Benefits
Comprehensive Health Coverage
Medical, dental, and vision insurance plans with options to cover employee and family members, supporting overall wellness and preventative care.
Retirement Planning
401(k) retirement savings plan with employer matching contributions, helping engineers build long-term financial security.
Equity and Stock Options
Competitive equity grants as part of total compensation package, allowing participation in Snowflake's continued growth and success as a public company.
Flexible Time Off
Generous paid time off policy with flexibility to manage personal needs, vacation, and work-life balance effectively.
Professional Development
Opportunities for continuous learning through training programs, conference attendance, technical certifications, and access to advanced professional development resources.
Wellness Programs
Comprehensive wellness initiatives including fitness benefits, mental health support, nutrition programs, and resources for maintaining physical and mental well-being.
Parental Leave
Competitive parental leave benefits supporting work-life integration for employees welcoming new family members.
Home Office Support
Resources and equipment allowances for setting up productive home office environments, supporting flexible and remote work arrangements.
Full posting
Original listing.
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 - OLTP
Snowflake 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 tradeoffs across latency, throughput, consistency, availability, durability, scalability, isolation and cost.
A track record of taking technically ambitious systems from architecture through production at meaningful scale.
Experience influencing technical direction across multiple teams or a broad product area.
Strong systems engineering instincts and the ability to work across abstractions, from database internals to distributed infrastructure.
Deep PostgreSQL expertise is a strong advantage, but experience building other sophisticated transactional or distributed database systems is equally relevant.
Strong systems programming experience; C, C++, or Rust experience is a plus.
Exceptional technical judgment and communication skills, including the ability to influence engineers, executives and customers.
Why Join Snowflake Engineering
Define the architecture of a major expansion of Snowflake into transactional and operational workloads.
Work on fundamental database and distributed-systems problems spanning transactions, storage, compute and cloud infrastructure.
Build transactional systems designed for a new generation of applications and agents.
Influence Snowflake Postgres, Unistore and how transactional systems integrate with Snowflake's broader Data & AI platform.
Have technical impact at a scope where architectural decisions can shape Snowflake's product direction for years.
Every Snowflake employee is expected to follow the company’s confidentiality and security standards for handling sensitive data. Snowflake employees must abide by the company’s data security plan as an essential part of their duties. It is every employee's duty to keep customer information secure and confidential.
Snowflake is growing fast, and we’re scaling our team to help enable and accelerate our growth. We are looking for people who share our values, challenge ordinary thinking, and push the pace of innovation while building a future for themselves and Snowflake.
How do you want to make your impact?
For jobs located in the United States, please visit the job posting on the Snowflake Careers Site for salary and benefits information: careers.snowflake.com
Redirects to Snowflake's application page.
Other roles
More at Snowflake.
Staff Software Engineer – Engineering Systems, Continuous Integration Team
Staff
Account Engineer
Mid
Principal Software Engineer - Elastic Global Services
Principal
Director of Engineering - Traffic & Networking
Director
Senior Software Engineer
Senior