EXPERIENCE SUMMARY:

• I am working as DB2 LUW Consultant for large Data warehouse and I have 19+ years of total IT experience and I am working on DB2 LUW Technology from last 14+ years.
• I have worked as a SYSTEM DBA for 5+ years and now from last 9 years, I am working as APPLICATION DBA. So in DB2 Technology I am having about 14+ years of experience and from last 2.5 years with DB2 I am working as application DBA for MSSQL and Sybase too.
• I have good exprinece in Unix Shell Scripting.I can write SQL, Store procedures, triggers and view.
• I have good knowledge of XML too. Recently for catering the customer need I have explored and worked on, AWS (Amazon web service), DynamoDB, Hadoop.
• Rest of the my experience belongs to supporting ORACLE & Informix DBA support for 2+ years and completed ORACLE (OCA).
• I have good exposure in UNIX, Websphere and Windows and worked for 3+ years in same. I have completed for DB2/Oracle/SUN/MCSE/Cisco/Websphere technology.

TECHNICAL SKILLS:

Operating System: AIX 5.1 /5.2, Linux 2.4/2.6, Sun Solaris 8.x and Windows NT/2000/2003/XP/WIN7/win8

Environment: Data warehouse, OLTP and Mix Mode (Data Mart)

Database: DB2 v9.7,V9.5,v9,7.1, 8.1, 8.2, GreenPlum, Oracle 9.2.0, Informix 7.2, MySql 4,5

Scripting: Perl and shell script

Languages: Visual Basic

Hardware: IBM eServer p630, p610 system, SUN E - 450,E-250,Compaq ES40,Sun ultra 1

New technology: Hadoop

Management and Leadership Skills: Project Management

Development: Technical ability to Train DBA, Developers and Testers

RELEVANT EXPERIENCE:

DB2 & Sybase DBA

Confidential, NY

Platform: DB2 9.7,10,10.5, Sybase 12.5,15.7 MSSQL 2008, Hadoop cloudera

Responsibilities:

• Expert in Shell Scripting I use Sed and awk for powering my scripts for handling Database related tasks
• Here I have worked on Beeline, Sqoop and administration of Hadoop too.
• Here I have integrated Db2 and Hadoop with the Help of SQOOP.
• I am responsible for database Administration and Management in warehouse env.
• Resolving Day to day technical issues, troubleshooting and Providing RCA.
• DB Backup, restore, recover, applying Fixpack, Up - gradation
• Implementing New features and planning and upgrading database versions.
• Monitoring and tuning stored procedure/Queries, Data copying, Scheduling jobs and Database monitoring.
• Governance and oversight
• Processing business Data

DB2 Application DBA/Lead consultant

Confidential

Platform: DB2 9.7,10,10.5, Sybase 12.5

Responsibilities:

• I am supporting large number databases and application developers groups.
• Implementing New features and planning and upgrading database versions.
• Monitoring and tuning stored procedure/Queries, Data copying, Scheduling jobs and Database monitoring.
• I am working on Query & performance tuning, DB Migration,Table compression, Index compression, Large row ID, Range Partition table, Local indexes, Roles, New DB and DBM parameters, MDC, MQT and Database management.
• In Morgan challenging database is Data mart, sales practice and employee trade those are in DPF environment.
• I am responsible for production database support, turnover, Database object creation/Migration to Dev, Qa and Production Env. Assisting developers, Supporting ETL team and other groups Maintaining Database object’s Security, Writing shell script.

Confidential

DB2 SYSTEM DBA / DB2 DBA

Responsibilities:

• Responsible for capacity planning, estimating database growth.
• Responsible for Implementing and maintain Physical Design like creating and maintaining Table spaces, and database objects.
• Designed page sizes for buffer pools and table spaces to achieve optimum Resource utilization.
• I have done Migration like Taradata to Db2, windows to Linux and Sybase to db2.
• I have install, configure and maintained database of 80 TB (DPF) of Confidential .
• This large database was created on 96 Logical Nodes with 12 AIX machine.
• Migrated DB2 UDB from v7.2 to v 8.1 and upgraded from v 8.1 fp5 to v 8.1fp6.b.
• Responsible for Data conversion, data migration from DB2 UDB running on windows to DB2 UDB on AIX.
• Designed, Tested and implemented Backup, recovery and disaster Recovery.
• Designed and implemented database High Availability and fail over scenarios.
• Responsible for DB2UDB resource management such as disk management, memory management.
• Responsible for 24x7 availability of DB2 UDB production databases

DB2 and AIX Admin

Confidential

Platform: AIX and DB2

Responsibilities:

• Installed and configured DB2 UDB 7.2 and DB2 UDB 8.1
• Creating and implementing Unix Shell scripts on AIX servers for DB2 UDB databases maintenance.
• Troubleshooting and Performance Tuning.
• Designed and created Tablespaces, tables, indexes, views.
• Implemented online and off line backup methods on various DB2 UDB databases.
• Implemented Runstats, Reorg,, backup scripts on DB2 UDB databases.

DBA/ Sr. Customer Engineer

Confidential

Platform: DB2 UDB and AIX with R series

Responsibilities:

• Responsible for capacity planning, estimating database growth
• Installed and configured of DB2 UDB database v 8.1 on AIX 5.1 for Development, Testing, and Production Environment on database servers
• Extracted source DDL scripts for creating database objects and schema changes on DB2.
• Migrated DB2 UDB from v7.2 to v 8.1 and upgraded from v 8.1 fp5 to v 8.1fp6.b. Responsible for Data conversion, data migration from DB2 UDB running on windows to DB2 UDB on AIX.
• Designed, Tested and implemented Backup, recovery and disaster Recovery.
• Designed and implemented database High Availability and fail over scenarios.
• Developed several scripts to monitor production databases for growing tablespaces, deadlocks and resource contentions.
• Responsible for DB2UDB resource management such as disk management, memory management.
• Created Users, User Groups and maintained them. Responsible for User Administration. Created DAS and DB2 instances.

Sr. system Engineer

Confidential

Platform: Oracle APPs, Unix

Responsibilities:

• I worked and learned Oracle Apps at Confidential and supported unix operating System.
• Small project like User and forms creation in Oracle Apps
• Shell scripting for automation of tasks

Oracle and Informix DBA/ System Engineer

Confidential

Platform: SUN Solaris, informaix,linux,window

Responsibilities:

• Creation of users, roles, privileges and assigning the rights.
• Defined backup procedures using daily hot backups and weekly cold backups.
• Ensuring proper online and offline backup, Periodical reading and checking.
• Performance monitoring and tuning of Oracle DatabaseCreated and maintained database objects.
• Installation of Oracle 8i, 9i on Windows NT, WIN 2000,Sun Solaris.
• Involved in creating backup scripts.
• Involved in tuning of the existing system for performance tuning.
• Involved in developing strategy for data extraction from legacy systems.

Confidential

Technical Consultant

Platform: Solaris,linux,win NT

Responsibilities:

• Tablespace Design and Container Placement according to disk layout.
• User and Space Management.
• Security and Authorizations.
• Backup and Recovery Strategy.
• Table export and import.
• Application version up-gradation.
• Network management.