Resume

Sign in

db2 dba / sql dba

Location:
Dublin, Ohio, United States
Salary:
120-140k
Posted:
November 26, 2018

Contact this candidate

Resume:

Gosangi Hari

DB* DBA / SQL DBA

614-***-****(H)

614-***-****(Cell)

ac7soj@r.postjobfree.com

U.S. Citizen

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

METHODOLOGIES:

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

PROJECT DETAILS:

Jan’ 2012 to Till date

Client: Honda of America, Mfg

Role: DB2 DBA / SQL DBA

Responsibilities :

SQL Server Administration:

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.

DB2 Administraton:

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

July’ 2010 to Dec, 2011

Client: State of Ohio

Role: DB2 DBA / SQL DBA

Department of Mental Health supports all state hospitals in Ohio. Supported applications like FABS (Financial and Billing Systems), Nursing Assessment, and WIERS applications on DB2 UDB v9.5/9.7 for 24 X7 Support activities. Installation and configuration of IBM DB2 Content Manager Databases along with Web Sphere on LINUX SLES 9,10 platform. Support of SQL Server 2005/2008, Oracle 10g/11g and z/OS Platforms.

Participation into migration of DB2 into SQL server in all phases. Supported all environments on SQL server and DB2 administration.

SQL Server Administration:

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

DB2 Server Administration:

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

Jan’ 2010 to June’ 2010

Client: Cornerstone Brands Inc

Role: Sr. DB2 UDB DBA

Cornerstone Brands Inc, e-commerce based retailer in Ohio having a turnover over of 30 million dollars. Primary resource for Installations, configuration, maintenance and administration of DB2 UDB Databases on 8.1/8.2/ 9.5/9.7 versions of db2.

Responsibilities include:

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.

Aug’2007 to Dec’ 2009

Client: Limited Brands Technology Services

Role: Sr. DB2 DBA

Limited Brands, Inc a largest Retailer with e-commerce business in Ohio having a turnover of 10 billion dollars Company. Primary resource for Installations, configuration, maintenance and administration of DB2 UDB Databases on 9.0/9.5 versions.

Responsibilities include:

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

Oct’ 2003 to Aug’2007

Client: Honda of America, Mfg

Role: Primary DB2 UDB DBA Consultant

Project Details:

Primary resource for Migration of Databases from DB2 UDB 7.1/7.2 to DB2 UDB 8.1/8.2. Good experience on handling Single Partition and Multi Partition databases on AIX system

Handled over 100 GB databases and good experience in working Tense & Tight Time Schedules. Excellent background with Installations, Configuration, Maintenance and Support of the DB2 UDB Databases on Multiple Environments with 24 X 7 on-call Support after the Migration.

Responsibilities include:

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

Oct’ 2001 to Sep 2003

Client: Fireman's Fund Insurance Company, Novata, CA

Role : Primary: DB2 UDB DBA, Seconday: PeopleSoft DBA

Project Details:

Fireman's Fund Insurance Company works to provide business and Personal insurance and to bring customers the highest caliber of claims service. It Provides Insurances for Auto, Event insurance, Personnel Excess Liability, Home... etc.

Responsibilities include:

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

June 1999 to August 2000

Client : PlanetRX.com, South San Fransciso, CA.

Role : DB2 UDB DBA

Project Details:

It is an on-line drug store, which accepts prescriptions from the users, and it is AS/400 and db2 environment.

Responsibilities include:

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.

December 1998 to June 1999

Client : Zantac Inc, Pleasanton, CA.

Role : DB2 UDB DBA

Project Details:

It is known as GlaxoSmithKline - one of the world's leading research-Based Pharmaceutical and healthcare companies - is committed to improving the quality of human life by enabling people to do more, feel Better and live longer

Responsibilities include:

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

March 1996 to Septem 1998

Client : J. K. Tires Ltd, India.

Role : DB2 DBA

Responsibilities include:

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

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

EDUCATION:

Bachelor of Technology (Mechanical Engineering), 1992

Nagarjuna University, India



Contact this candidate