Expertise in PostgreSQL, Evangelist / KOL in China.
Author & Founder of the OSS PostgreSQL Distribution and Free RDS Alternative —— Pigsty
Handy with various data systems: MySQL, Redis, MinIO, etcd, MongoDB, Greenplum, HBase, Cassandra, ODPS, Consul, Loki, Prometheus, VictoriaMetrics, etc…
Administration / DBRE
Reliability engineering for database systems: backup & recovery, PITR & HA, monitoring & alerting, securing & auditing, performance tuning and SQL optimization, etc…
Write robust, maintainable & high performance programs using Golang: web service, metrics exporters, command line tools, crawlers, ETL pipelines, Data Parsers, etc…
Domain knowledge about: Web Frontend/Backend, Cloud, Networking, Hardware, Manufacturing Operation, GIS, Meteorology, Machine Learning and Information Security,…
Data Analysis & Visualization
Performing data analysis with advanced SQL and Python, R, Matlab, Excel,… Rich experience on making interactive visualization pieces with Grafana, echarts, and D3.js.
Manage the entire LGTM Stack: Grafana / Loki. Drawing sophisticated dashboards and designing visualizations. Developing data apps, plugins and panels with Grafana
Setup & configure Prometheus / VictoriaMetrics Stack Designing record & alert rules. Writing PromQL queries and metric exporters. Maintaining public yum/apt repos.
Familiar with many Linux distributions: RHEL / CentOS / Rocky, Ubuntu, Debian, … Maintaining public yum/apt repos for pgsql extensions, redis, minio, prometheus, etc…
Write reusable ansible roles and sophisticated playbooks. Designing highly automated provisioning solution in an Infrastructure as Code (IaC) way based on Ansible.
Configuring web server with Nginx; Manage load balancer with HAProxy; Customize API gateway such as Kong; Route traffic with LVS & keepalived.
Orchestrating and manage cloud services such as S3, EC2, EBS, CDN, RDS, etc… on AWS, Aliyun, Cloudflare and QCloud. FinOps practitioner and Cloud Exit evangelist.
Managing application on kubernetes, Deploy k8s & etcd services and using operators. Making docker images, setup registry and writing compose files.