PRINCIPAL SKILLS:

• 16 years administering and tuning expertise on large scale >1TB DB2 LUW UDB
• 7.x,8.x,9.1, 9.5 , 9.7 and 10.1 and Oracle 7/8/9.x,10.x,11.x and SQL Server databases
• V6.5 to SQL Server 2008 databases environments
• Gained 22 years of solid computing experience in all phases of the software development cycle, including database administration
• 19 years of ORACLE experience on UNIX/LINUX/NT/Mainframes environments
• 10 years of MS-SQL server DBA experience
• 12 years of UDB-EE/EEE/DPF DBA experience on AIX, SUN, Windows, z/OS
• Over ten years of AIX operating system experience including HACMP
• Relational database modeling and design Logical and physical , SDLC and code walk-through
• SQL tuning in client/server networked environments
• Oracle Enterprise Manager, DB-Artisan DBA tool, RMAN
• UNIX shell scripts, JCL, Windows ANT
• Oracle Real Application Cluster Server 3 nodes
• Database Performance tuning, OEM, TOAD tools
• Oracle Replication, DB2 replication, Transport Tablespace, Materialized Views, bitmap index, Partition table
• C, Java, JSP Programming
• ORACLE SQL PLUS, PL/SQL, SQL LOADER, PARALLEL QUERY,
• PRO C, SQL/ORACLE FORMS, SQL REPORT WRITER, SQR, Designer/2000,ER-WIN
• DB/2 EXPORT, IMPORT, LOAD, RUNSTATS, REORGCHK, REORG, REBIND,
• IBM MQ SERIES
• BACKUP, RESTORE, VISUAL EXPLAIN
• MS-ACCESS, MS-SQL SERVER 6.5/7/2000/2005/2008
• Knowledge and experience in bringing up Oracle and DB2 databases in a contingency environment when remote replication is done by SRDF or SRDF/A
• IBM MQ series install and setup Windows
• Brokerage Operations, Accounting, Inventory, fixed assets, Mortgage, Options Trade Management, BSR Advance Software
• Data Warehousing, Data Mart, Informatica Power Center ETL
• Relation connect, Data Joiner, Relational Connect, Buffer Pool Management, Isolate Queries Data Joiner, database connectivity, refreshes, Frameway SQL issues Tuning debugging
• Cognos, Informatica, ASM, Oracle Cluster File System
• ER Studio, ER Win, Bachman data modeling tools, IBM IDA InfoSphere Data Architect
• EMC SRDF and IBM shark storage
• Working knowledge of ETL tools IBM Info Sphere data stage, Informatica and Abinito
• DB2 performance monitoring, DB2 Data Studio, z/OS DB2 DBA admin tool, DB2 Health Monitor, Control
• IBM InfoSphere Data Architect IDA , Clearcase, ER Studio, ER Win, Bachman data modeling tools
• TOAD, DB2 Data Studio, InfoSphere Optima
• Hardware:
• SUN, DG - 88, HP/9000, Alpha, Intel, IBM/390 VM/ESA , IBM-AIX, IBM Mainframe MVS/zOS
• Operating System:
• HP-UX. Solaris, DG-UX, AIX, Alpha-Ultrix, VM/ESA Main Frame , Linux, Z/OS Main Frame
• DBMS:
• ORACLE 5/6/7/8/8i/9i/10G/11G, UNIFY 4, MS-SQL SERVER 6.5/7/2000/2005/2008, DB2 UDB 5/7/8/9/9.7/10.1, HP-IMAGE Network database , INFORMIX 9/10/11

EXPERIENCE:

Confidential

DB2 Consultant/Database Architect

