Migration of Payment System

Client: A leading worldwide provider of payment processing services.

Task: Data migration from Oracle 11g to DB2 10.5. We migrated four Oracle databases to a single one on DB2. The requirements included migration of data loading scripts and modification of a custom framework with facilities of both database creation from scratch and performing incremental updates.

We migrated DDLs, stored procedures/packages, data loading scripts, and developed several modules in Java/C whose purpose is to provide missing/insufficient DB2 functionality. We also migrated a set of Perl scripts (main script size ~11K lines).

Technologies: IBM Data Studio, Eclipse/Visual studio, Perl, cmd/bash/ksh, svn/git, Java RMI, LDAP, and TCP.