- 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.
- 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.
- 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
- 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.
- 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.