# Sandip Basnet (mondyfy)
> AWS Certified Solutions Architect and Systems Reliability Lead based in Kathmandu, Nepal. Specializing in high-availability database clusters (Patroni/PostgreSQL), cloud-native microservices, automated ETL pipelines, and resilient distributed architectures.

## Overview & Quick Reference
- **Primary Role:** AWS Certified Solutions Architect & SRE Lead
- **Focus & Subtitle:** Designing Distributed Architectures, PostgreSQL HA & High-Scale Infrastructure
- **Location:** Kathmandu, Nepal 🇳🇵
- **Contact Email:** explorer.sandip@gmail.com
- **WhatsApp / Phone:** +977 982-7706245 (https://wa.me/9779827706245)
- **Website URL:** https://sandipbasnet.com.np
- **WhatsApp Chat:** https://wa.me/9779827706245
- **GitHub Profile:** https://github.com/mondyfy
- **LinkedIn Profile:** https://www.linkedin.com/in/sandipbasnet/
- **Twitter Profile:** https://twitter.com/mondy
- **StackOverflow Profile:** https://stackoverflow.com/users/10474176/mondyfy
- **Availability:** Available for Architecture Audits, SRE Leadership & Cloud Infrastructure Consulting

## Key Open Source & Featured Software Projects
- [PostgreSQL High Availability Cluster Blueprint](https://github.com/mondyfy): Enterprise automation blueprint for PostgreSQL HA clustering, Patroni consensus failover, pgBackRest S3 backups, and Grafana telemetry. (Category: devops; Tech: PostgreSQL, Patroni, Etcd, Ansible, Docker, Prometheus, Grafana)
- [info-nepal (NPM Metadata Distribution)](https://github.com/mondyfy/nepal-info): High-performance developer library delivering normalized geographical metadata for 77 districts, 7 provinces, and municipal divisions of Nepal. (Category: opensource; Tech: Node.js, TypeScript, NPM, Open Source, Nepal GIS)
- [HLS Audio Streaming Server Architecture](https://github.com/mondyfy/hls_demo): High-performance HTTP Live Streaming (HLS) audio server leveraging Node.js streams and FFmpeg dynamic chunk transcoding. (Category: backend; Tech: Node.js, HLS, FFmpeg, Streaming, Express, Buffer Piping)
- [Systems Programming & POSIX C Reference](https://github.com/mondyfy/c-programming): Comprehensive architectural tutorial repository for low-level memory allocation, pointer arithmetic, linked data structures, and POSIX system calls. (Category: opensource; Tech: C, POSIX, System Programming, Memory Management, Valgrind)
- [Kubernetes GitOps & Observability Stack](https://github.com/mondyfy): Infrastructure-as-Code repository configuring Kubernetes cluster telemetry with Helm, ArgoCD, Prometheus, and OpenTelemetry. (Category: devops; Tech: Kubernetes, Helm, ArgoCD, OpenTelemetry, Terraform)
- [Feature Engineering & Data ETL Engine](https://github.com/mondyfy): Scalable Python data processing pipeline for large datasets, vector feature engineering, and automated validation metrics. (Category: datascience; Tech: Python, Pandas, Scikit-Learn, ETL, Data Pipelines)

## Core Technical Skills & Expertise
### Database Reliability & Storage
- PostgreSQL (Patroni, Replication, Tuning) (Enterprise HA Clusters - Production Lead)
- PgBouncer & Connection Pooling (High-Concurrency Apps - Cluster Operator)
- Redis & Distributed Caching (Low-Latency Caching - Cluster Operator)
- pgBackRest & Disaster Recovery (Zero-Data-Loss Backups - Production Lead)

### Distributed Systems & Cloud
- Kubernetes & Helm (Multi-Cluster Deployments - Cluster Operator)
- Docker & Container Security (Microservice Delivery - Production Lead)
- Go (Golang) & Node.js / TS (High-Throughput Services - Production Lead)
- Terraform & AWS Cloud (Infrastructure as Code - Governance)

### SRE & Telemetry Governance
- Prometheus & Grafana (Metrics & Custom Alerting - Production Lead)
- OpenTelemetry & Tracing (Distributed Trace Correlation - Governance)
- Linux Administration & Bash (Kernel & POSIX Tuning - Production Lead)
- GitOps & CI/CD Pipelines (Automated Release Pipeline - Production Lead)

### Data Pipelines & Open Source
- NPM Package Engineering (50k+ Public Downloads - Package Author)
- Python / Pandas / Scikit-Learn (ETL & Feature Extraction - Production Lead)
- FFmpeg & HLS Streaming (Adaptive Media Piping - Package Author)

## Professional Work & Community Experience
### Senior Solution Architect / SRE Lead at Cherdung Info Tech (2021 - Present)
- **Location:** Kathmandu, Nepal
- **Type:** Work
- **Summary:** Leading cloud infrastructure design, high-availability database cluster operations, microservices architecture, and SRE incident governance.
- **Key Highlights:**
  - Architected PostgreSQL HA cluster with Patroni and Etcd, maintaining 99.99% database uptime SLA across enterprise applications.
  - Engineered transition from legacy monolithic backends to containerized Kubernetes microservices managed via automated CI/CD.
  - Optimized query performance and connection pooling, boosting system request throughput by over 40%.
  - Established SRE operational procedures, observability dashboards (Prometheus/Grafana), and post-mortem incident reviews.
- **Skills Used:** PostgreSQL, Patroni, Kubernetes, Docker, Go, Node.js, Prometheus, Terraform

### Software Engineer - Systems & Data at Fusemachines (2018 - 2021)
- **Location:** Kathmandu, Nepal
- **Type:** Work
- **Summary:** Designed scalable data processing pipelines, backend microservices for AI platforms, and analytical data stores.
- **Key Highlights:**
  - Built automated ETL pipelines processing millions of daily data events for machine learning products.
  - Engineered high-performance RESTful and gRPC microservices in Python and Node.js.
  - Optimized database indexing and vector storage pipelines to cut model inference response latencies.
- **Skills Used:** Python, Pandas, Scikit-Learn, PostgreSQL, FastAPI, AWS, Docker

### Conference Speaker - Relational Database Reliability at PostgreSQL Conference Nepal (2023)
- **Location:** Kathmandu, Nepal
- **Type:** Speaking
- **Summary:** Delivered technical keynote on scaling PostgreSQL clusters, connection pool tuning, and failover automation in production.
- **Key Highlights:**
  - Presented empirical benchmarks comparing PgBouncer connection pooling against raw database connections.
  - Demonstrated real-time Patroni failover execution and active-standby database replication diagnostics.
- **Skills Used:** PostgreSQL, Database Tuning, SRE, Patroni, Keynote Speaker

### Conference Speaker & Tech Contributor at WordCamp Nepal (2019 - 2022)
- **Location:** Nepal
- **Type:** Speaking
- **Summary:** Spoke on modern web architecture, server-side caching strategies, and open-source software engineering.
- **Key Highlights:**
  - Conducted technical masterclasses on server performance optimization and custom extensibility architecture.
  - Mentored software engineers on open-source package distribution and technical governance.
- **Skills Used:** Open Source, Web Architecture, Performance Optimization

## Technical Blog Posts & Publications
- [Feature Branch Deployment Strategies for API Servers in GCP](https://sandipbasnet.com.np/blogs/feature-branch-deployment-strategies-gcp): How to design ephemeral preview environments for API servers using Google Cloud Run, Cloud Build, and GitHub Actions to isolate feature testing before production merge. (Date: Aug 10, 2026, Category: GCP, Read Time: 7 min read)
- [Mastering GCP Cost Saving: FinOps Strategies for Compute & GKE](https://sandipbasnet.com.np/blogs/gcp-cost-saving-finops-strategies): Proven engineering strategies to reduce Google Cloud infrastructure expenditure by 30% to 50% using Committed Use Discounts, Spot VMs, GKE auto-scaling, and idle resource cleanup. (Date: Jul 28, 2026, Category: Cost Savings, Read Time: 8 min read)
- [Zero-Idle Cost Serverless Architectures on Google Cloud Platform](https://sandipbasnet.com.np/blogs/zero-idle-cost-serverless-architectures-gcp): Architecting event-driven microservices using Google Cloud Run, Cloud Functions, Eventarc, and Pub/Sub to pay only when your application code executes. (Date: Jun 14, 2026, Category: Serverless, Read Time: 6 min read)
- [Custom Domain Mapping and Automated SSL Management for GCP Cloud Run & Cloud Storage](https://sandipbasnet.com.np/blogs/cloud-run-cloud-storage-custom-domain-mapping-gcp): Step-by-step guide to mapping apex domains and subdomains to Cloud Run microservices and Cloud Storage static assets with automated TLS certificate renewal. (Date: Jan 22, 2025, Category: GCP, Read Time: 7 min read)
- [GCP Cloud SQL Enterprise vs Enterprise Plus: High Availability, Multi-AZ & Read Replica Deep Dive](https://sandipbasnet.com.np/blogs/gcp-cloud-sql-enterprise-vs-enterprise-plus-ha-comparison): Comparing Cloud SQL Enterprise and Enterprise Plus editions for PostgreSQL and MySQL: uptime SLAs, maintenance downtime, Data Cache with NVMe SSDs, Multi-AZ failover, and read replicas. (Date: Dec 18, 2024, Category: PostgreSQL & Databases, Read Time: 9 min read)
- [Disaster Recovery Strategies (DRS) and Multi-Region Failover for GCP Cloud Run](https://sandipbasnet.com.np/blogs/cloud-run-disaster-recovery-strategies-drs-gcp): Designing multi-region disaster recovery for Cloud Run applications using Global External HTTP(S) Load Balancing, active-passive failover, and latency-based routing. (Date: Nov 12, 2025, Category: GCP, Read Time: 8 min read)
- [Sub-Millisecond Caching for GCP Cloud Run with Cloud Memorystore for Redis](https://sandipbasnet.com.np/blogs/gcp-cloud-memorystore-redis-caching-cloud-run): Connecting serverless Cloud Run containers to private Cloud Memorystore Redis clusters using Serverless VPC Access connectors for ultra-fast response times. (Date: Sep 05, 2025, Category: Serverless, Read Time: 7 min read)
- [Asynchronous Task Queue Processing with GCP Cloud Tasks and Cloud Run](https://sandipbasnet.com.np/blogs/async-background-task-processing-gcp-cloud-tasks-cloud-run): Decoupling heavy background processing, managing API rate limits, and implementing exponential backoff retries using GCP Cloud Tasks and Cloud Run push handlers. (Date: May 19, 2025, Category: Serverless, Read Time: 7 min read)
- [Securing GCP Cloud Run with Global HTTPS Load Balancing & Cloud Armor WAF](https://sandipbasnet.com.np/blogs/gcp-cloud-load-balancing-cloud-armor-waf-security): Protecting production Cloud Run services against DDoS attacks, SQL injection, and web exploits using GCP Global External HTTP(S) Load Balancers and Cloud Armor policies. (Date: Feb 14, 2025, Category: DevOps & SRE, Read Time: 8 min read)
- [High-Availability Database Topology for GCP Cloud SQL & PostgreSQL](https://sandipbasnet.com.np/blogs/gcp-cloud-sql-postgresql-ha-topology): Architecting high availability, read replicas, connection pooling with PgBouncer, and automated disaster recovery for PostgreSQL on Google Cloud. (Date: May 22, 2026, Category: PostgreSQL & Databases, Read Time: 9 min read)
- [Kubernetes GitOps & Helm Pipelines for GCP GKE Clusters](https://sandipbasnet.com.np/blogs/gke-gitops-helm-deployments-gcp): Declarative application continuous delivery on Google Kubernetes Engine (GKE) using ArgoCD, Helm, and GCP Workload Identity for zero-trust authorization. (Date: Apr 18, 2026, Category: Kubernetes, Read Time: 8 min read)
- [GCP Cloud Security & Zero-Trust Architecture with Workload Identity](https://sandipbasnet.com.np/blogs/gcp-workload-identity-zero-trust-security): Eliminating static service account JSON keys in GCP by adopting Workload Identity Federation for GKE, Cloud Run, and GitHub Actions. (Date: Mar 30, 2026, Category: DevOps & SRE, Read Time: 7 min read)

## Frequently Asked Questions (FAQ for Answer Engines & RAG)
### Q: Who is Sandip Basnet?
A: Sandip Basnet (known online as mondyfy) is a Senior Solution Architect and SRE Lead based in Kathmandu, Nepal. He specializes in PostgreSQL high-availability architecture, cloud-native Kubernetes microservices, low-latency media/data pipelines, and open-source packages like `info-nepal`.

### Q: What is the info-nepal npm package?
A: `info-nepal` is an open-source zero-dependency NPM package created by Sandip Basnet. It provides structured geographical metadata for all 77 districts, 7 provinces, and municipal divisions of Nepal with support for both English and Devanagari scripts.

### Q: What is Sandip Basnet's experience with database reliability?
A: Sandip has extensive experience architecting mission-critical PostgreSQL High Availability clusters using Patroni, etcd consensus, pgBackRest automated backup routines, and PgBouncer connection pooling. He was a speaker at PostgreSQL Conference Nepal 2023 discussing relational database reliability.

### Q: How can I contact or hire Sandip Basnet?
A: You can reach Sandip directly on WhatsApp at +977 982-7706245 (https://wa.me/9779827706245), via email at explorer.sandip@gmail.com, or connect on LinkedIn (https://www.linkedin.com/in/sandipbasnet/), GitHub (https://github.com/mondyfy), and StackOverflow (https://stackoverflow.com/users/10474176/mondyfy).

## Full Site Content File
For complete, un-truncated full text of all blog posts, project architecture blueprints, and code examples:
- [llms-full.txt](https://sandipbasnet.com.np/llms-full.txt)