Hello, I'm

Rajeev Jasti

Principal Data Engineer

Data Engineering DBA Backend Cloud
About me See my experience
Ask my AI

About

Data Engineering DBA Backend Cloud

Data engineer with 8+ years building high-throughput services, OLAP/OLTP databases and middleware. I specialize in supply chain data (ERP, WMS, TMS), turning many operational sources into one scalable data warehouse, and in tuning SQL Server, PostgreSQL and Redshift.

Resume Ask my AI
8+
Years of experience
50+
Projects delivered
1M+
Events per second
30%
Cost reduction
40%
Lower latency
99.9%
Uptime

Technical skills

Cloud & Serverless

Amazon Redshift Amazon Bedrock Amazon S3 AWS Glue AWS Lambda Amazon Athena DynamoDB API Gateway CloudWatch Amazon EKS Amazon ECS EC2 RDS IAM SNS SQS Glacier

Backend

FastAPI AsyncIO & asyncpg boto3 SQLAlchemy Pydantic Uvicorn (ASGI) Nginx Apache (httpd) JWT & OAuth2 REST & SSE Streaming Structured Logging Multiprocessing Multithreading

Data Engineering & BI

ETL/ELT Design & Pipelines CDC Matillion PySpark Looker Pandas NumPy

Languages & Scripting

Python T-SQL PL/pgSQL SQL Bash / Linux

Databases & Middleware

PostgreSQL SQL Server Amazon Redshift MySQL Supabase Dell Boomi Redis Apache Kafka RabbitMQ Elasticsearch DynamoDB Alembic

AI & Agentic Engineering

Amazon Bedrock Claude Code & CLI Multi-Agent Orchestration Task Complexity Orchestration Autonomous Verification Loops Intent & Spec Driven Planning Agent Skills Plugins & MCP/Skill Extensions Lifecycle & Tool Hooks Context Budgeting A11y & Security Guardrails Data Agent Kit

DevOps, Testing & Tooling

Git Docker Terraform Kubernetes Helm GitHub Actions CI/CD Pytest Ruff / ESLint Security Scanning

Experience

View resume Download PDF

Feb 2018 — Present Salt Lake City, UT • Remote

Nicholas and Company

Principal Data Engineer (Nov 2022 — Present)
Data Engineer (Feb 2018 — Oct 2022)

Data Engineering & Modeling (OLAP)

3
  • Architected multi-source ingestion pipelines using PySpark, Matillion, and Boomi (CDC, watermark extracts, SaaS APIs, flat files) into Amazon Redshift, decoupling batch and near-real-time streaming via Amazon SQS for automated staging, deduplication, cleansing, and SQL business transformations.
  • Designed enterprise star and snowflake dimensional models, and developed LookML semantic models and Explores for core supply chain metrics (inventory turns, dock-to-stock cycle times, order fill rates, freight spend) with optimized datagroups and PDT lifecycle policies.
  • Implemented reverse-ETL pipelines syncing curated data back into Salesforce and Zoho, and partnered with cross-functional stakeholders (Operations, Sales, Finance) to deliver executive Looker dashboards standardizing KPIs across departments.

Backend & Middleware

5
  • Architected enterprise-grade serverless REST APIs and asynchronous order ingestion middleware using AWS API Gateway, Lambda, SQS FIFO, and Step Functions (Saga pattern), reliably fanning out multi-channel B2B/B2C orders to legacy ERP, WMS, and inventory distribution systems.
  • Engineered a distributed DynamoDB caching layer with SHA-256 payload fingerprinting and native TTL eviction, cutting primary database load by 30–50%.
  • Sustained 99.9% transaction completion through idempotent request handling, API Gateway throttling, DLQ redrive policies, exponential backoff, and circuit breakers.
  • Developed a high-concurrency Available-to-Promise (ATP) inventory reservation microservice using atomic conditional writes and distributed locks to prevent overselling.
  • Implemented a dual-engine search strategy combining Elasticsearch with SQL Server for sub-second search across millions of historical orders and invoices.

Database Systems (OLTP)

5
  • Owned OLTP database architecture and administration running mission-critical order-to-cash operations across pricing, rebates, commissions, and ERP/WMS/TMS integration feeds.
  • Architected the enterprise pricing engine in SQL Server, resolving sales-rep overrides, customer contract pricing, commodity pricing, COGS, and discount layers into real-time customer–item–DC prices via ACID-compliant T-SQL procedures.
  • Scaled the pricing API to sustain 100,000–200,000 executions/min at sub-100 ms latency with zero deadlocks under heavy concurrent load.
  • Modeled SCD Type 2 temporal pricing for point-in-time auditability, and engineered PriceIQ statistical pricing using IQR outlier fencing and skew-adjusted distribution analysis to intelligently price custom setups.
  • Built the vendor rebate calculation platform, sales commission payroll, and WMS/TMS activity-based incentive payroll.

Database Administration & Reliability (OLTP & OLAP)

4
  • Eliminated high-frequency lock-conversion deadlocks, write skew, and reader–writer blocking across high-throughput OLTP workloads by pairing targeted locking hints (UPDLOCK, HOLDLOCK, ROWLOCK) with deterministic UPSERT ordering and tuning Read Committed Snapshot Isolation (RCSI).
  • Resolved tempdb spills, parameter sniffing, and bookmark lookups through execution plan profiling, memory grant tuning, composite clustered/covering index redesigns, and table partitioning.
  • Automated enterprise maintenance, index defragmentation, and statistics via Ola Hallengren on SQL Server Agent, administered Always On Availability Groups (HA/DR), and tuned CDC replication.
  • Optimized Amazon Redshift storage architectures (KEY/ALL/EVEN distribution, sort keys, AZ64/ZSTD compression), WLM parameter queues, materialized views, PII data encryption, RBAC, and CloudWatch performance alarms.

