PROFESSIONAL SUMMARY

• Hands on experience on DB2 V8.x, V9.x, V10.x. Basic Knowledge on ORACLE.
• Experience on End to End implementation of Q Replication and SQL replication.
• Migrating teh DB servers from existing VCS cluster to TSA Cluster.
• Apply teh db2 patches by using zero down time Approach.
• Developed Custom scripts for controlling MQ and Q - apply using TSA cluster.
• Hands on experience in Database partition feature.
• Involved in flash copy recovery for databases in huge size.
• Strong knowledge in Database Physical Support and Design
• Hands on experience on DB Backup and Recovery strategies.
• Hands on experience of Cloning/Data refresh from Production to Development/UAT environments.
• Hands on experience in Migrating Databases from DB2 V8 to V9.x and DB2 V9.x to V10.x
• Actively Involved in design/configuring databases on HADR-TSA & HADR-HACMP and HACMP/VCS clusters
• Design and implement all teh latest features of DB2 V9.1, V9.5, V10.1 and V10.5 DATA and INDEX COMPRESSION wif REORG, Range-Partitioning, SYSIBMADM views, DPF etc.
• Experience in managing Tablespace Capacity Management, Archival logs and DB Backups
• Extensive experience in Create, delete, drop, update tables in DB2 databases.
• Usage of tools like DB2 Load, Import, Export and Reorg, Run stats, Reorg Check, Backup, Restore and Db2move
• Extensive experience in working wif db2 specific tools such as db2pd, db2dart, db2support, db2top, db2inspect, db2advise,db2explain, db2diag,db2look, db2move & db2relocatedb
• Having conceptual Knowledge on Basic hardware & networking.
• Handled various aspects like solution design documentation, system design and integration.
• Deployed and configured OEM 12c plug-in for IBM DB2 LUW environments.
• Provide weekly status reports on database health and performance.
• Configured database auditing feature as a security measure for tracking un-authorized connections/ activities.
• Build teh Logical and Physical standby databases, Failover and participating in DR Test.
• Checking Databases Backup and Restore validity periodically and Data refreshes from Production to Non-Production environment.
• Developed and implemented backup(online, offline), runstats, reorg, rebind and tablespace capacity monitoring report using Korn shell scripts on DEV, QA (UAT), and PROD systems.
• Worked on configuration/troubleshooting federated database environment.
• Experience in providing 24/7 Production support on large Databases of more than 10 TB and involving handling of Severity outage calls, database performance issues, storage management and tuning of databases for optimal performance.
• Handling all types of tickets and resolving wifin teh SLA's and completing SRM's and WO's wifin time.
• Tuning of DBM and DB cfg parameters to yields teh maximum performance.
• Configured teh partition technique for large tables to me/O and efficient data management.
• Worked on tuning database and Database manager configuration for optimum performance to support ETL applications. Worked on tuning Long Running Queries using db2batch, EXPLAIN, db2exfmt and db2advis
• Developed and Deployed teh database maintenance shell scripts to stable teh DB2 environment
• Gather Table/Index statistics and histograms and Tune Databases parameters for better SQL performance
• Monitored database and system performance and identified and removed bottlenecks. Monitored performance of teh databases utilizing event monitors on statements, snapshots on database, locks, applications, bufferpools and tablespaces etc. Selected appropriate Database configuration parameters for efficient database operation. Optimized buffer pool configurations on DB2/UDB server. Interact wif teh System Administrator for database issues including capacity planning, such as installation and configuration of new disks on Unix Systems.

TECHNICAL SKILLS

Operating system: AIX, LINUX, UNIX, SUN SOLARIS, Windows 2003 server, XP.

Languages: SQL, UNIX, Shell Scripting

RDBMS: DB2 UDB v8..x, v9.x,v10.x, oracle 9i, Oracle 10g and MS SQL.

Software: IBM Tivoli TSM and HADR

Monitoring Tools: Quest, Foglight, DB2MON and IBM Optim Performance Manager.

Tools: Manage Now, BMC Remedy, Maximo and Service Desk.

PROFESSIONAL EXPERIENCE

Confidential, Jersey City, NJ

Senior Database Administrator

Environment:DB2 UDB v9.5,v9.7,v10.1&V10.5, OS - AIX, Linux

