SUMMARY:

• Over 20 years experience in Design, Implementation, Administration and Full life cycle development using IBM DB2 & SQL Server Administration.
• Extensive experience carried out as a DB2 DBA on both Mainframe and Client Server Platforms & Over 7 years of experience with SQL Server Administration with an experience in Data Modeling, Relational design, Object relational database design, Logical and Physical Database design, Stored Procedure, Triggers, Database Maintenance, Database Migrations, Performance Monitoring and Tuning, Backup and Recovery, Space management, Disaster recovery and Security maintenance, Automating and Scheduling Maintenance jobs.
• Having good knowledge with Oracle and Cache databases.
• Around 2 years of experience with Installation, administration, support and maintenance of Enterprise Content Manager systems like IBM db2 content manager, IBM FileNet P8, IBM Content Navigator, IBM Case manager, IBM datacap & other related software’s.

TECHNICAL SKILLS:

• Good knowledge of Capability Maturity Model Integration (CMMI) Product Suite
• Good Knowledge of Six - Sigma Quality Methodologies
• Good Knowledge of Kepner-Tregoe Decision making framework tool
• Good Knowledge of ITIL (Information Technology Infrastructure Library)
• Good knowledge on Sarbanes-Oxley methodology

PROFESSIONAL EXPERIENCE:

DB2 DBA / SQL DBA

Confidential

Responsibilities:

• Experience in Installation & Configuration of SQL server & Patches on different servers
• Provided 24 X7 support to SQL server databases through managing, monitoring & troubleshooting SQL sever 2000/2005/2008/2012/2014/2016
• Experience in SQL server Backup/ Restore, migration & upgrading of SQL Servers.
• Experience Configuring, administering and Troubleshooting, managing replication servers
• Experience in Log shipping, mirroring and clustering environments
• Experience in Net Backup client for scheduling backups and recovery
• Managing logins, users, roles and User permissions
• Experience in SQL Server Profiler and other tools for trace analysis
• Experience in monitoring, tuning, and analyze database performance and allocates resources to achieve optimum database performance
• Manages several environments for application teams like DEV,QA,SI and Production
• Experience in ETL processes(Informatica, Erwin, Data Stage) and experience in Crystal reports
• Experience ion developing and monitoring SSIS, SSRS packages & import or export data
• Involved in pre and post migration activities from DB2 udb 9.7 to SQL Server 2005/2008
• Experience carried out on all phases of Migration activities from DB2, Oracle to SQL server.
• Experience with security features like auditing, encryption and row level security.
• Experience with Cloud technologies like AWS, GCP
• Good Experience carried out with Logical and Physical design on both Distributed Systems, Mainframe Systems & Windows.
• Excellent experience carried out on Migrations, Installations, Configuration and Maintenance of DB2 UDB V 9.1/9.7 & DB2 V9.7 /9.8 to DB2 V 10.1/ 10.5/11.1 databases
• Excellent experience carried out on setting up HADR using TSA 3.2
• Migrated several Instances of databases from v9.1 to v9.7 & DB2 V9.7 to DB2 V 10.1/ 10.5/11.1 with large volume of data
• Migrated Databases on different environments like Dev, SI, QA and Production Systems
• Good experience in doing Benchmark Testing during migration cycle
• Good experience in handling Pre-Migration & Post Migration Tasks
• Good experience with Migration of DB2 UDB V 9.7 databases to DB2 UDB v 10.1/ 10.5/11.1 Databases on AIX P Series Systems
• Good experience with Purescale systems & Cloud Solutions
• Good experience carried out with Q-replication(QREP)
• Good experience in Backup & Restore Methodologies
• Good Knowledge of Back out Methodologies and PPA
• Good experience in Problem identification, analysis, determination and resolution activities
• Strong experience with Reorgs, Runstats, db2look, db2move, inspect and other utilities
• Experience on Performance Monitoring, Tuning of the databases
• Excellent background with Unix Scripting, LPAR technology, OS Tuning parameters
• Excellent background in working with Tense situations and at Critical times

DB2 DBA / SQL DBA

Confidential

Responsibilities:

