Qualifications Summary

High quality skills in difficult problem resolutions, fast learning ability of the new technologies in addition to 25 years of experience in Information Technology which includes Database Administration in the DB2 UDB, DB2 on z/OS and Oracle, as well as programming on the IBM mainframe, Windows and UNIX platforms.

Key skills

The key skills set includes experience in DB2 UDB, DB2 z/OS and Oracle Administration, performance analysis on UNIX and z/OS using DB2 Explain, DB2 Adviser, Oracle Adviser, Toad and Quest Central tools, as well as experience in instance and DASD configuration. The skills set also includes strong knowledge and experience in data replication using IBM's Data Propagator and Oracle's Advanced Replication, and in programming using Unix Korn Shell, REXX, SQL, Focus, COBOL, C, PL1, Fortran, MVS ISPF, QMF, SAS, Visual Basic.

Professional Experience

dba oracle 10g

Confidential

Experience:

• DASD configuration for the file system
• Refreshes of the test environments
• Writing scripts using PL/SQL for tables partitioning and fragmentation maintenance
• Resolving performance issues using Toad for Oracle and applying Oracle Hints
• Creation of new Oracle Databases and configuring schemas.
• Configuring Archive Log, backups and recovery using RMAN scripts.
• Configuring Oracle Advanced Replication.

Senior DBA db2 udb Confidential

Experience:

• Creation and configuration of DB2 UDB Instances
• Analysis of the DB2 configuration as well as tablespace and containers configuration .
• Performance analysis through DB2 Explain, DB2 performance adviser and db2top
• Setup of the tablespace and data containers configuration for SMS and DMS types.
• Setup of the Backups, Recovery and Archive Log strategies.
• Creation of the automatic DBA scripts for Data Migration, SMS and DMS Tablespace creation, Data Backup and Restore as well as Pruning of Archive Log.
• Applying table data deep compression
• Setup of the Web Sphere SQL replication using DB2 replication center
• Performing migration of data DB2 z/OS to DB2 UDB through DB2 utilities and replication

Senior DBA db2 z/OS

Confidential

Experience:

• Creation and setup of the Database environments with the table and index space estimation
• Setup of the backups, recovery and data reorganization
• Refreshes of major size test DB2 data bases using wide range of DB2 utilities
• Resolution of the complex application performance problems using explain tools and Log Analysis
• Creation of DBA support tools for refresh, backups and reorgs by scripting in REXX and Focus
• Development and support using Platinum's Tools, DB2 tools and the Data Propagator v7.1, v8.1 and Web Sphere 9.1 Replication applications.
• Setup of the SQL replication using DB2 Replication Center v9.7 for Data Propagator and Web Sphere Replication.

Confidential

Position: Senior DBA DB2 z/OS and UDB,

Participation in the upgrade project from DB2 V7.1 to V10 on IBM z/OS with main task upgrading of the Data Propagator V8.0 to Web Sphere SQL replication V 9.1 which included:.

Responsibility:

• Solution Analysis for replication upgrade and testing
• Setup of replication through the DB2 Replication Center between the source DB2 tables on z/OS and target DB2 UDB tables Unix.
• Creating scripts using REXX for the performance testing
• Verifying the result of the replication through DB2 tools, Log Analysis.
• Solution Analysis for the production upgrade with minimal down time, through the cloning and replication.

Position: Oracle DBA

Confidential

Development and support of the Sales View Large Data Warehouse of the Air Canada Sales View application using Oracle 10g on Sun Servers.

Responsibility:

• Maintaining Oracle Database.
• DASD configuration for the file system
• Refreshes of the test environments
• Writing scripts using Unix Korn Shell and PL/SQL for tables partitioning and fragmentation maintenance
• Resolving performance issues using Toad for Oracle and applying Oracle Hints

Confidential

Position: Senior DBA DB2 UDB,

