CASE STUDY 01 · AUTOMATION ENGINEERING

Enterprise Automation Orchestrator

A reference architecture for reliable enterprise automation where durable orchestration state lives outside the robot and RPA is one controlled execution channel among APIs and services.

Request / FastAPI / PostgreSQL / Redis / Workers / API + RPA

PROBLEM

Robots should not be the system of record.

Long-running enterprise automations become fragile when execution state, retry behavior and recovery depend entirely on a bot session. The design separates orchestration from execution so work can be claimed, retried, audited and recovered independently.

CORE DECISION

Separate durable state from dispatch.

PostgreSQL owns durable request state. Redis accelerates dispatch. Workers claim work and select the appropriate API or RPA adapter. Robot availability does not define the reliability model of the whole system.

ARCHITECTURE

Reliability is designed into each boundary.

01FastAPIAdmission & validation
02PostgreSQLDurable state
03RedisDispatch signal
04WorkersClaims & retries
05API / RPAControlled execution
01

Idempotency

Logical request identity protects against accidental duplicate processing.

02

Recovery

Bounded retries, backoff, dead-letter handling and auditable replay.

03

Observability

Metrics, readiness, correlation IDs and OpenTelemetry foundations.

04

Execution boundary

Prefer supported APIs; use RPA where UI interaction is genuinely required.

TRADE-OFFS & LIMITS

What the reference architecture does not claim.

Redis is not durable truth

Dispatch is recoverable because PostgreSQL remains the authoritative state store.

Cooldown scope

Target cooldown is worker-local in the reference implementation, not a distributed global limiter.

Tracing boundary

OpenTelemetry exists, but complete trace-context propagation across the asynchronous boundary is not claimed.

Benchmark scope

Synthetic admission testing is engineering evidence, not a production-capacity claim.

EVIDENCE

Code, tests, containers, CI and architecture decisions.

This is a portfolio/reference system built to demonstrate automation engineering patterns. It is not presented as a client production deployment.