• Experience in Installation & Configuration of SQL server & Patches on different servers
• Provided 24 X7 support to SQL server databases through managing, monitoring & troubleshooting SQL sever 2000/2005/2008/2012/2014/2016
• Experience in SQL server Backup/ Restore, migration & upgrading of SQL Servers.
• Experience Configuring, administering and Troubleshooting & transactional replication servers
• Experience in Log shipping, mirroring and clustering environments
• Experience in Net Backup client for scheduling backups and recovery
• Managing logins, users, roles and User permissions
• Experience in SQL Server Profiler and other tools for trace analysis
• Experience in monitoring, tuning, and analyze database performance and allocates resources to achieve optimum database performance
• Manages several environments for application teams like DEV,QA,SI and Production
• Experience carried out on all phases of Migration activities from SQL Server to DB2.
• Experience with security features like auditing, encryption and row level security.
• Experience with Cloud technologies like AWS, GCP
• Installation & Configuration of DB2 UDB V 8.1/8.2/9.0/9.5/9.7 Software & Fixpaks on different servers with LINUX 9, 10
• Installation and Configuration of IBM DB2 Content Manger v8.4.2 and Web Sphere v6.1
• Migrated the data from IBM DB2 Content Manager v8.3 to v8.4.2
• Supported Library Server and Resource Manager Server Databases on IBM DB2 Content Manager 8.4.2 & DB2 V9.1 Fixpack 3
• Creation & Configuration of DB2 Databases on Content manager Environment.
• Migrated Databases on different environments like Dev, SI, QA and Production Systems
• Implemented Backup & Restore, Crash Recovery, Disaster Recovery methodologies
• Supported the Data Warehouse environment for State
• Trouble Shooting, Fixing, Applying Patches and Fixpacks, and Back out Methodologies
• Problem identification, analysis, determination and resolution activities
• Experience with Reorgs, Runstats, db2look, db2move, inspect and other utilities
• Performance Monitoring, Tuning of the databases
• Excellent background with Unix Scripting
• Excellent background in setting up HADR environments for Failovers
• Excellent knowledge on Change Management and Change Control
• Excellent background in working with Tense situations and at Critical times
• 24 X 7 on-call rotation support

Sr. DB2 UDB DBA

Confidential

Responsibilities:

• Installation & Configuration of DB2 UDB V 8.1/8.2/9.0/9.5/9.7 Software & Fixpaks on different servers with LINUX
• Creation & Configuration of DB2 Databases on WCS Environment.
• Migrated Databases on different environments like Dev, SI, QA and Production Systems
• Implemented Backup & Restore, Crash Recovery, Disaster Recovery methodologies
• Trouble Shooting, Fixing, Applying Patches and Fixpacks, and Back out Methodologies
• Problem identification, analysis, determination and resolution activities
• Experience with Reorgs, Runstats, db2look, db2move, inspect and other utilities
• Performance Monitoring, Tuning of the databases
• Excellent background with Unix Scripting
• Excellent background in setting up HADR environments for Failovers
• Excellent background in working with Tense situations and at Critical times

Environment: LINUX, DB2 UDB v 8.1/8.2/9.0/ 9.5 (ESE), WebSphere Commerce Server, WebSphere MDM, WebSphere Portal, WebSphere Message Broker, Apache, Java, .Net.

Sr. DB2 DBA

Confidential

Responsibilities:

• Installation & Configuration of DB2 UDB V 9.0/9.5 Software & Fixpaks on different servers
• Migration of Instances, Databases with large data over terabyte
• Migrated Databases on different environments like Dev, SI, QA and Production Systems
• Benchmark Testing, Pre-Migration & Post Migration Tasks during the transition
• Excellent experience with Migration of DB2 UDB V8.1/8.2 databases to DB2 UDB V9.0/9.5 databases on Sun Solaris 10 System
• Backup & Restore, Crash Reovery, Disaster Recovery methodologies
• Trouble Shooting, Fixing, Applying Patches and Fixpacks, and Back out Methodologies
• Problem identification, analysis, determination and resolution activities
• Experience with Reorgs, Runstats, db2look, db2move, inspect and other utilities
• Performance Monitoring, Tuning of the databases, db2connect etc
• Excellent background with Unix Scripting
• Excellent background in working with Tense situations and at Critical times

Environment: Sun Solaris 10 Sparc, DB2 UDB v9.0/ 9.5(ESE), WebSphere 6.1, WebSphere commerce, WebSphere Portal, Apache, Fatwire Content Management, DB2 Connect, PRPC, SOAP, Java, .Net, QREP

Primary DB2 UDB DBA Consultant

Confidential

Responsibilities:

• Good experience with Installation & Configuration of DB2 UDB V 8 Software & Fixpaks on different servers
• Good experience in Migrating number of Instances, Databases with large data
• Migrated Databases on different environments like Dev, SI, QA and Production Systems
• Good experience in doing Benchmark Testing during migration cycle
• Good experience in handling Pre-Migration & Post Migration Tasks
• Good experience with Migration of DB2 UDB V 7.1/7.2 database to DB2 UDB V 8.1/8.2 Databases on AIX System
• Good experience in Backup & Restore Methodologies
• Good Knowledge of Back out Methodologies and PPA
• Good experience in Problem identification, analysis, determination and resolution activities
• Strong experience with Reorgs, Runstats, db2look, db2move, inspect and other utilities
• Experience on Performance Monitoring, Tuning of the databases
• Excellent background with Unix Scripting
• Excellent background in working with Tense situations and at Critical times

Environment: IBM RS/6000 SP, AIX v 4.3.1 / 5.2, DB2 UDB v7.1/ 7.2(EE)/v8.1/8.2 (ESE), I2 SCM, Ariba, DB2 Connect, WebSphere 5.0/5.1, MQ Series, SOAP, Java, .Net, ANT, Net Search Extender

Primary: DB2 UDB DBA

Confidential, Novato, CA

Responsibilities:

• Installation and configuration of DB2 UDB V 6.1 on AIX v 4.3 Platform.
• Provided DB2 Setup and Support for the Migration of PeopleSoft HRMS 7.5 to 8.0.
• Provided DB2 Support for the Migration of PeopleSoft from other Platform Database to DB2.
• Maintained Backups, recovery and reorganization of databases using DB2 utilities.
• Involved in Performance monitoring and tuning of the DB2 Database.
• Maintained the Security and Access for User Identification.
• Built and issued DB2 commands, solved DB2 and related applications problems.
• Involved in Writing the Stored procedures and Triggers.
• Configured and performed the Replication of databases.
• Involved in Data Storage Management and maintaining data.
• Involved in Diagnostics and Problem Determination activities.
• Involved in SQL Monitoring and used Visual Explain to get the better access plan.
• Ensure a secure, recoverable, high performance environment.

Environment: IBM RS/6000 SP, AIX v 4.3.1, DB2 UDB V 6.1(EE), SQL, BMC utility, Data Propagator, PeopleSoft HRMS 7.5, Cache Database Systems..

DB2 UDB DBA

Confidential, South San Francisco, CA

Responsibilities:

• Maintaining a DB2 database by analyzing, designing, testing and implementing database changes.
• Providing 7/24 support of DB2 databases.
• Recovering large DB2 tables and indexes.
• Implementing backup methodology for DB2 database.
• Determining optimal sizing of DB2 databases.
• Analyzing performance of DB2 databases and tuning them as necessary.
• Evaluating problems while considering possible performance issues and other impacts on Overall community.
• Involved in Cleanup and documentation activities by gathering information from the Users.
• Experience in data sharing.

Environment: AS/400, OS/400, AIX v 3.x, DB2/400, DB2 V5.1 (EE), Data Joiner v 2.0/2.1, SQL, DB2 Connect, Platinum tools.

DB2 UDB DBA

Confidential, Pleasanton, CA

Responsibilities:

• Backup, recovery and reorganizations of databases using IBM utilities.
• Re-sizing of production and test databases into single extents to improve performance.
• Re-organizing tablespaces and indexespaces.
• Altering table structure.
• Create new databases and reports Modify and enhance existing databases.
• Review pre-production SQL changes and make performance recommendations based on EXPLAIN analysis.
• Synchronize all table definitions across all DB2 sub-systems.
• Partition all tablespaces in test region that are partitioned in production.
• Set up process to run IBM Runstats against all tablespaces and rebind all PLANS/PACKAGES.
• Monitor DB2 activities using third- party product

Environment: SUN SOLARIS v 2.7, DB2 UDB V4.1, SQL, Platinum tools, BMC tools, IBM DB2 utilities

DB2 DBA

Confidential

Responsibilities:

• Maintaining a DB2 database by analyzing, designing, testing and implementing database changes.
• Providing 7/24 support of DB2 databases.
• Recovering large DB2 tables and indexes.
• Implementing backup methodology for DB2 database.
• Determining optimal sizing of DB2 databases.
• Analyzing performance of DB2 databases and tuning them as necessary.
• Evaluating problems while considering possible performance issues and other impacts on the overall community.
• Involved in Cleanup and documentation activities by gathering information from the users.
• Experience in data sharing

Environment: IBM/3090, O/S 390, Win NT,MVS, DB2 V 3.1, JCL, SQL, CICS,TSO/ISPF, COBOL, DB2 Connect, Data Joiner v2.0, BMC utilities.