Senior ClickHouse + AI Systems Architect

Looking for a senior ClickHouse + AI systems architect to help guide architecture and scaling decisions for a large-scale Audience Intelligence & AI Campaign Platform (40M+ records). Current stack includes Laravel/PHP, MySQL/Postgres operational databases, ClickHouse analytics layer, AI agent orchestration, large-scale filtering/search/indexing, and multi-channel campaign execution. Need REAL production experience with: * ClickHouse * distributed systems * CDC/data pipelines * query optimization * AI agent workflows * vector search/retrieval * high-volume analytics systems This is primarily an architecture/advisory role helping validate scaling strategy, ingestion pipelines, ClickHouse schemas, and AI orchestration decisions — not basic web development. Please include examples of production systems, scale handled, and specific ClickHouse experience.