Peter Plachta Email & Phone Number

San Jose, Ca, Us

San Jose, Ca, Us

Mountain View, Ca, Us

New York City, New York, Us

I am a direct SVP report and architect for what we call 'metadata management' at Celonis: these are 77 applications workloads, their stability, performance, security and scalability.* analytics read only workloads* ETL support, heavy write, 100+ QPS* machine learning, vectorized processing* large Json object management* low latency (< 10 ms), high read workloadsI established KPIs and SLAs, monitoring and enforcement to support workloads.I created an observability portfolio with dashboards and automated alerts* connectivity: p50/p99, bottleneck measurements due to (i) server issues, (ii) application issues* query timeouts, separate R+W query metrics and alerts* system overload due to CPU/memory/disk with automated alerts* high IO vs high CPU query determination* automated long running AND deadlock query plan collection* dashboards for everything aboveI continue to analyze and remove scaling and performance bottlenecks* IO due to Postgres garbage collection: UUID random keys replaced with UUID v7* bottlenecks due to excessive writes: index reduction, primary key reduction, workload refactoring, query optimization, partitioning (range + hash)* deadlocks due to parallel delete queries: deletions moved to a batch model; global lock and leader election*system re-design for non-Sql workloads running in Postgres: heavy Json/blob usage, Key-Value store workloads* architectural guidance for future application changes* global data (global table) design in Postgres; currently supports low QPS, long term proposal to use CocroachDbGeneral education for 76 application teams (400+ developers)* office hours, architecture board hours, design reviewer, education sessions, Slack channel for Q&A, complete documentation with examplesFuture design and POCs* caching improvements using Redis (POC complete)* Json improvements using ElasticSearch (POC complete)* global tables and horizontal scaling using CocroachDb (POC complete)

New York City, New York, Us

I work on architecting and scaling metadata at Celonis. We run a large worldwide PostgreSQL fleet with a mixed workload and high r/w QPS. Scaling such a system in a data-informed way is an incredibly interesting and challenging systems problem.

New York City, New York, Us

Mountain View, Ca, Us

Mountain View, Ca, Us

Armonk, New York, Ny, Us

I am architecting Multitenancy in Db2: this allows logical databases sharing a single Db2 instance and its physical resources while maintaining isolation and separate security. This is required for Cloud and Netezza customers.I am architecting Catalog Services in Db2 to provide online upgrade capabilities with minimal outage. This is a requirement for Warehouse, Cloud and 24/7 availability.I am also architect for Text Search and Spatial in Db2.

Armonk, New York, Ny, Us

I'm currently working on a Hybrid Transactional/Analytical Workload (HTAP) project at IBM.My past project was delivering Db2 EventStore -- a highly available IoT store designed for 1 million row/second ingest speeds and real-time analytics in Open Apache Parquet data format.The data stored is immutable, can be accessed by external readers and features a novel LSM index and synopsis data to optimize query speeds

Seattle, Wa, Us

Senior software engineer in Amazon AWS' Aurora PostgreSQL offering.

Seattle, Wa, Us

My responsibilities include:* mentoring junior members* redesign of MySQL's physical logging and replication* redesign of MySQL's Out-of-memory handling* highly performant, distributed algorithms for replication

My responsibilities include:* keeping up with current research, especially in the area of Log Structured Merge trees* design of highly efficient algorithms for indexing and searching Log Structured Merge trees* redesign of memory handling in Postgres* quality and performance improvements in a massive lock-free in-memory SQL based store

Armonk, New York, Ny, Us

Locking co-architect in DB2 pureScale.deepCompression co-architect in DB2 LUW.Currently, owns Locking in DB2 LUW.

deepCompression project lead - loss-less data compression in DB2.

Dynamically sized caches in DB2.Autonomic and predictive buffer pool cleaning in DB2.Victim selection algorithms.Storage subsystems.TPCC benchmark optimizations in the storage layer.

Master'S Degree, Physics

Bachelor'S Degree, Physics And Computer Science