We provide IT Staff Augmentation Services!

Db2 Udb Dba Resume

Chandler, AZ

SUMMARY:

  • About 8+ years of diversified experience of IBM DB2 UDB in database administration, migration, Design, Implementation and Production support for DB2 UDB Databases for OLTP& Data warehouse databases
  • Extensive experience in carrying out DB2 Database Administration activities on AIX / LINUX involving development, Database Design, data structure, Modeling and Tuning, Query Optimization, Space Management and Security Maintenance
  • Installing IBM Change Data Capture tool in AIX environments
  • Proven ability to create, administer and migrate and effectively performance tune over large number of database / client servers on a 24X7 basis in a high availability environment
  • Thorough knowledge on maintaining data integrity and security in production and test databases
  • Had done various projects using RMAN for Backup and Recovery, Data guard for Disaster Recovery, Installation, Configuration, Migration, Upgrade, Cloning, Patching, Performance Tuning
  • Worked with a wide range of utilities which includes BACKUP, RESTORE, RUNSTATS, REORGS, EXPORT, IMPORT and LOADS
  • Provided on call support (24X7) for all database issues on rotation basis
  • Installed and monitored Disaster Recovery boxes and HADR for critical databases and have knowledge about db2purescale
  • Good hands on apply and implement the DATA DISTRIBUTION STRATEGIES
  • Setting up High Availability Disaster Recovery (HADR ) also involved in testing failover scenarios and storage technologies like Data Replication, SRDF and non - SRDF
  • Involved in design, development and deployment of DB2 Stored Procedures and Functions to supplement translated procedures for LUW platforms
  • Involved in documentation of procedures
  • Expert in UNIX programming. Very good at shell scripting
  • I worked on multiple physical machines such as massive parallel processing(MPP) configuration I that scenario we used physical partitions.
  • Worked on table partitioning, Data partitioning(DPF), DB2 Data Warehouse, DPF Tables, & Optimum Performance Manager
  • Worked on replication between the DB2 DBA and oracle by using CDC technology
  • Provided Assistance for database developers in tuning Complex SQL using DB2EXPLN and DB2ADVIS
  • Experience in Application life cycle DB2 support
  • Also have knowledge about GPFS, data domain, snapshots and Perl
  • Implemented Database Partitioning, Table Partitioning and Archival logging in DB2 UDB
  • Experience in implementing Backup and Recovery Strategies with Tivoli Storage Manager (TSM)
  • Experience in SQL knowledge and optimization
  • Good team player having good Communication and excellent Inter-personal skills and being able to work independently with minimal or no guidance
  • Open to training, accepts challenges in new areas, dedicated for excellent Performance, proven track records
  • Experience in physical database design and also tuning the database
  • Worked on a very large database environments and also on physical database support
  • Experience in database modeling, Data Management Policies & Procedures

TECHNICAL SKILLS:

RDBMS: DB2 LUW V11.1, V10.5, V10.1, SQL Server, Oracle, MS Access.

Database Tools: DB2 Connect, IBM Data Server client, TOAD for DB2 (Dell/Quest), Foglight Performance Analysis, Spotlight, SQL Optimizer (Dell/Quest) IBM Data studio, ERStudio, Quest Tools, db2top, db2fodc, db2dart, db2mon, db2pd, db2expln, db2exfmt, db2trc, db2mtrk, db2diag, nmon analyzer, svmon, VERITAS NetBackup, BMC Patrol, Erwin, Power Designer, DB Artisan, TSM and VERITAS, XManager

Operating System: AIX 6.1/5.3/5.x/4.3.x, Solaris 8/9/10, RH Linux Advanced Server 2.1, 3.0, Windows 2000/ NT 4.0, Windows 95

Programming and Scripting Languages: Shell Scripting, Perl Scripting, AWK, SED, SQL, Visual Basic, C, C+

ETL and Other Software: Data Staging, Informatica V8.1/7.1, Abinitio 2.15/2.14, Data mirror Transformation Server, QMF

PROFESSIONAL EXPERIENCE:

Confidential, Chandler, AZ

DB2 UDB DBA

Responsibilities:

  • Primarily involved in providing production support of DB2 UDB databases on AIX and Linux servers
  • Performance DBA for NON-DPF and DPF databases
  • Created and maintained instances and databases in development, test and production environments
  • Migrating instances and database servers from V10.5 to V11.1
  • Created multiple buffer pools for optimal performance and allocation of resources
  • Implemented automated backups, Space monitoring, moving db2diag.logs, monitoring size of table spaces by setting up a threshold
  • Running the REORGCHK, REORG and RUNSTATS utilities to reduce disk fragmentation and improve performance
  • Worked on apply and implement of the DATA DISTRIBUTION STRATEGIES
  • Experience in data processing and data modeling
  • Worked on performance tuning and measurements
  • Knowledge on data management software selction
  • Setting up CDC Replication between DB2 UDB on AIX and DB2 UDB on LINUX
  • Setting up an HA or Active-Active solution with IIDR's CDC technology
  • Involved in building databases on fail over servers using redirected restore
  • Applying Fixpaks to keep DB2 at the most current level
  • Setting up High Availability Disaster Recovery (HADR) and involved in testing fail over scenario
  • Involved in Importing and Exporting data and database structure using db2look and db2move utilities
  • Opened several SEV1 PMRs with IBM to troubleshoot and resolve critical issues
  • Monitored database performance and work with senior peers to determine corrective actions
  • Granted various authorizations to different users and groups
  • Worked with different GUI tools like db2mon.control center, command center, replication center, and client configuration assistant tools
  • Worked on IBM DB2 utilities like Runstats, Reorgchk and Reorg
  • Involved in Performance tuning & Query optimization
  • Performed high-speed bulk data loads using DB2 load utility
  • Interacted with the customers and gathered the requirements and analyzed the data for the application
  • Provided 24x7 On Call Production Support