• Development and support of the COSMOS Data Warehouse of the IBM World Wide Sales using DB2 UDB 9.7 Responsibility:
• Support and maintenance of the DB2 databases on 3 Unix AIX Servers
• Development of the DBA automatic Korn Shell scripts for database maintenance

MAIN ACHIEVEMENTS

• Initiated the DB2 Performance tuning project related to the complete redesign and reconfiguration of the DB2 Data Warehouse in relation space and performance issues which included:
• Complete Analysis of the DB2 configuration as well as tablespace and containers configuration .
• Redesign of the tablespace, DASD and data containers configuration for SMS and DMS types
• Redesign of the Backups and Recovery setup.
• Creation of the automatic DBA scripts for Data Migration, SMS and DMS Tablespace creation, Data Backup and Restore as well as Pruning of Archive Log.

Confidential

Position: Oracle DBA,

Migration of the Call Center to a new Oracle Window Servers and upgrade from Oracle 9i to Oracle10g

Responsibility:

• Installation of Oracle 10G on new Servers.
• Creation of new Oracle Databases and configuring schemas.
• Exporting and Importing large amount of data from database on old servers to new database on new servers.
• Configuring Archive Log, backups and recovery using RMAN scripts.
• Configuring Oracle Advanced Replication for Materialized View Replication.

Confidential

Position: Senior DBA for DB2 on z/OS DBA for DB2 UDB,

Migration of the DB2 CRM Environment from Mainframe to the Unix AIX DB2 UDB 9.5 Data Warehouse.

Responsibility:

• Synchronize the data using Data Propagator v8.1
• Instance, tablespace and DASD containers configuration
• Applying table data deep compression on DB2 UDB 9.5

MAIN ACHIEVEMENTS

Created programs to generate scripts required for the data move, which included DB2 DDL and Data Propagator scripts, using Focus and Rexx on the mainframe and the Korn Shell on Unix. The generated scripts reduced the time of the project by generating scripts instead of using the DB2 Replication Center.

Confidential

Position: DBA for DB2 on z/OS

Wide range of Development DBA work to support different development teams

Responsibility:

• Refreshes of major size test DB2 data bases using wide range of DB2 utilities
• Resolution of application performance problems
• Creation Data Base environments with the table and index space estimation
• Creation of DBA support tools for refresh, backups and reorgs using REXX and Focus
• Development and support of the Platinum's Log Analyzer and the Data Propagator v7.1 Replication applications.

MAIN ACHIEVEMENTS

• Participation in the project of the conversion from the Platinum's Log Analyzer replication tool to Data Propagator v7.1 replication:
• creation of Data Propagator environment using the GUI tool DJRA
• creation of sophisticated process using Focus, which simulated the output of the Platinum's Log Analyzer for the CRM application that used to receive the output from the Platinum's Log Analyzer.
• Creation of the process using REXX, which was able to detect and reapply, rejected records from the Platinum's Log Analyzer because of the Primary key change and then sort by the primary key.
• Generation of a complex test environment refresh process for Aeroplan. that included the refresh mechanism for a production size test environment 300 Gb and the refreshes of several 4 data environments, with proper data integrity.

Confidential

Position: Programmer Analyst

Responsible for the wide range of software applications. Preparing preliminary Analysis, Data Flow Diagram, and Functional specifications and programming.

Applications:

• Air Canada CRM Customer Relation system using Quintus tool and programming on Visual Basic for Windows based application with Oracle Database platform.
• Development of statistical programs using SAS on MVS OS/390 for the security ACF2 Top secret system for Manulife Insurance.
• Air Canada Marketing Systems using P Methadology for Analysis and programming Fortran, COBOL, SQL DB2 and Focus, and DB2 Database on MVS OS/390.
• Air Canada In-Flight systems using PL/1, COBOL with IMS and DB2 Databases, producing various on-line transactions that interfaced IMS DB and DB2 DB on the MVS OS/390.
• Aeroplan application conversion from Honeywell IDS Database environment to the IBM DB2 using COBOL, IEF Tool CoolGen , SQL DB2 and QMF.