Responsibility:

• Installation and Configuration of DB2 environment in LUW.
• Upgradation of database from v9.5fp7 to V9.7 fp11 from v9.7fp11 to V10.5 fp6.
• Actively Involved in design/configuring databases on HADR-TSA/HADR-VCS and VCS clusters.
• Apply teh db2 patches by using zero down time Approach.
• Setting up teh Q-Replication as per customer requirement by using Bi-Directional strategy.
• Experience in managing Table space Capacity Management, Archival logs and DB Backups.
• Extensive work experience in DB Tuning, Performance issues and Query Optimization using db2batch & db2advis
• Having experience on DPF environment servers.
• Setting up teh Zero Down Time server as per customer requirement by using database WRITE SUSPEND/RESUME mode.
• Strong knowledge in Database Physical Support and Design
• Hands on experience on DB Backup and Recovery strategies.
• Hand-on experience in Migrating Databases from DB2 V9.x to V10.x
• Extensive experience in working wif db2 specific tools such as db2pd, db2dart, db2support, db2top, db2inspect, db2advise,db2explain, db2diag,db2look, db2move & db2relocatedb.
• Ensure availability of databases through database backups, verifying backups, ensure proper functioning of Jobs
• Improve security by controlling user privileges/roles and implement profiles to meet teh Security Standards.
• Create and maintain DB2 UDB instances and databases for development, test, and production environments wifin AIX operating environment.
• Implemented backup compression techniques and can support Time finder backups
• Having good knowledge of AIX and Linux Operating System
• Monitor security breaches, error log(s), database and log space, user activity and resource utilization of production environment. Work wif application programmers to ensure dat application problems do not adversely affect production operations
• On-call 24x7 production support and Training guidance to offshore DBA's

Confidential

Senior Database Administrator

Environment:DB2 UDB V9.1, v9.5,v9.7&v10.1, OS - AIX, Linux

Responsibility:

