Skip to main content

Projects

Selected engagements presented as anonymised case studies. Client identifiers, hostnames, and confidential details are omitted.

Creator and Sole Developer

Design and development of a browser-based tool for visualizing and analyzing MongoDB explain plan output, covering the classic and Slot-Based Execution engines across MongoDB 4 through 7.

MongoDBJavaScriptHTMLCSSBrowser-side JSON parsing+1

All Projects

Database Architect and Lead DBA

Design and implementation of a PostgreSQL pgvector platform for semantic document search, including HNSW index strategy, connection pooling architecture, and operational monitoring.

PostgreSQL 16pgvectorPgBouncerpgBackRestPatroni+2

Database Solutions Lead

Design and migration of a multi-database SQL Server Always On Availability Group environment from on-premises FCI to Azure VMs, including storage optimisation and Azure Monitor integration.

SQL Server 2019Always On Availability GroupsAzure VMsAzure Premium SSDAzure Load Balancer+3

Lead Database Architect and Migration Lead

Migration of a multi-instance Oracle 11g environment to Oracle 19c RAC with Active Data Guard, including performance baseline establishment and zero-downtime cutover planning.

Oracle 19cReal Application ClustersData GuardActive Data GuardOracle ASM+3