
Oracle Advanced Technologies Group at The Pythian Group
Toronto, Canada Area

Oracle Advanced Technologies Group at The Pythian Group
Toronto, Canada Area
Alex is master of the full range of Oracle technologies. This mastery has been essential addressing some of the greatest challenges his clients met.
Alex draws on years of experience working with some of the world’s largest telco companies, where he was involved with almost everything related to Oracle databases, from data modeling to architecting high availability solutions and resolving the performance issues of extremely large production sites.
With companies that rely on technologies such as RAC, Oracle Streams and Data Guard, Alex’s intimate knowledge of client, data, and software gives them robust and dependable production systems that allow them to run their businesses smoothly and stay ahead of their competitors.
Alex holds a Bachelor of Computer Sciences from Far Eastern National University in Vladivostok, Russia.
PL/SQL, SQL, Analytical SQL, Data Modeling, C/C++, Backup&Recovery, Performance Tuning, Clustered and HA Solutions
(Privately Held; Information Technology and Services industry)
December 2009 — Present (1 month)
(Privately Held; Information Technology and Services industry)
February 2009 — November 2009 (10 months)
As a member of the executive team, Alex is in charge of leading Makeplain database support operations.
Alex is engaged in both technical activities as well as long-term business goals. He is a master of putting together business requirements with technical implementation which allows his customers to create successful solutions to today's business problems.
(Privately Held; Information Technology and Services industry)
August 2008 — December 2008 (5 months)
I took over the team lead role in Aug 2008 guiding technical knowledge of my team and managing client relationships. My clients were ranging from small startups to industrial giants and everything in the middle, using variety of Oracle technologies and hardware platforms.
Skills: Oracle DataGuard, Oracle Streams, Oracle RAC, Oracle FailSafe, Oracle RMAN, planning backup and recovery, DR solutions, Oracle performance tuning and troubleshooting, data modeling and design, PL/SQL Developer, tkprof, extended SQL tarce.
(Privately Held; Information Technology and Services industry)
May 2007 — July 2008 (1 year 3 months)
I joined The Pythian Group in May 2007 and was mostly involved with production operational support of Oracle databases (versions ranging from 8i to 11G) featuring broad kind of environments from databases running under Linux and Windows all way up to big Unix system running under Solaris and AIX.
Skills: Oracle DataGuard, Oracle Streams, Oracle RAC, Oracle FailSafe, Oracle RMAN, planning backup and recovery, DR solutions, Oracle performance tuning and troubleshooting, data modeling and design, PL/SQL Developer, tkprof, extended SQL trace.
(Telecommunications industry)
January 2006 — April 2007 (1 year 4 months)
I moved into RDBMS department in January 2006, where my primary filed of responsibilities were around providing continuing availability for the Billing System , leveraging my good troubleshooting and performance tuning by design skills. During that time I’ve also traveled a lot other branches helping them resolve their stability and performance issues. There were no easy tasks back then and everything were done under intensive business pressures and tight schedules with systems where one hour of downtime totals millions of dollars and that was one of the most exciting parts in my life. I’ve also gained some SQL Server experience during that time providing support for a couple of internal SQL Server databases used primarily in accounting.
Skills: Oracle DataGuard, Oracle Streams, Oracle RAC, tkprof, extended SQL trace, PL/SQL Developer, Oracle RMAN,SQL Server Enterprise Manager, SQL Server Data Transformation Services.
(Telecommunications industry)
April 2005 — December 2005 (9 months)
My primary role during that time was around designing and developing company-wide reporting system for interconnect and IP traffic accounting. Storing subscribers’ calls as well as IP packets requires immense amount of space and we were leveraging almost every Oracle technology in order to help us dial with it – partitions, bitmap indexes, materialized views and query rewrite and parallel query options.
Skills: SQL, PL/SQL, Analytical SQL, partitioning, PL/SQL Developer, Oracle APEX, materialized view, parallel query, tkprof, extended SQL trace.
(Telecommunications industry)
May 2004 — March 2005 (11 months)
Megafon is one of the Russian's three largest telco companies and Mobikom-Khabarovsk is a Far-East branch. My primary responsibilities were around configuring, customizing and running the billing system engine. The engine itself was highly customizable thus not required any significant PL/SQL development in order to get it doing what we wanted, however, it required a lot of performance tuning due to suboptimal data model and poor PL/SQL practices.
Skills: SQL, PL/SQL, Analytical SQL , PL/SQL Developer, tkprof, extended SQL trace.
(Telecommunications industry)
October 2003 — April 2004 (7 months)
I started my first job as a database programmer for a PSTN (public switched telephone network) company back in 2004. My primary job was around developing PL/SQL procedures in order to extend features of the billing system, but I was also involved with some heavy C++ programming in order to parse EWSD binary data to be further processed by an accounting engine.
Skills: SQL, PL/SQL, Analytical SQL, PL/SQL Developer, tkprof, extended SQL trace, Visual C++, Intel C++ Compiler including profiler.
1998 — 2004