Principal Database Administrator
Database Solutions Lead based in Athens, Greece. Specialising in Oracle, SQL Server, PostgreSQL, and MongoDB — with a focus on high availability, disaster recovery, performance engineering, cloud migrations, and DBA leadership.
Identifies exact duplicate indexes on the same table — indexes with identical key column lists in the same order — so that redundant indexes can be safely dropped to reduce write overhead and storage in MySQL and MariaDB.
Identifies exact duplicate indexes on the same table — indexes with identical key column lists in the same order — so that redundant indexes can be safely dropped to reduce write overhead and segment storage.
Estimates the size of a proposed B-tree index before creation — calculates the per-entry byte footprint from key column type widths using USER_TAB_COLUMNS and average column lengths, then projects total size against the current row count, block size, and PCTFREE.
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.