PGCon2007 - Confirmed

PGCon 2007
The PostgreSQL Conference

Radovan Jablonovsky

Database Architect/DBA with focus on datawarehouse, realtime reporting, OLTP. Work experience with PostgreSQL, Oracle, MSSQL, MySQL and Sybase.

2007 - I am working on rebuilding trucking management system with online and datawarehouse reporting. System is moving from MSSQL servers distributed architecture to central PostgreSQL database server. Database's schemes and stored function are responsible for real-time data collection, between schemes data transfer and calculation.

Responsibility: Management of database resources. Build database, backup, security policy. Optimization and redesign replication model for MSSQL2000/Oracle. Took part in build datawarehouse for arrow fleet system. Design and develop ETL system for datawarehouse. Took part in redesigning legacy system. DBA responsibility for Oracle 10.2g (2 servers), MSSQL2000/2005 (20 servers), Postgresql 8.1 (2 servers), MySQL 4.1 (2 servers).


rjablonov at arrow dot ca