Projects

Kompletní kancelář Device Inventory

2007–2011

I designed and developed a database system and toolset for device inventory and configuration management of the Kompletní kancelář service.

For the Kompletní kancelář (O2) network operations centre, I deployed RANCID with web-based access to the configuration repository and wrote scripts to inventory IP phones and customer routers.

I designed a PostgreSQL database model (stored procedures, triggers, archiving, address block allocation) and developed a Python tool called KKDM that generated RANCID configuration, BIND DNS zones and IPsec keys from the database, and scanned the network topology.