We provide IT Staff Augmentation Services!

Db2 Dba Resume

Jersey City, NJ

CAREER SUMMARY:

  • Having 8 Years of total IT experience in DB2 as a DB2 UDB Administrator, Experience on DB2 utilities, handling production and Development Issues.
  • DB2 installations, configurations, patching and upgrades in Production, Q/A, Test and Dev environments
  • Experience on DPF environment.
  • Experience on creating the new database and maintaining database objects
  • Create DB2 database online/offline backups
  • Experience on creating the new Table Space on DPF environment
  • Hands on experience in maintaining Table space spaces, Tables in DB2 databases running on LUW platforms
  • Experience on maintaining Database Manager and Database Configuration Parameters
  • Expertise in using DB2 Movement Utilities like Export, Import and Load
  • Troubleshooting database issues using db2diag, db2pd, Snapshots and event monitors
  • Generating DDL using DB2LOOK utility
  • Catalog databases and install DB2 Client on application servers
  • Performance tuning by monitoring, taking snapshots
  • Expertise in running REORGCHK, REORG and RUNSTATS for better performance of the database
  • Installed DB2 V10.5 Fix Pack 7 on AIX, Sun Solaris Servers
  • Table space management - Adding, dropping, extending, reducing and resizing table space containers
  • Backup & Recovery of Database, Online database backup, archived log files and Offline
  • Granting / revoking various authorizations to different Users/Groups
  • Implemented DB2 Security, Locking and Concurrency Control
  • Strong collaboration, team building, interpersonal, communication skills with proficiency

TECHNOLOGY PROFICIENCY:

Operating System: Windows 2003/NT, AIX P6, Sun Spark, Linux

Database: DB2 UDB, SQL Server 2005, Oracle

Reporting Tools: Service Now, PPM

PROJECTS EXPERIENCE:

Confidential, Jersey City, NJ

DB2 DBA

Environment: DB2 V10.5 FP7. 1V9.7 FP 10, Sun solarise, AIX P6, ZLinuxSQL Server 2005, Oracle, IBM Data Stage and Netezza

Responsibilities:

  • Installed the Fix Packs and updated the instances
  • Installed ESE in database server and data server client installed in Mw servers
  • Experience on creating the new database and maintaining database objects
  • SQL Server 2008/2005 and IBM Data stage Administration to Multiple applications of Confidential P&C
  • Experience on Creating the new table Space
  • Addressing all database server alerts with in SLA
  • Hands on experience in maintaining Table space spaces, Tables in DB2 databases running on LUW platforms
  • Experience on maintaining Database Manager and Database Configuration Parameters
  • Expertise in using DB2 Movement Utilities like Export, Import and Load
  • Troubleshooting database issues using db2diag, db2pd, Snapshots and event monitors
  • Expertise in running REORGCHK, REORG and RUNSTATS for better performance of the database
  • Generating DDL using DB2LOOK utility
  • Daily data refresh from production to QA environment
  • Performance tuning by monitoring, taking snapshots
  • Backup & Recovery of Database, Online database backup, archived log files and Offline
  • Granting / revoking various authorizations to different Users/Groups
  • Creating Client instances for Application, Data stage and Cogon’s servers and cataloged the required databases
  • Resolution of user queries: Resolution for the user queries for all above tasks and application errors which are affected due to database level issues in day to day basis
  • Tuning of db and dbm configuration parameters
  • Database (DB2 UDB) maintenance and support
  • Performance tuning the database for better and faster results
  • Providing weekend on call support
  • Use the NzAdmin administrative tasks including Genstats Groom, and manage Development
  • Perform backup and restore activities

Confidential, Bloomington, IL

DB2 - DBA

Environment: DB2 UDB v 9.1, V9.5, AIX, Linux.

Responsibilities:

  • Create and Manage Servers, instances and databases
  • View and modify database and database manager configuration parameters
  • Configure clients and servers connectivity
  • Perform DB2 Security, control database access, grant/revoke authorities and privileges
  • Monitored the table space’s growth and added/extended the containers accordingly
  • Worked with data movement utilities IMPORT, LOAD, and EXPORT
  • Fulfil/Accomplish with the SLA (Service Level Agreement) to provide an accurate service delivery
  • Reorganizing Tables and Indexes for improving performance
  • Generating DDL using DB2LOOK utility
  • Enable DB2 event Monitoring and snapshots
  • Capture and analyze Explain and Visual Explain information
  • Done Backup (online and offline), Restore and Redirect Restore
  • Checked the database backup image's integrity using db2ckbkp
  • Performance tuning the database for better and faster results
  • Table space management - Adding, dropping, extending, reducing and resizing table space containers
  • Sending daily and weekly reports and handovers

Confidential

DB2 DBA

Environment: DB2 V9.1 FP 4, V9.5 FP 1, AIX P6, P7, Linux.

Responsibilities:

  • Providing support to System Administration(SA) in database installation, instance Creation and instance upgrade
  • Tuning of db and dbm configuration parameters
  • Weekly database size report and table space utilization report
  • Database (DB2 UDB) maintenance and support
  • Performance tuning the database for better and faster results
  • Worked on EXPORT, IMPORT and LOAD utilities, moving Data between servers
  • Daily and weekly database Maintenance activities such as backup, reorgchk, reorg, run stats and all related activities for OLTP database
  • Table space creation on DPF environment
  • Table space management - Adding, dropping, extending, reducing and resizing table space containers
  • Restoring the database as per client requirement on test environment
  • Stored Procedure compilation and execute privileges to user
  • Granting & revoking various authorizations to different user/groups
  • Database monitoring using Snapshots and Event monitoring
  • Resolution of user queries: Resolution for the user queries for all above tasks and application errors which are affected due to database level issues in day to day basis

Confidential

DB2 - DBA

Environment: Windows xp, Windows 2003, DB2 UDB v 9.1.

Responsibilities:

  • Tuning of db and dbm configuration parameters
  • Monitored the table space’s growth and added/extended the containers accordingly worked with data movement utilities IMPORT, LOAD, and EXPORT
  • Reorganizing Tables and Indexes for improving performance
  • Generating DDL using DB2LOOK utility
  • Done Backup (online and offline), Restore and Redirect Restore
  • Checked the database backup image's integrity using db2ckbkp
  • Granting database privileges to the users
  • Performance tuning the database for better and faster results
  • Table space management - Adding, dropping, extending, reducing and resizing table space containers
  • Exporting the data from production and loading it in test boxes
  • Sending daily and weekly reports and handovers.

Hire Now