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.
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.
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.
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.