Cloud, data, AI delivery

Production grade reliability and analytics for cloud businesses.

Jae Pasha Consulting is a hands-on engineering partner. We build SQL reliability systems, Azure data platforms, and AI automation that stays auditable, fast, and resilient under real load.

5 min

Critical alert detection

730 days

Log Analytics retention

15-20%

CPU gain from automation

12-18 mo

Capacity runway mapped

STATUS STREAM: SQL health email sent | KQL trend export complete | ADLS ingest stable | Power BI refresh OK

What we do

We help teams with SQL Server estates, Azure platforms, and AI automation run faster, safer, and with clear telemetry.

Reliability engineering

Automation for health checks, index and stats maintenance, and audit ready operations on SQL Server and Azure SQL.

Ola HallengrenAzure AutomationRunbooks

Observability and alerting

Azure Monitor, Log Analytics, and KQL driven incident response with 5 minute evaluation windows.

Azure MonitorKQLAction Groups

Data platforms

Lake to medallion to warehouse architecture using ADLS Gen2, Databricks, ADF, Synapse or Snowflake.

ADLS Gen2DatabricksADF

BI and analytics

Power BI reporting with M scripts and KQL exports for long term performance trends and forecasting.

Power BIM QueriesAzureDiagnostics

Cloud operations

Capacity planning, cost tuning, and secure environments with RBAC, policy, and compliance-ready logging.

FinOpsRBACAzure Policy

AI automation

AI agents that automate reporting, monitoring, and operational triage with clear human oversight.

LLM OpsAutomationDecision Trees

Teams we have supported

Client experience across enterprise, SaaS, and integration heavy environments.

Google
Software AG
Dye and Durham
Credas
KEMET Electronics
Mondi Group
BG Foods
House of qAmi
Huxan Holdings
Google
Software AG
Dye and Durham
Credas
KEMET Electronics
Mondi Group
BG Foods
House of qAmi
Huxan Holdings

Domain focus

Think of these as dedicated pages within one experience: AI, data, and cloud.

AI and automation

AI agents for ops, reporting, and decision support.

See AI projects

Operational triage guides

Decision trees linked to KQL and SQL checks for CPU, blocking, and storage incidents.

Human-in-the-loop reporting

Automated HTML health summaries with clear owner actions and escalation paths.

Automation foundations

PowerShell runbooks and Logic Apps used as the control plane for safe AI adoption.

PowerShellLogic AppsAzure AutomationLLM Ops
Data engineering

Lakehouse architecture and analytics with clear lineage.

See data projects

Lake to medallion to warehouse

ADLS Gen2, Databricks medallion layers, and ADF silver transformations.

2 year trend analytics

KQL exports to M scripts feeding Power BI for long term forecasting.

CSV exports for BI

Daily performance datasets posted to SharePoint via Logic Apps for reporting.

ADLS Gen2DatabricksADFPower BISnowflake
Cloud engineering

SQL reliability, monitoring, and secure operations at scale.

See cloud projects

Health monitoring automation

HTML health emails with CPU, blocking, deadlocks, failed jobs, and storage snapshots.

Azure Monitor alerts

Critical and warning rules for CPU, vCore, storage, deadlocks, and connectivity.

Capacity planning

12 to 18 month growth projections with tiering and scaling options.

Azure SQLLog AnalyticsAzure MonitorRBACFinOps

Selected project delivery

Real outcomes from production environments and long running platforms.

24/7 health monitoring dashboard

Azure Automation + PowerShell health pipeline with daily HTML email for CPU, blocking, deadlocks, failed jobs, and space.

Azure AutomationPowerShellHTML Email

Production DB architecture docs

Documented 362 tables, 486.6M records, and 268 foreign keys with diagrams and glossary.

Schema MappingDependency GraphsGlossary

Azure Monitor alert rules

6 alert rules with 5 minute evaluation, action groups for SMS and email, and incident playbooks.

Azure MonitorAction GroupsSLA

Ola Hallengren automation

Index and stats maintenance runbooks with CommandLog audit trails and off peak schedules.

Ola HallengrenCommandLogRunbooks

Performance metric definitions

Plain language metrics for P50, P95, P99 latency, deadlocks, blocking, and timeouts.

P50 P95 P99SQL LatencyDocs

Troubleshooting guide

Operational decision trees for high CPU, long queries, blocking, and storage pressure.

KQLSQL ChecksRunbooks

Capacity and growth planning

Historical growth analysis, 12 to 18 month runway projections, and tiering options.

ForecastingTieringFinOps

2 year analytics in Power BI

Extended Log Analytics retention to 730 days, KQL exports to M scripts, and trend reporting.

Log AnalyticsPower BIM Scripts

Performance CSV exports

PowerShell runbook exports with Logic App delivery to SharePoint for BI ready datasets.

Logic AppsSharePointCSV

Wallet DB monitoring history

Daily performance snapshots and top query tracking stored as CSV time series.

Azure SQLAutomationReporting

Engagement model

A clear delivery flow that moves from assessment to measurable outcomes.

Audit and roadmap

2 to 4 weeks

Environment review, telemetry map, risk assessment, and prioritized delivery plan.

Build and automate

4 to 12 weeks

Runbooks, alerting, data pipelines, and dashboards shipped in production with tests.

Operate and optimize

Ongoing

Capacity reviews, cost tuning, and continuous reliability improvements.

Ready to build a reliable data platform?

Direct delivery led by Jamal Pasha. Cloud and data engineering, end to end.