PostgreSQL expert with 15+ years of production experience in Unix system engineering and database administration
My specialties are:
– Amazon RDS, (Google) Cloud SQL and Heruku PostgreSQL databases, all around
– On premise by-the-book setup
– Performance tuning on a large multi-TB, serving OLTP or DWH/BI needs
– Slow queries identification and tackling
– Big Data
– Troubleshooting
– Design and implementation of High Availability setups
– Hardware / Containerized / SaaS setups
– Backup, and disaster recovery of Postgres instances
– Training and technical writing regarding databases and system engineering
– Scaling for massive data setups
– Kubernetes and docker deployments on premise or on Azure Kubernetes Service
Also I am an early adopter of Kafka and MongoDB, with 7+ years experience including:
– Replicated setups
– High available setups by design
– Complete Helm deployments on K8s including Grafana boards, and metrics monitoring/alarms using Prometheus and Alertmanager
On request, I can offer a complete service, including installation and configuration of additional tools like Prometheus exporters, Prometheus-Alertmanager-Grafana installation and tuning, alerts configuration and much more, bringing my 20+ years of system administration at the customer’s service