Senior OLTP Architect, Applied Field Engineering/Field CTO

Snowflake6 days ago

Location

JP-Tokyo

Type

Full Time

Salary

USD 180,000 – 240,000

Level

Senior

Role

Senior Solutions Architect

Posted

Jul 8, 2026

Full TimeSenior

The role

Summary

Senior OLTP Architect at Snowflake's Solution Engineering organization, responsible for architecting and delivering transactional database solutions built on the Snowflake Data Cloud. This strategic role bridges product, engineering, and field teams to drive customer adoption of Snowflake Postgres capabilities across the Americas, requiring 5+ years of OLTP database architecture experience with strong presentation skills for technical and executive stakeholders.

What you'll do

Deliver Technical Architecture Expertise for Snowflake Postgres: Serve as the principal technical authority on Snowflake's Postgres capabilities and transactional features, articulating strategic advantages and technical applications to prospective clients. Conduct comparative analyses with competitor OLTP database offerings (Oracle, SQL Server) to position Snowflake's value proposition to technical decision-makers and stakeholders across the Americas region.

Design and Architect Transactional Solutions: Collaborate with cross-functional teams including product, engineering, and field organizations to architect OLTP solutions on the Snowflake Data Cloud. Translate client-defined success metrics and requirements into technical designs, addressing database migration strategies, indexing approaches, and transactional workload optimization specific to enterprise customer environments.

Lead Proof of Concepts and Technical Validation: Partner with Snowflake account teams and customer advocates to define, execute, and deliver Proofs of Concepts that validate Snowflake's OLTP capabilities. Ensure successful technical outcomes with comprehensive executive summaries, business value assessments, and demonstrations that quantify the benefits of adopting Snowflake's transactional platform for existing Postgres and legacy OLTP environments.

Address Technical Objections and Gap Analysis: Identify, analyze, and reconcile discrepancies between Snowflake's transactional methodologies and client-specific requirements. Provide comprehensive technical resolutions to customer concerns regarding database architecture, performance, security, privacy, and governance considerations for OLTP workloads on the Data Cloud platform.

Deliver Custom Demonstrations and Presentations: Develop and deliver bespoke demonstrations and technical content tailored to address specific client requirements for transactional features and use cases. Present to both technical and executive audiences through whiteboarding sessions, formal readouts, and interactive demos showcasing Snowflake's competitive advantages in the OLTP space.

Create Technical Thought Leadership Content: Develop and disseminate technical content to facilitate organizational growth and industry thought leadership, including blog articles, conference presentations, technical notebooks, demonstrations, and educational materials. Establish Snowflake's position as a leader in cloud-native OLTP architecture and transactional database innovation.

Support Sales Progression and Customer Adoption: Convey the strategic advantages and technical application of Snowflake Postgres capabilities during customer engagements and follow-up activities to facilitate sales progression. Function as a trusted technical consultant who accelerates customer adoption and drives commercial outcomes through deep architectural expertise and consultative guidance.

What we look for

Technical

OLTP Database TechnologiesIn-depth knowledge and hands-on experience with OLTP database platforms including Postgres, Snowflake, Oracle, SQL Server, or similar relational databases. Must understand transactional semantics, concurrency mechanisms, and performance tuning for high-transaction-volume environments.

Database Indexing and Query OptimizationAdvanced expertise in database indexing strategies for transactional workloads including B-tree indexes, partial indexes, and covering indexes. Knowledge of query execution plans, statistics-based optimization, and performance tuning for OLTP patterns and access patterns.

Cloud Data Platforms and ArchitectureUnderstanding of cloud data warehousing and analytics platforms, specifically Snowflake's architecture, SQL capabilities, and scaling characteristics. Knowledge of how Snowflake's compute and storage separation model applies to transactional workloads and OLTP optimization.

Database Security, Governance, and ComplianceKnowledge of database security principles, data privacy frameworks (GDPR, HIPAA), access control mechanisms, and governance features. Ability to articulate how Snowflake addresses enterprise security and compliance requirements for transactional data.

Enterprise Architecture and Solution DesignExperience designing end-to-end solutions that address enterprise requirements including scalability, reliability, disaster recovery, and multi-tenant considerations. Ability to create architecture diagrams, technical specifications, and design documents for complex OLTP systems.

