Dba Oracle Resume

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.

PROFESSIONAL EXPERIENCE

Dba Oracle

Confidential

Responsibilities:

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

Confidential

Responsibilities:

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

Confidential

Responsibilities:

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

Senior DBA

Responsibilities:

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.