• DB2 WLM setup to monitor query and setup threshold
• Optimize and tune performance of SQL queries using Visual Explan, db2advise
• DB2 UDB development and production support on LINUX/AIX/SUN/Windows
• Supporting SAP BO FI/CO project on DB2 databases: FC,FIM, DS, familiar with SAP DBA Cockpit
• Supporting MDM project and WebSphere IIS implementation on DB2 databases MDMDB, Cognos, XMETTA
• Managing MDM project MDMDB DB2 database of size 1 TB
• DB2 Connect Enterprise Edition setup on AIX/Linus and cataloging to export data from Host Mainframe and AS/400
• Using DB2 deep compression and DB2 MQT for performance improvement
• DB2 Connect install to use host system
• Installation of DB2 databases and user security setup
• DB2 UDB re-organization, run stats jobs setup using shell scripts
• DB2 UDB migration from V9.2 to V9.7 LINUX/AIX/Solars
• Helped Project teams to understand and use DB2 SQL tuning and locking features as most developers were from Oracle development background
• Resolved customers critical care database related production issues
• Install Oracle production RAC databases using ASM Windows/Linux/Solaris
• Installation of CPU/critical patches and updates
• Using Oracle 10g/11g AWR/ADDM for tuning
• Install Oracle production RAC databases using ASM/OCFS
• Using Oracle 10g/11g AWR/ADDM for tuning
• Oracle 10g/11g Data Guard setup using Data Guard broker
• Implementing star schema design using MDC, MQT
• Involved in design, development and implementation of application
• DB2 UDB 9.7 HADR setup

Confidential

DB2 Consultant

DB2 Q-Replication setup for Reporting

• Setup of DB2 10.1 on development server, working on Temporal storage, RCAC etc.
• Using DB2 9.7 new index compress features to save disk space on large tables
• Oracle migration from 10g to Oracle 11g
• DB2 porting from AIX to Solaris
• SQL server 2005 to SQL server 2008 upgrade and implementing database backup compression
• Support DB2 UDB V9/AIX environnement
• SQL Server 2008 Cluster Install on three nodes cluster
• DB2 new RECOVER command testing and documented in production document
• Using new feature of REDIRECT command to clone database from DEV to QA
• Implementing new ROLE based DB2 security feature
• Supporting DPF DB2 9.7 4 nodes and 20 partitions environment
• DB2 HADR database setup
• DB2 UDB development and production support on LINUX/AIX/SUN/Windows
• DB2 database cloning using REDIRECT restore and db2relocatedb
• Production databases troubleshooting production issues
• Used DB2 Health Monitor and testing IBM Data studio for DB2 database monitoring
• Using IBM InfoSphere Architect IDA for data model and generating DDL
• DB2 UDB V9.2 upgrade to DB2 V9.7

Confidential

DBA Consultant/contractor

• DB2 Connect setup and written Shell script to load data from AS/400
• DB2 database backup/restore using TSM
• SQL server 2005 cluster install and database mirroring setup
• Informix production support
• SQL Server database backup and restore setup
• Resolving Scotia clients database connection issues

Confidential

Lead DB2 DBA

• Installation of DB2 databases and user security setup
• DB2 UDB re-organization, run stats jobs setup using shell scripts
• DB2 UDB migration from V9 to V9.2 LINUX/AIX
• DB2 table partition and row compression design and implementation
• Work Load Manager WLM setup to control and monitor query execution
• Helped Project teams to understand and use DB2 SQL tuning and locking features as most developers were from Oracle development background
• Resolved customers critical care database related production issues
• Using IBM InfoSphere Data Warehouse to build cube, OLAP metadata repository
• Modeling using IBM InforSphere Warehouse 9.5 Design Studio
• Implementing star schema design using MDC, MQT
• Involved in design, development and implementation of application
• SQL Server schema changes and user management
• SQL Server query tuning using SQL Profiler
• DB2 UDB 9.5/9.7 HADR setup, DB2 replication setup
• Install of Oracle 11g and SQL server 2008 to certify application
• Using DB2 table range partition feature on Data warehouse of size 5 TB
• Created DB2 databases on zOS mainframe , AIX and SUN non DPF and DPF
• Implemented DB2 9 table range partition for Data warehouse
• Implemented database schema changes DB2 zOS, DB2AIX, Oracle SUN, SQL Server
• Implemented Perl scripts to take database backup, reorg
• Used DB2 Performance Expert tool for DB2 performance monitoring
• Written JCL job DB2 Mainframe, Shell scripts for DB2 LUW and T-SQL/Wsh for SQL Server
• Implemented MDC, MQT and Federated database for DB2 Data Warehouse
• Creating data transformation jobs to prepare the data for OLAP analysis
• Monitoring the performance of the data transformation and data movement jobs as the database grows over time
• SQL Server transaction log shipping setup for standby database
• Using TSO/JCL to resolve tablespace check pending issue, run runstats etc.
• Writing shell scripts to take DB2 backup in DPF environment, run runstats, reorg etc

