Senior Database Specialist
2009 - PRESENTSelf-employed- Developed and optimized MySQL query generation patterns for https://spikeet.com/. Improved 12-80 times the performance of queries from the previous version.
- Developed SQL Server stored procedures and triggers for Faraj Fund, UAE.
- Built PostgreSQL functions and optimized queries and indexes for TV Nova, Czech Republic.
- Created the scheduling algorithm, and the database model, and developed MySQL queries for the 3v3 football tournaments portal, Phoniax, Norway.
- Designed and developed a SQL Server reporting database for Blue Rabbit, DKNY exclusive distributor in Prague, Czech Republic.
- Designed a POS application for Blue Rabbit, Czech Republic.
- Developed Oracle PL/SQL packages of data synchronization between provisioning and billing system for MT:S telecom operator, Serbia.
Technologies: PostgreSQL, MySQL, Oracle, Microsoft SQL ServerQuality Assurance Manager
2007 - 2009SitronicsTS, Prague, Czech Republic- Managed the quality assurance department, including test analysis, test execution, test automation, test data preparation, integration testing, and performance testing teams.
- Participated in the design and establishment of SDLC and QA processes.
- Managed product testing of various telecom OSS/BSS deliveries in Russia, Czech Republic, Germany, Uganda, and Serbia.
Technologies: TFS, TestComplete, LoadRunner, Microsoft Dynamics CRM, TIBCO, .NET, Oracle 10gConsultant
2005 - 2006Time Import, Prague, Czech Republic- Gathered and manage requirements for KUSCK, Czech Republic.
- Deployed, configured, and managed the subversion version control system.
- Design high-level architecture of KUSCK customer portal back-end.
Technologies: Microsoft Project Server, Subversion (SVN), BizTalkDatabase Engineer
2003 - 2005Tmp Worldwide (Monster), Maynard (USA), Prague Czech Republic- Developed stored procedures for a campaign management data mart.
- Reviewed code and trained more than 40 developers in T-SQL best practices.
- Designed indexes and optimized stored procedures for job seekers, employers, and mass sender subsystems.
Technologies: Rational ClearQuest, Embarcadero RAD Studio, Microsoft SQL ServerOracle Consultant
2003 - 2003Ad Astra, Prague, Czech Republic- Developed PL/SQL packages implementing Wholesales Billing API for GTS (telecom operator), Czech Republic.
- Designed the logical and physical model for GTS Wholesales Billing.
- Introduced unit testing for PL/SQL stored procedures and functions inside PL/SQL packages.
Technologies: Oracle9iDatabase Team Leader
1999 - 2002Strom Telecom, Doubravice, Czech Republic- Designed, developed, optimized, and administered massive telecom databases for clients in Russia, Czech Republic, and Germany.
- Designed the database model of wholesales billing and least cost routing for Callax and Dusseldorf, Germany.
- Migrated the telecom billing system from SQL Server to Oracle.
- Implemented central ODS of telecom billing for MGTS, Moscow.
Technologies: Visual Basic 6 (VB6), Sybase, Oracle9i, SQL Server 2000