Education

Bachelor's Degree RequiredBachelor's degree in any discipline is required for this position. The degree provides foundational knowledge and demonstrates commitment to continuous learning.

Master's Degree PreferredMaster's degree in Computer Science, Engineering, Mathematics, or related technical fields is preferred. Equivalent professional experience in database architecture, platform engineering, or technical leadership can substitute for advanced degree requirements.

Experience

OLTP Database Architecture5+ years of hands-on experience architecting, designing, and optimizing OLTP database systems. Proven expertise in transactional database platforms including Postgres, Oracle, SQL Server, or similar systems with deep knowledge of ACID compliance, concurrency control, and distributed transaction handling.

Enterprise Database MigrationPractical experience leading or supporting database migration projects from legacy OLTP systems to modern cloud platforms. Understanding of migration strategies, data validation, cutover planning, and post-migration optimization for transactional workloads.

Customer-Facing Technical LeadershipDemonstrated ability to work effectively with C-suite and technical stakeholders at enterprise customers. Experience positioning complex database technologies to non-technical audiences and building consensus around architectural decisions through clear communication and credibility.

Field CTO or Solutions EngineeringBackground in Field CTO, Solutions Architecture, or Sales Engineering roles demonstrating ability to balance technical rigor with commercial awareness. Experience accelerating deal progression through technical differentiation and customer success validation.

Skills

Required skills

Postgres Database Architecture5+ years of hands-on experience with Postgres including performance tuning, replication, backup and recovery, and optimization for transactional workloads. Deep understanding of Postgres indexing strategies, query planning, and configuration for high-concurrency environments.

OLTP System DesignExpertise in designing OLTP databases and transactional systems that support high-concurrency, low-latency operations. Knowledge of normalization, transaction isolation levels, locking mechanisms, and consistency models appropriate for mission-critical applications.

Technical Presentation and CommunicationExceptional ability to present complex database concepts clearly to both technical engineers and non-technical executives. Skill in creating compelling demos, conducting whiteboarding sessions, and tailoring technical messaging for different audience levels and business contexts.

SQL and Query OptimizationAdvanced proficiency with SQL including query writing, performance analysis, execution plan interpretation, and optimization techniques. Ability to analyze slow queries, identify performance bottlenecks, and recommend architectural changes to improve transactional throughput and latency.

Enterprise Data ArchitectureUnderstanding of enterprise data platforms, integration patterns, and how transactional systems fit within broader data ecosystems. Experience with ETL/ELT processes, data modeling, and analytics integration for organizations leveraging data clouds.

Customer Engagement and Consultative SellingAbility to understand customer business requirements, identify technical needs through discovery conversations, and propose solutions that address both technical and commercial objectives. Skill in handling technical objections with credibility and building long-term customer relationships.

Nice to have

Snowflake Platform Experience1+ years of practical hands-on experience with Snowflake including SQL, stored procedures, performance optimization, and administration. Familiarity with Snowflake's Native Apps framework, Iceberg table format, and dynamic table features for transactional workloads.

Competitive OLTP Database KnowledgeHands-on experience with Oracle, SQL Server, MySQL, or other enterprise OLTP platforms enabling comparative analysis and migration path recommendations. Understanding of feature parity, performance characteristics, and licensing models across competing database systems.

Database Migration LeadershipPractical experience leading or architecting multi-year database migration programs from legacy OLTP systems to cloud platforms. Knowledge of migration tools, cutover strategies, risk mitigation, and validation approaches for transactional data and applications.

Technical Leadership and MentoringPrevious formal or informal leadership experience guiding engineering teams, mentoring junior architects, or directing technical initiatives. Ability to influence technical direction, build consensus, and develop talent within engineering organizations.

Data Cloud and Analytics ExpertiseBackground in data warehouse architecture, analytics engineering, or business intelligence demonstrating understanding of how OLTP systems integrate with data platforms for reporting, analytics, and AI/ML workloads on the modern data stack.

Public Speaking and Thought LeadershipExperience speaking at industry conferences, publishing technical articles, or contributing to open-source projects. Demonstrated ability to shape industry narratives and establish credibility as a subject matter expert in database architecture and cloud data platforms.