Confidential

DB2 Domain Lead/DBA Specialist

• Developed code to do backup, restore, reorg of CIBC Mortgage database
• Using DB2 Data warehouse Edition OLAP function for Mortgage application
• DB2 database cloning using REDIRECT restore and db2relocatedb
• DB2 UDB Federated database setup across SUN/AIX/zOS
• Installed of DB2 Connect and prepared document on the install on AIX
• DB2 Informatica performance tuning
• Used Tivoli storage Manager TSM to restore DB2 backup from tape
• Supported Informatica development team on DB2/Oracle mapping, performance tuning
• DB2 Connect setup for Informatica and Cognos Mainframe access
• DB2 UDB Federated database setup between AIX and z/OS
• Implemented/Supporting CIBC Mortgage DB2 data warehouse of size 6 TB
• Using ERWin for data modeling of DB2 database application
• Involved in Basel project supporting 10TB size DB2 databases
• DB2 performance tuning using Health Monitor, Visual Explain
• DB2 UDB migration from 7 to 8 Windows
• ER/WIN modeling tool to reverse engineer Oracle, DB2 databases
• DB2 DR test by restoring database on DR site using EMC SRDF
• Worked on EMC SAN storage system and DR setup using SRDF for Oracle and DB2
• On-call production Oracle/DB2 UDB/SQL Server DBA support
• Migrating DB2 application from AIX on DB2 V7 to SUN on DB2 V8
• DB2 archive log mode setup and backup and recovery implementation
• Korn Shell programming to implement DB2 and Oracle batch job i.e. data purge, backup
• Knowledge and experience in bringing up Oracle and DB2 databases in a contingency environment when remote replication is done by SRDF or SRDF/A, IBM PPRC
• Correcting/Modifying code of DB2 SQL/PL, Oracle PL/SQL and SQL Server T-SQL of Oracle/DB2/SQL development team
• SQL Server database restore from PROD to UAT, user management, DR test using EMC SRDF
• Implementing SQL Server schema changes
• Implemented DB2 and Oracle database audit as per bank audit requirements
• DB2Audit setup for database auditing
• Creating and managing DB2 database on DB2 Mainframe Z/OS
• Good exposure of JCL/TSO, JCL programming for DB2zOS database maintenance

Confidential

Database Manager

• Re-engineer Legacy Credit verification HP-Image database to Linux/DB2
• Written bash/Perl scripts for data conversion
• Supported Oracle, SQL Server, DB2 and HP-Image databases
• Oracle and DB2 Performance tuning
• Coded DB2 backup scripts using TSM storage on EEE/DPF
• Created logical/physical Data Model using ER/Studio and maintained Data dictionary
• Worked on DB2 Warehouse edition to create schema, cube for OLAP analysis
• Oracle PL/SQL and DB2 SQL PL and PERL coding
• DB2 development project support: Create schema, store procedure, security setup and Oracle backup and restore setup using RMAN
• MS SQL server 2000/7 production support
• Writing SQL server T-SQL store procedures and providing SQL Server DBA support
• Plan out for periodic test recover of the Oracle/DB2/SQL Server database to ensure a foolproof backup system
• Scheduling for periodic SQL Server database maintenance tasks and monitoring their execution
• Oracle upgrade patch and DB2 fixpack install
• IBM MQ series setup, C coding to transfer file and read message from queue
• Tuned DB2 database and Database manager configuration for optimum performance
• Experimented with changing bufferpool and tablespace page size to improve time taken by ETL to build data marts
• Experimented with indexes, and employed Index Advisor and Visual Explain, to both improve user report performance and speed ETL run times
• Employed REORGCHK, REORG TABLE and RUNSTATS to further performance goals
• Perl programming to monitor DB2 database and performance tuning
• SQL PL database programming for DB2 UDB