Environment: DB2 ESE 11.1/10.5/10.1 , DB2 UDB DPF 9.5/9.1, SAN Media Server, HADR, TSAMP, Websphere Federation Server V9.5, DB2 Connect, BMC Patrol, NAS, Informatica.

Confidential, Cedar rapids, IA

DB2 UDB DBA

Responsibilities:

  • Primarily involved in providing production support of DB2 UDB databases on AIX and Linux servers
  • Created and maintained instances and databases in development, test and production environments and provided support to System Administration (SA)
  • Implemented automated backups, Space monitoring, moving db2diag.logs, monitoring size of table spaces by setting up a threshold
  • Migrating databases db2 v8.2 to db2 V9.5 versions on AIX servers
  • Database backup & recovery experience with offline, online full & incremental backups and restores & roll-forward including redirected restores
  • Performing database security audit reviews by using db2cops and db2shc tools and removing all the violations
  • Monitored Data propagators capture and apply jobs
  • Involved in building databases on fail over servers using redirected restore
  • Database design, implementation, maintenance, tuning and security for all DHS state wide NON-DPF and DPF databases
  • Involved in Importing and Exporting data and database structure using db2look and db2move utilities
  • Cataloging databases on client systems for accessing remote server databases
  • Monitored database performance and work with senior peers to determine corrective actions.
  • Granted various authorizations to different users and groups
  • Configuring and Monitoring the HADR setup on the database servers
  • Maintained data using IBM DB2 utilities like Runstats, Reorgchk and Reorg.
  • Involved in Performance tuning & Query optimization
  • Performed high-speed bulk data loads using DB2 load utility
  • Interacted with the customers and gathered the requirements and analyzed the data for the application
  • Provided 24x7 On Call Production Support

Environment: DB2 EE/EEE V 9.5, 8.x, 7.x, Web sphere, Solaris, AIX 5.3, Informatica Power Center, SAN, Clustered Environment, Information Integrator V8, Quest Central and HADR

Confidential

DB2 UDB DBA

Responsibilities:

  • Installed third party applications software
  • Created physical and logical disk layout
  • Installed, configured and administered TSM on AIX and Windows
  • Implemented DB2 Fixpaks and performed migrations, client installations and upgrades
  • Installed configure and administered DB2 Patrol across two hundred servers
  • Responsible for performance tuning of SQL and DB2 systems
  • Designed DPF Warehouse databases
  • Lead point of contact in converting DB2 Disks backups to TSM
  • Performed high-speed bulk data loads using DB2 load utility
  • Worked on end-to-end storage stack, including host servers and the software defined storage product
  • Experience in-depth analysis of storage product field issues having data unavailability and/or data loss
  • Creating event monitors for monitoring deadlocks and analyzing outputs
  • Worked on projects that include development, testing and support of data storage technology products
  • Worked on export, import, load and db2look utilities
  • Worked on quality improvement by identifying flaws in support procedures, patterns in the sequence of events leading to a product defect, and break in functionality between releases. Took corrective steps which involve fix identification and recommending proactive replacement

Environment: DB2 EE/EEE V 9.x, 8.x, 7.x, Web sphere, Solaris, AIX 5.3, Informatica Power Center, SAN, Clustered Environment, TSM, Information Integrator V8, Quest Central and HADR.

Confidential

DB2 UDB DBA

Responsibilities:

  • Installed third party software
  • Responsible for identifying potential bottlenecks and correct database problems
  • Performance and tuning of DB2 systems and SQL
  • Worked on export, import, load and db2look utilities
  • Performed Reorg, Run stats when necessary to eliminate defragmentation
  • Monitoring and solving temp space issues
  • Setup the disaster recovery for DB2
  • Worked on DB2 Data Warehouse
  • Provide troubleshooting and problem solving on critical issues Worked on end-to-end storage stack, including host servers and the software defined storage product
  • Experience in-depth analysis of storage product field issues having data unavailability and/or data loss

Environment: DB2 UDB EE/EEE 8.2 Fixpak 4(V8.1 Fixpak 11), AIX 4.3, Solaris, Windows Clustered Server 5.0, Dprop, TSM, RHEL 5.

Hire Now