Cloud Architecture & Modernization

3
  • Architected and provisioned an enterprise-scale, fault-tolerant AWS cloud foundation spanning multi-AZ VPCs, API Gateway, Lambda, Step Functions, SQS FIFO, DynamoDB, and Amazon Redshift.
  • Deployed a secure, auto-scaled internal application tier on AWS (EC2 in multi-AZ VPCs, Auto Scaling, hardened security groups, Route 53, Apache HTTPD reverse proxies) with automated open-source TLS rotation.
  • Engineered an event-driven Master Data Management (MDM) ecosystem across Zoho, establishing governed golden records for customer, item, and supplier entities with automated webhook and message-queued distribution to tier-1 ERP, WMS, and TMS systems to eliminate synchronization lag and discrepancies across warehouse fulfillment and freight routing networks.

DevOps & Infrastructure

4
  • Established end-to-end operational reliability, automated maintenance, and proactive infrastructure observability across distributed cloud microservices and database clusters.
  • Automated enterprise SQL Server maintenance, index defragmentation, and statistics updates using Ola Hallengren orchestrated via SQL Server Agent.
  • Built robust monitoring and alerting in SolarWinds (waits, blocking, resource pressure) and AWS CloudWatch (disk spill, CPU utilization, concurrency metrics).
  • Authored custom T-SQL health audit scripts, enforced least-privilege RBAC, and implemented resilient fault-tolerance mechanisms including automated Dead-Letter Queue (DLQ) redrives, exponential backoff, circuit breakers, and zero-downtime automated TLS certificate rotations.

Generative AI & Web Applications

3
  • Integrated Google's Model Context Protocol (MCP) server in Looker, exposing curated semantic definitions, Explores, and supply chain KPIs to generative AI agents to enable natural-language-to-SQL querying and prompt-driven analytical dashboard generation.
  • Engineered high-throughput, asynchronous FastAPI backend microservices with strict Pydantic schema validation, standardizing departmental custom data capture and preventing operational data corruption across downstream pipelines.
  • Delivered responsive, high-performance web applications and internal portals featuring seamless API integrations and granular role-based access control.
AWS
Amazon Redshift Amazon Bedrock Amazon S3 AWS Glue AWS Lambda Amazon Athena DynamoDB API Gateway CloudWatch Amazon EKS Amazon ECS EC2 RDS IAM SNS SQS Glacier
Data & Analytics
Matillion PySpark Dell Boomi Looker Pandas NumPy
Databases & Messaging
PostgreSQL SQL Server MySQL Redis Elasticsearch Apache Kafka RabbitMQ
Backend & APIs
FastAPI Pydantic SQLAlchemy Alembic boto3 Multiprocessing Multithreading
Languages
Python T-SQL PL/pgSQL SQL Bash / Linux
DevOps & Tooling
Git Docker Terraform Kubernetes GitHub Actions CI/CD Pytest

Hobbies

Soccer & Tennis

Avid soccer fan who follows matches closely on weekends, and an active tennis player who loves hitting the court for rallies and competitive sets.

  • Soccer
  • Tennis
  • Weekends

Sauna

Nothing beats a 20-minute sauna session after a long day of engineering. It is my reset button for recovery and deep thinking.

  • Sauna
  • 20 minutes
  • Recovery

Strength & Conditioning

Lifting heavy and staying mobile. Consistency in the gym translates directly to discipline and focus at the keyboard.

  • Strength
  • Mobility
  • Consistency

Food and cooking

Always on the hunt for the best local eats, from hidden street food gems to trying my hand at cooking new cuisines at home.

  • Street food
  • Home cooking
  • Local finds

Apps

Soccer

Champions League Predictor

Rank the 36-club league phase, settle the knockout play-offs, then run the bracket through to the final in Madrid. Picks save in your browser and travel as a share link.

No sign-in Picks saved locally Share link Open Soccer

World Cup Predictor

Predict the group stages, advance the best third-place wildcards, and simulate the knockout stage all the way to crowning the champion.

No sign-in Picks saved locally Share link Open Games

Arcade

2048, Tetris, Flapper, Stack, Snake and Breaker, written from scratch in vanilla JavaScript — no framework, no game engine, no third-party code. Keyboard or touch, and your best score for each stays in your browser.

No sign-in Scores saved locally Six games Open Dev tools

Cron & Regex Visualizer

Translate 5-part cron schedules into plain English, inspect the next 10 triggers on a live timeline, and match regex patterns in real time with syntax color-coding and capture group breakdowns.

No sign-in Stays in your browser Share link Open Security

Crypto & Encoders

Hash text, encode and decode Base64, hex, URL and binary, generate UUIDs, and read Unix timestamps.

No sign-in Stays in your browser Web Crypto API Open Dev tools

JSON Workbench

Format, validate and repair malformed JSON with line-accurate errors, query it live with JSONPath or dot-notation filters, explore it as a collapsible tree, and convert between JSON, YAML, CSV and TypeScript interfaces.

No sign-in Stays in your browser Nothing stored Open Dev tools

Diff Checker

Compare two files with Myers diff and character-level highlighting, switch between split and unified views, paste a git diff and read it back as a side-by-side, and copy the result out as a standard unified patch.

No sign-in Stays in your browser Nothing stored Open

Activity

Let's talk.

Email, call, or send a message below, whichever is easiest.

Email me inboxtorj@gmail.com Call me (+1) 980-216-8513

Pick a topic to start your message.

Send a message

Three fields, about a minute.

0 / 1200

Goes straight to my inbox. No list, no newsletter. Privacy note

Ask my AI