Confidential

Consultant DBA Contract

• DB2 EEE database autoloader job setup
• Performance tuning and backup/restore script using Perl
• Supporting development team of Oracle, UDB EE/EEE
• Capacity Planning of Oracle and DB2
• DB2 V7 to V8 upgrade on AIX
• SQL Server 2000 install and user management
• DB2 data warehouse design using snow flake and materialized query table
• Data warehousing data loading using Informatica
• Supported DB2 SQL included large joins, global temporary session tables, mass updates, left and full outer joins, nested queries, insert triggers, sub queries, common table expressions, materialized query tables summary tables , mass updates, and case expressions, high volume IMPORT INSERT and LOAD.

Confidential

Sr. DBA

• Backup script of UDB V7 and Oracle RMAN backup setup
• BSR Advance software install upgrade
• DB2 V7 performance tuning and working with development group
• MS-SQL Server 2000 Admin
• Supported developers in the development of very large SQL statements involving in some cases ten or more table joins with left outer joins, nested SQL, and other high performance features
• Worked with them on indexes, database configuration, and SQL rewrites
• Supporting development team of Advance application and resolving production database issues, application and database tuning using Oracle 9i multiple block size, list table partition

Confidential

Principal DBA

• Microsoft SQL server Administration, data transfer using DTS, security admin. using user role
• DB2 user Management, Database Audit
• SQL PL, Perl coding to load data into Oracle data-warehouse using partition tables
• DB2 application and database performance tuning
• RMAN backup and restore
• Multi-master Replication for Internet web-site
• Physical and logical design using Designer/2000
• Designed and implemented Marketing Management System database for the higher profile customers using table partition and transport tablespace
• Oracle Real Application Cluster Server 3 nodes using Vertias Cluster
• Maintaining Designer/2000 repository and working on logical/physical model
• PL/SQL coding, Java, JSP programming
• Data-warehouse design using snow-flake
• DB/2 export, import, load,runstats, reorgchk, reorg, rebind
• Relation connect, Data Joiner, Relational Connect, Buffer Pool Management, Isolate Queries
• Data Joiner, database connectivity, refreshes
• Installed DB2 UDB 7.1 Fixpack 5 on AIX.
• Created new instances and databases
• Informatica data Center install and admin. and supporting batch load process for Oracle/DB2
• Tuning of Informatica batch jobs

Confidential

DBA Consultant Contract

• Management of SQL Server, UDB databases
• Using UDB DB/2 different buffer pool tablespaces for Data warehousing
• Oracle Install/Upgrade Oracle 8I
• PL/SQL programming support
• User/Security Management Oracle role, grants
• SQL Server development support
• Supported Data warehousing project
• Tuning of Informatica batch jobs
• Involved in the SYBASE to DB2 conversion of Insurance system and Data model design to covert Sybase application to Oracle

Confidential

SR. DBA

• Supported Oracle on IBM Mainframes VM/ESA
• Oracle Install/Upgrade Oracle 7.3/8/8.1.5
• Reorganization of tables/indexes
• User/Security Management Oracle role, grants
• Supported Y2K development team Team size 50
• Installed Microsoft SQL Server 6.5 SMS
• Resolved production problems
• Installed Oracle Designer 2.1 repository
• Performed data conversion and testing for Y2K project and production database
• Support of Oracle Financial 10.5 and Microsoft System Management System SMS
• Analysis and design of Market data internet project Logical/Physical
• Designed Oracle data replication process for Market data internet project