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.
• Earlier, I have SETUP India’s biggest DB2 warehouse for Bharti ( Confidential ) and in Confidential also I am handling many data warehouses and critical OLTP Env., time to time with my practice (Infra) I have supported others account also.
• Rest of the my experience belongs to supporting ORACLE & Informix DBA support for 2+ years and completed ORACLE certification (OCA). I have good exposure in UNIX, Websphere and Windows and worked for 3+ years in same. I have completed certification for DB2/Oracle/SUN/MCSE/Cisco/Websphere technology.

RELEVANT EXPERIENCE:

DB2 & Sybase DBA

Confidential, NY

Responsibilities:

• DB2 luw, Sybase ASE, MSSQL, Unix Shell Scripting and Hadoop Support - Developing Solution In Confidential am working as DB2 & syabse Application DBA and for catering customer need I have explored New Technology like AWS, DynamoDB, MSSQL and Hadoop. At client site we have devolped a tool which is know as Pipeline which is a continuous deployment tool for AFS turnover. I have played a major role in setting, coding and database deplopment and managment for it. Now I have main resposibilty for managing and enhancing it.
• 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

Responsibilities:

• In Confidential am working as Application DBA.
• 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.

DB2 SYSTEM DBA / DB2 DBA

Confidential

Responsibilities:

• 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/ Level F

Tea Board of India Accenture

Responsibilities:

• production support for DB2 UDB 7.2/ 8.1 database servers.
• 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

Responsibilities:

• Responsible for Implementing and maintain Physical Design like creating and maintaining Tablespaces, and database objects. Designed page sizes for bufferpools and tablespaces to achieve optimum Resource utilization
• Responsible for capacity planning, estimating database growth
• Installed and configured of DB2 UDB database v 8.1 on AIX 5.1 for Development, Testing, Training 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
• I worked and learned Oracle Apps at Ducat 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

Responsibilities:

• Maintaining the Oracle Database on the Production Machines in good condition.
• 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

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.

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

Training & Development: Technical ability to Train DBA, Developers and Testers