SUMMARY

• Solution - oriented Database Administrator wif ten (10) years of IT experience including installation, configuration, daily administration and maintenance of IBM DB2 UDB versions 7.1 V8.1, V8.2, V9.1, V9.5, V9.7, 10.5 Experience providing technical support for HADR wif TSA, Q- Replication involving HADR databases, design and administering DPF Environments, Adding DBPARTITION and REDISTRIBUTION Optim Data Masking, Table partitioning, compression, DB2 Federated Database Technology Vormetric File system encryption and database encryption, DB2 High Performance Unload HPU.

TECHNICAL SKILLS

Platforms: AIX, UNIX, Linux, Windows

Databases: DB2 UDB V7.x, 8.1, 8.2, 9.5, 9.7, 10.5

DB Tools: IBM Data Studio, Quest Central,Toad

PROFESSIONAL EXPERIENCE

Confidential, Roseville CA

DB2 LUW DBA

Responsibilities:

• Working on Multiple environments for Confidential II Confidential In Home Supportive Services IHSS LUW databases hosted by Otech
• Performed Upgrade from DB2 9.5 to DB2 10.5 FP7, installing db2 clients
• Using IBM Optim Data for Masking Test environments and using Federation between databases for Optim
• Implementation of Guardium Vormetric File system encryption and Upgrade Guardium agent, database encryption
• Upgrade Guardium Agent
• HADR Implementation wif TSA cluster using db2haicu for automatic Failover
• Installed db2 10.5 for SAP BO application
• Working wif Curam/ Advantage Application Team to fix day to day Database issues
• DB2 Federated Database Technology
• Redirect Restores between environments, Backups to Disk and commvault
• Implemented Compression on Partitioned MDC tables and saved space.
• Moved tables using ONLINE TABLE MOVE Procedure available in DB2 9.7.
• Experience wif midrange tools: CRON, vmstat, topas, db2top etc.
• Worked on Implementation of TSA, db2haicu, HADR environments.
• Installing db2 clients on windows servers.
• Worked wif various teams in resolving Sev1 issues, working wif db2 support, Investigating Root Causes and doing Root Cause analysis.

Environment: DB2 UDB V9.5, V9.7, V10.5, AIX 5.3,6.1, 7.0, Suse Linux, Commvault, IBM Data Studio, Toad

Confidential, OH/ Torrance, CA

DB2 UDB DBA

Responsibilities:

• Worked on a 65TB 160 partitioned Warehouse database on AIX 5.3
• Involved in the upgrade from DB2 9.1 to DB2 9.7 FP2
• Worked on Q- Replication involving HADR databases.
• Used IBM Optim Data Studio for replicating changes from dev to test to stage and to prod
• Used the LHWM feature of DB2 9.7 to lower high-water mark and provide space back to file system and saved on storage.
• Implemented compression on partitioned MDC tables and saved space.
• Worked wif Raw devices and adding space to tablespaces wif Raw devices
• Moved tables to their own tablespaces and separated indexes.
• Moved tables using ONLINE TABLE MOVE procedure available in DB2 9.7.
• Participated in modeling sessions and created physical database models using ERWIN
• Knowledge of DB2 high performance unloads utility.
• Experienced wif midrange tools: CRON, VMSTAT, TOPAS, db2top etc.
• Performed health checks as per GSD331, complying wif the SLA.
• Performed data mining complying wif CIRATS.
• Worked on Q- Replication involving HADR databases
• Implemented HADR and failover.
• Added Node to a DPF environment and tan subsequently redistributed the tables to balance the DPF environment.
• Redirected restore from TSM on a DPF environment.
• Worked on implementation of TSA, db2haicu, HADR environments.
• Installed DB2 clients on windows servers.
• Work wif various teams in resolving Sev1 issues, DB2 support; investigate root causes and perform root cause analysis.

Environment: DB2 UDB V9.5, V9.7, V10.5, AIX 5.3,6.1. Suse Linux, TSM, IBM Data Studio, Toad

Confidential, Minneapolis MN\

DB2 UDB DBA

Responsibilities:

• Worked on a 65TB 160 partitioned Warehouse database on AIX 5.3
• Involved in the upgrade from DB2 9.1 to DB2 9.7 FP2
• Used IBM Optim Data Studio for replicating changes from dev to test to stage and to prod
• Used the LHWM feature of DB2 9.7 to lower high-water mark and provide space back to file system and saved on storage.
• Implemented compression on partitioned MDC tables and saved space.
• Performed Runstats, Reorg, Rebind, Backup, Cursor Load, Export, Import and other related to database activities.
• Moved tables to their own tablespaces and separated indexes.
• Moved tables using ONLINE TABLE MOVE procedure available in DB2 9.7.
• Performed health checks as per GSD331 complying wif the SLA
• Performed data mining complying wif CIRATS.
• Implemented HADR and failover.

Environment: DB2 UDB V9.7, V10.5, AIX 5.3,6.1. TSM, IBM Data Studio, Toad

Confidential, Benton Harbor, MI

DB2 UDB DBA

Responsibilities:

• Involved in database design, performance tuning and troubleshooting issues on DB2 and assisted the application developers.
• Worked on SAP BW BCU DPF Warehouse database environment, using cockpit from SAP GUI.
• Interacted wif the users, developers, data modelers, business analyst, storage management group, server groups and testers during the entire project to go live.
• Administered, implemented, tuned and maintained databases used by the applications, data management policies and procedures.
• Performed Runstats, Reorg, Rebind, Backup, Load, Export, Import related to database activities.
• Involved in installing DB2 UDB on AIX, created instances and databases on different servers and provided connectivity to development, test, stage and production databases.
• Strong experience in UNIX skills and UNIX Korn shell scripting.
• Recovered databases as necessary from bad load inserts and backups.
• Created IBM problem tickets; applied and installed recommended changes.
• Restored the production database on to the development and staging environments on request of developers using the Rollforward.
• Created and maintained databases, table-spaces, tables, views, and indexes and altered tables and added constraints and referential integrity.
• Undertook database recovery, instance failure and other situations.
• Configured and fine-tuned DB2 DBM and DB configuration parameters for better response throughputs.
• Provided 24x7 production supports.
• Assisted programmers wif all DB2 issues and questions during on and off peaks hours.

Environment: DB2 UDB V8.1, 9.1, 9.5 AIX (5.3)

Confidential, Detroit, MI

DB2 UDB DBA

Responsibilities:

• Involved in database design, performance tuning and troubleshooting the issues on DB2 and assisted the application developers.
• Interacted wif the users, developers, data modelers, business analyst, storage management group, server groups and testers during the entire project to go live.
• Administered, implemented, tuned and maintained databases used by the applications, data management policies and procedures.
• Involved wif the SWIFT project, responsible for the separation of Jaguar Land Rover (JLR) data from Ford databases
• Liaised between Ford SMEs and JLR, in collecting necessary data from the servers used for subsequent cloning.
• Developed strategy for cloning DB2 database from the present environment.
• Developed necessary documents for Low Level Design (LLD) for the databases.
• Developed Clone Go documents for eventual cloning of the databases.

Environment: DB2 UDB V9.1, 9.5 Quest central, AIX 5.3, TSM, Toad 9.5, Windows

Confidential - Benton Harbor, MI

Senior DB2 UDB DBA

Responsibilities:

• Implemented backup and recovery strategies
• Recovered databases after crash from backups stored in TSM until required.
• Restored databases from one box to another using cold or hot backups and rolled forward logs as required.
• Strong experience in UNIX skills and UNIX Korn shell scripting.
• Monitored and management of database server, memory, and space resources.
• Backed up databases frequently depending upon the type like Prod, QA, and Test and scheduled them via Crontab.
• Migrated V7 to V9 using a step of migrating to V8., tan switching DB2 UDB instance between 32 bit and 64 bit to migrate.
• Monitored and managed database server, memory, and space resources.
• Installed DB2 UDB and applied fixpaks to keep DB2 UDB at the most recent level
• Applied fixpaks, pre-installation and post installation steps and binded after fixpaks.
• Uninstalled fixpaks to improve performance in certain situations.
• Monitored any log job failures, instances going down, backup failures, Reorgs, Runstats on tables to claim space and improve performance.
• Coordinated wif SAP Basis on production issues for stopping SAP.
• Setup a federated system to access DB2 family data sources either for local databases on same box or across different boxes.
• Granted/revoked permissions on schemas, tables, tablespaces etc.
• Used tools viz, db2expln, db2trc, db2look, db2pd etc.,
• Created and setup event monitors.
• Checked dbdiag.log for investigating problems.
• Turned on/off file cache on a tablespace.
• Updated licenses for DB2 UDB.
• Provided on call support 24/7 for I2, ITIM, Siebel (OLTP and OLAP), SAP BW system and all DB2 UDB databases; and oracle 9i & 10 g databases
• Configured and fine-tuned DB2 DBM and DB configuration parameters for better response throughputs.
• Performed regular MOB activity (Space management, Log Jobs, Log Archiving etc.)
• Imported and exported schemas, users, whole DB locally or across databases.
• Enabled flashback capability on all tables on all Oracle 9i & 10g databases.
• Used Oracle data pump in 10g instead of export and import.

Environment: DB2 UDB V9.5, V8, V7, Quest central, spotlight, AIX 5.3, TSM, Oracle enterprise Manager Console, Toad 9.5

Confidential

DB2 UDB DBA

Responsibilities:

• Managed Confidential group production, staging, test and development of DB2 UDB databases.
• Involved in installing DB2 UDB on AIX, created instances and databases on different servers and provided connectivity to development, test, staging and production databases.
• Configured the backup and recovery issues on server as CRON jobs.
• Participated in production ON-CALL support rotation.
• Proactively monitored and troubleshot performance, availability, and scalability/capacity issues.
• Created database design and implemented appropriate changes to the physical database (indexes, database and server configurations, etc.) as needed for optimal performance.
• Conducted performance monitoring and tuning for DB2 databases.
• Changed database manager and the database configurations for performance.
• Running the Reorgchk, Reorg, Runstats utilities.
• Created explain tables and ran the visual explain utility on SQL statements.
• Successfully resolved all problems encountered during on call support for DB2.
• Terminated and restarted production utilities including table and index recovery.
• Assisted in testing and production migration of both V6 to V7 and V7 to V8.
• Provided 24x7 production supports.

Environment: DB2 UDB V8.1, 8.2(ESE), AIX5.2, HP-UX, UNIX Shell, Windows 2000/NT, Query Patroller, Logshipping.