I'm Vonng

Vonng

PostgreSQL Expert at TanTan

PostgreSQL DBA, Full-stack developer, Backend Architect @ Apple, TanTan, Alibaba. PostgreSQL ACE, Translator of two books: Designing Data-Intensive Applications & PostgreSQL Internal.

Developer
Architect
DBA
SRE
Analyst
Contributor

Skills

PostgreSQL
PostgreSQL

Everything about PostgreSQL: admin, monitoring, application development, data recovery, extension development, SQL optimizing, etc…"
Go
Go

Primary development language. Write robust, maintainable programs: web servers, crawlers, exporters, cli utils, etl pipeline, etc…
Database
Database

Rich experience on various data systems: Redis, HBase, MongoDB, Cassandra, Elasticsearch, Timescaledb, Kafka, MySQL, SQL Server, ODPS, Consul, Etcd, etc..
Domain Knowledge
Domain Knowledge

Extra domain knowledge about: Web Frontend/Backend, Networking, Manufacturing, GIS, Meteorology, Info Sec
Data Analysis
Data Analysis

Write advanced SQL queries. Data analysis with statistic tools: SQL, Python, R, Matlab, Excel etc…
Visualization
Visualization

Rich experience on making interactive visualization products with D3.js, echarts.js, grafana panels, etc…
Ansible
Ansible

Handy DevOps tools for daily use. Writing sophisticated roles and playbooks. orchestration and maintain production environment in a declarative way
Linux
Linux

Using as the main operating system. familiar with *nix tools such as bash vim git awk sed grep systemd ntp ssh dns etc…
Cloud Service
Cloud Service

Familiar with most of the cloud service, such as S3, RDS, ECS, etc…
Grafana
Grafana

Designing sophisticated application with Grafana. Deeply customize, write plugins, advanced visualization.
Prometheus
Prometheus

Setup & configure Prometheus. Desinging record & alert rules. Writing PromQL Queries. Writing metric exporters.
Kubernetes
Kubernetes

Deploying and managing application on kubernetes, including kubernetes itself.
Nginx
Nginx

Configuring nginx, writing lua scripts for OpenResty. Customize API gateway such as Kong. And other LB such as haproxy
Python
Python

Handy tools for daily use: solving trivial tasks. automation, crawlers. data process & analysis, web servers, AI models, etc…
Javascript
Javascript

Writing frontend & backend application with js. experience with common js libs: Jquery, Bootstrap, EazyUI and HTML, CSS, GraphQL, etc…
C# & Java
C# & Java

Writing entriprise application with Java. Forge windows UI programs with C#
C/C++
C/C++

Basic C/C++ programming skills. For source code reading purpose
Matlab
Matlab

Scientific tasks, neural network modeling, celluar automation simulation with Matlab

Experiences

1
TanTan Co. Ltd

Dec 2017 - Present, Beijing

Tinder in China. The second largest stranger social platform in China

PostgreSQL Expert

Nov 2019 - Present

  • Research & Developement about PostgreSQL
  • Building Infrastructure for DBA and Developers
PostgreSQL DBA

Dec 2017 - Dec 2018

  • Database Administration
Software Developer ICT4
Apple, APO (ShangHai) Co. Ltd

Dec 2018 - Jun 2019, ShangHai

Aple deliver the best phone in the world! And we deliver best factory monitoring & tracing system for Apple!

Responsibilities:
  • Trace for iPhone
  • Trace datawarehouse
  • Trace database administration
2
3
Alibaba (Beijing) Co. Ltd

Jue 2014 - Dec 2017, Beijing

BA-BA, ALI-BABA ABA-ABA

Full Stack Developer

Aug 2015 - Dec 2017

  • Project Finplus
  • Project Oplus
  • Umeng Data Platform
  • Knowledge Database
Algorithm Engineer (Intern)

Jue 2014 - Sep 2014

  • Designing and maintain Index for Cloud Recommendation System

Projects

DDIA
DDIA
Owner 2018

Chinese translation version of 《Designing Data-Intensive Application》

Star
PG Internal
PG Internal
Owner 2018

Chinese translation version 《PG Internal》. A book about PostgreSQL Kernel

Details
FDW Paper
FDW Paper
Co-Author June 2017

Unified Access Layer with PostgreSQL FDW for Heterogeneous Databases, NPC2017

Star
Pigsty
Pigsty
Owner March 2019 - Present

Best Postgres Montoring System ever. Along with a provisioning solution for HA postgres clusters.

Details
Capslock
Capslock
Owner 2016

Transform Capslock into a versatile function key, improve your productivity tremendously!

Star
ACDAT in Go
ACDAT in Go
Owner 2018

Aho-Corasick Automaton with Double Array Trie. Multi-String substitute simultaneously.

Star
PG Exporter
PG Exporter
Owner March 2019 - Present

Prometheus exporter for PostgreSQL metrics. Completly customizible

Star
MaxCompute Go SDK
MaxCompute Go SDK
Original Owner 2017

Golang SDK for alibaba’s datawarehouse MaxCompute (Original name is ODPS)

Star
Postgres Nodes
Postgres Nodes
Owner Dec 2017 - Now

Notes and articles about postgres. (including a minimal sandbox environment)

Star
ISD - Historic Meteorogly Visualization
ISD - Historic Meteorogly Visualization
Owner Sep 2020

Fetch, parse, visualize NOAA ISD Dataset. Sub-hourly observation records of 30000 meteorology station from 1900-2020.

Star
iTunes Search API for Golang
iTunes Search API for Golang
Owner Sep 2017

Golang wrapper for iTunes Search API. Can be used for crawler. Also Provides a binary tool for quick search.

Star
Adcode
Adcode
Owner Sep 2017

China Administrative Division Data. 5 level data with geo fences. Join from Stats.gov, Ministry of Civil Affairs and Gaode Map.

Star
DB New Order
DB New Order
TL 2020

Upgrade existing 200+ PostgreSQL Instance (1PB data) to Pigsty HA deployment. (CentOS7, PostgreSQL 13)

Database Monitoring
Database Monitoring
TL 2020

Build monitoring , logging , alerting system for databases. Including PostgreSQL, Redis and TTDB.

Architecture Evolution
Architecture Evolution
DBA 2018

Architecture evolution from 20 database to 200 database. Horizontal split and vertical split. Microservice refactor. Ton’s of database migration

Trace for iPhone
Trace for iPhone
Software Developer 2019

Make exising tracing model works on iPhone factories

Trace Data Warehouse
Trace Data Warehouse
Software Developer 2019

Desiging trace data warehouse schema, build ETL & streaming processing pipeline. Rewrite existing logic and makes it 10~100x faster

Trace Database Admin
Trace Database Admin
DBA 2018

Setup backup and recovery plan. Solving database failures. Upgrading monitoring system and optimizing slow queries

Umeng DMP
Umeng DMP
Full-Stack Developer 2017

Designing and managing database system for Umeng. Migrating HBase and MongoDB to Postgres. Build and maintain a knowledge database for DMP.

Details
Finplus
Finplus
Co-Founder 2016

Architect, tech leader,and 1 of 3 co-founders of Project FinPlus, A toB credit score (FICO) service in China. Intrapreneurship project with tens of millions $ income per year

Details
Oplus
Oplus
Soft-Hardware Developer 2015

Wi-Fi probe for offline user profile. Plays a versatile role in it: Software, Hardware, Ops, DBA, Data Analyst,BD,etc…

Details

Achievements

2020 Database Carnival Guest

First TanTan Coding Champoin

PostgreSQL ACE

2019 PGConf China Guest