Medium

Shadab Mohammad

Shadab Mohammad

·

Oct 27

25 Oracle Database Tricks Every Backend Engineer Should Know

Practical SQL and PL/SQL patterns for faster queries, safer writes, and easier production debugging.

25 Oracle Database Tricks Every Backend Engineer Should Know

Shadab Mohammad

·

Oct 3

Lakehouse Querying OCI Object Storage from OCI PostgreSQL using Oracle Autonomous 26ai Database

Querying Data across OCI Services using a combination of OCI Postgres, FDW and Autonomous Database 26ai

Lakehouse Querying OCI Object Storage from OCI PostgreSQL using Oracle Autonomous 26ai Database

Shadab Mohammad

·

Sep 29

Migrating On-Premises PostgreSQL to OCI PostgreSQL with Near-Zero Downtime Using OCI GoldenGate

Migrating a large PostgreSQL database becomes significantly more challenging when production transactions cannot stop. A 10 TB database…

Migrating On-Premises PostgreSQL to OCI PostgreSQL with Near-Zero Downtime Using OCI GoldenGate

Shadab Mohammad

·

Sep 27

Building Multi-Region Replication with OCI PostgreSQL using pglogical

OCI Database with PostgreSQL provides a managed PostgreSQL platform, pglogical extension is available on OCI PostgreSQL which provides…

Building Multi-Region Replication with OCI PostgreSQL using pglogical

Shadab Mohammad

·

Aug 21

Building Production-Grade Containers for Oracle GoldenGate 26ai for Migrations

Oracle GoldenGate remains one of the most widely used technologies for real-time data replication, zero-downtime database migrations, and…

Building Production-Grade Containers for Oracle GoldenGate 26ai for Migrations

In

Towards Dev

by

Shadab Mohammad

·

Jun 27

OCI PostgreSQL vs. Amazon Aurora PostgreSQL for Geospatial Workloads — A Benchmarking Comparison

OCI PostgreSQL delivered 300.8 requests/sec with 439 ms P95 end-to-end HTTP latency on a 4-OCPU shape (8 vCPU equivalent). The Aurora…

Shadab Mohammad

·

Apr 11

Migrating On-Premise PostgreSQL to OCI PostgreSQL using a Hybrid Replication Architecture

Migrating On-Premise PostgreSQL to OCI PostgreSQL using a Hybrid Replication Architecture

In

Oracle Developers

by

Shadab Mohammad

·

Mar 16

Zero-Downtime Blue-Green Deployments for OCI MySQL HeatWave

Orchestrating safe and fast cutovers on OCI MySQL HeatWave using native replication or Oracle GoldenGate

Zero-Downtime Blue-Green Deployments for OCI MySQL HeatWave

In

Oracle Developers

by

Shadab Mohammad

·

Dec 21, 2025

Blue-Green Deployment for OCI PostgreSQL

A Blue-Green deployment for a Database service involves using a Blue environment (Production), as well as creating a Green environment…

Blue-Green Deployment for OCI PostgreSQL

Shadab Mohammad

·

Aug 27, 2025

Why PostgreSQL Full-Text Search is all you need in 2025

Why PostgreSQL Is All You Need for Search in 2025 (No Elasticsearch, Solr OpenSearch Required)

Why PostgreSQL Full-Text Search is all you need in 2025

Shadab Mohammad

Shadab Mohammad

Cloud Solutions Architect (The statements and opinions expressed here are my own & do not necessarily represent those of my employer)

Following

Help

Status

About

Careers

Press

Blog

Store

Privacy

Rules

Terms

Text to speech