2. DevOps & Infrastructure

Provides best practices for deploying frontend applications on Vercel, including edge functions, preview deployments, and Next.js optimization.

Guides users in designing CI/CD pipelines with platform-specific template references for efficient automation.

Automates server configuration, application deployment, and infrastructure management through Ansible playbooks for efficient DevOps workflows.

Configures cloud monitoring with Prometheus and Grafana for metrics, alerts, and performance dashboards.

Provides tools for deploying applications on Kubernetes, managing manifests, configuring Helm charts, and troubleshooting cluster issues.

Provides architecture patterns and best practices for designing, deploying, and reviewing GCP infrastructure including GKE, Cloud Run, and BigQuery.

Provides AWS architecture patterns and best practices for designing, deploying, and reviewing cloud infrastructure.

Guides on Azure architecture patterns and best practices for designing, deploying, and reviewing Azure infrastructure including AKS, App Service, and CosmosDB.

Manages cloud infrastructure provisioning, state management, and module creation using Terraform for consistent and automated deployments.

Syncs local environment variables (.env files) with Vercel's deployment configurations across all environments to ensure deployment consistency and readiness.

Delegates code execution tasks to remote containerized agents for parallel processing, long-running jobs, and resource-intensive operations.

Analyzes cloud costs and implements strategies to optimize resource usage and reduce expenses in cloud infrastructure.

Diagnoses ClickHouse merge performance, part backlog, and 'too many parts' errors for database optimization.

Analyzes ClickHouse system log health, including TTL configuration, disk usage, and cleanup to resolve log-related infrastructure issues.

Real-time monitoring of ClickHouse metrics including load average, connections, queue, and resource saturation.

Diagnoses ClickHouse memory usage, OOM errors, and memory pressure to resolve out-of-memory issues in database operations.

Diagnoses ClickHouse replication health, Keeper connectivity, replica lag, and queue issues to resolve replication problems in database infrastructure.

Provides a diagnostic router for ClickHouse databases, performing initial checks and routing to specialized skills based on findings.

Tracks and diagnoses ClickHouse mutation operations (ALTER UPDATE, ALTER DELETE) to resolve stuck mutations and performance issues.

Diagnoses ClickHouse storage issues including disk usage, compression efficiency, and IO bottlenecks to optimize database performance and resolve space constraints.

Automates F# application deployment with Tailscale sidecar in Docker Compose for secure private network access without public ports.

Analyzes ClickHouse cache systems (mark, uncompressed, query) to diagnose cache hit ratio issues and optimize cache tuning for database performance.

Traces production alerts to original requirements (REQ-*), creates remediation intents, and closes runtime-to-intent feedback loops for efficient issue resolution.

Configures observability platforms (Datadog, Prometheus, Splunk) with requirement-specific dashboards, alerts, and SLA tracking for production deployments.