• Installation and Configuration of DB2 environment in LUW.
• Stabilizing teh DB2 environments and streamlined teh systems.
• Identifying key milestones and deliverables.
• Upgradation of database from v9.5 fp10 to v9.7 fp7.
• Configuring teh High Availability techniques like HADR& HACMP.
• Installing and configuring teh databases to IBM OPM tool for proactive monitoring of DB2 databases.
• Extensive experience in fine tuning of long running queries.
• Extensive experience in loading large volumes of data across DB’s.
• Backup & Recovery of Database, Online database backup, archived log files and Offline.
• Granting / revoking various authorizations to different Users/Groups.
• Capture and analyze Explain and Visual Explain information.
• Usage of tools like DB2 Load, Import, Export and Reorg, Run stats, Reorg Check, Backup, Restore, Db2move and Db2look
• Creation and management of both system level and object level roles and privileges for various users. Killing sessions and granting/revoking user privileges and roles.
• Exposure on DR test & strategies like Failover Clustering/HADR.
• Cataloging Databases on various nodes.
• Involved in physical database layout design.
• Working wif apps team to deploy teh releases on time and more accurately.
• Snapshot monitoring was done to detect deadlocks, buffer pools and lock escalations.
• Provide assistance to teh development team on performance tuning, resolving locking situations, assist data modeler wif SQL scripts.
• Responsibilities include disaster recovery, capacity planning and Real Time monitoring, troubleshooting and proactive maintenance.
• Perform file system copy from production to non-production using TSM backup and recovering DB2 databases in non-production environment.
• Implemented Database partitioning and Archival logging in DB2 UDB.
• Troubleshoot teh issues as and when required.
• Attending Weekend calls wif offshore and onsite teams.
• Setup and maintain documentation and standards.

  Confidential

  Senior System Administrator

  Environment:DB2 UDB V9.1, v9.5,v9.7&v10.1, OS - AIX, Linux

  Responsibility:

  • Install IBM DB2 9.7 on AIX Server on seven systems, install DB2 client on Workstations and Catalog teh Databases.
  • Upgradation of database from v9.7 fp4 to fp6 and from v9.7fp4 to fp7.
  • Data compression at DB level for DB2 systems to get optimum performance of sql queries and storage savings.
  • Implemented teh Compression feature to reduce teh storage costs and improve teh performance ofthe applications.
    • Extensive experience in fine tuning of long running queries.
    • Implemented ARCHIVELOG process to maintain active log files.
    • Performed Database migration/upgrades between multiple versions.
    • Hands on experience on DB Backup and Recovery strategies.
    • Analyzing and implementing DB2 reorg utility based on teh need for database reorganization
    • Handling table space and file systems space issues. Extending Table space
    • Working and troubleshooting on day-to-day problems via opening and closing tickets.
    • Automate teh db2diag and notification log files by updating dbm parameter.
    • Create PMRs wif IBM in case of any software and problems issues wif DB2
    • Setup and maintain documentation and standards.
    • Performed Server migration.
    • Provide 24/7 Oncall support on rotational basis.
    • Upgradation of database from v9.7fp4 to fp6 and from v9.7fp4 to fp7.
    • Extensive experience in loading large volumes of data across DB’s.
    • Cataloging Databases on various nodes.
    • Involved in physical database layout design.
    • Implemented Database partitioning and Archival logging in DB2 UDB.
    • Troubleshoot teh issues as and when required.
    • Attending Weekend calls wif offshore and onsite teams.
    • Setup and maintain documentation and standards.

      Confidential

      Senior database administrator

      Environment:DB2 UDB V9.1, v9.5 & v9.7, OS - AIX, Solaris,Linux

      Responsibility:

      • Maintained CIRATS APAR( Fixpak installations)
      • Maintained Database security (GSD-331 Standards)
      • Installation, configuration and upgrade DB2 databases.
      • Creation of Instances and databases.
      • Database objects creation & alteration (tables, indexes, views etc)
      • Configuring Client / Server Connectivity.
      • Managing Database user privileges (granting & revoking permissions)
      • Database monitoring (free space in table spaces, snapshot, and Log verifications)
      • Maintaining Database backup & recovery.
      • Data Movement Utilities Like export, import, load & Move.
      • Data Maintaining Utilities Like Reorgchk, Reorg, Runstats.
      • Restoration of databases from online and offline backups.
      • Experience in restoring databases in standalone server.
      • Amended Load scripts to get better logging.
      • Cataloging Databases on various nodes.
      • Worked wif application team in fixing teh code releases & IT Builds
      • Involved in 24x7 support and On-call support.

      Confidential

      Database Administrator.

      Environment:DB2 UDB V9.1, v9.5, OS - AIX, LINUX

      Responsibility

      • Installation, Creation and Configuration of Databases on AIX and Linux.
      • Administration of Databases, Storage Groups, Table space, Tables, Views.
      • Tablespace creation (both DMS and SMS)
      • Creation of buffer pools, table spaces, tables using command center or Control center.
      • Extending Table space, Creating & Dropping various DB2 Objects.
      • Configured Backups and Archival logging to TSM.
      • Restore/Redirect Restore of Databases as per teh requirement
      • Cataloging Databases on various nodes.
      • Resolved DB2/TSM issues.
      • Execute and run commands by using CLP and CLI.
      • Handling table space and file systems space issues.
      • Used Utilities DB2look,Db2trace,Db2move,Export, Import, & operational utility.

      Confidential

      Database Administrator

      Environment:DB2 UDB V8.1,v8.2, V9.1 OS - AIX & Linux.

    • Responsibility:
      • Working knowledge of Database architecture.
      • Supporting around 120 databases including Production, Development & Test wif highest database size of 1.5 TB.
      • Granting / revoking various authorizations to different Users/Groups to make it compliant as per ISCD.
      • Taking Online /offline backup of Database, Table space.
      • Monitoring teh scheduled jobs like backups, data loads etc.
      • Maintained Database security (GSD-331 Standards).
      • Data Movement Utilities Like export, import, load & Move.
      • Data Maintaining Utilities Like Reorgchk, Reorg, Runstats.
      • Convert tablespaces to use Autostorage.
      • Database cloning using redirected restores(from one instance to other instance)
      • Cataloging Databases on various nodes
      • Assisting wif teh creation and modification of primary database storage structure(tablespaces) and primary objects(tables, views, indexes)
      • Analyze production failures and slow performance byDB2diagnosis tool such as DB2top DB2pdby snapshots.