CN – Canadian National

CN, Montreal, Canada

November 2009 to June 2010

Accomplishments

  • Built the data repartitioning recipe for CN Business Warehouse upgrade/maintenance project – expanding from 3 to 9 nodes using primarily the SAP DB6CONV utility/procedure. Executed and fine-tuned the recipe in three occasions with large production size data warehouse (2 TB).
  • Provided core DBA support during performance testing, identified and fixed configuration issues in a 9-node database environment causing deadlocks.
  • Performed a number of SAP System Copies involving DB2 Restores and Roll Forwards. Followed CN standards for setting up and configuring the new database environments.
  • Setup new monitoring scripts to capture database snapshots at the database partition level to better tune various database objects.
  • Found the root cause for a number of serious performance problems post Data Re-Partitioning using OS monitoring tools such as nmon and DB2 monitoring tools such as db2top. Worked with the vendor (SAP and IBM) to install the patch and validate the resolution.
  • Identified the root cause of a sporadic performance issue related to DB2 Auto-Runstats. Worked with the vendor to resolve the issue.
  • The migration of production database was delivered on time and on budget.

Comments are closed.