Skip to main content

DB2 LUW and z/OS Team Resume

RDX’s DB2 team has been supporting dozens of DB2 systems for over 20 years. This extensive experience allows you to fully leverage all of DB2’s advanced features and reduce administration support costs. RDX’s DB2 team is broken down into mainframe and LUW support units allowing us to dedicate experts to each product. This specialization allows you to benefit from best-of-breed services for both the z/OS and LUW DB2 product sets.

Summary of Qualifications:

  • 24 x 7 Database Support Experience
  • 75+ Years of DB2 Experience
  • Average 25 Years of Experience as DB2 DBAs
  • Support Dozens of RDX Clients
  • Manage 1000s of Databases Daily
  • Support Over 500 Servers
  • Performed 100s of Database Recoveries
  • Support Over 50 High-Availability Environments
  • Performed 100s of Database Upgrades

Experience in supporting over 100 different DB2 and third-party applications. Specializes in DB2 database administration on all DB2 releases from Version 7 to Version 9 running on Mainframe, Linux, AIX, and Microsoft Windows operating systems. In-depth expertise in advanced DB2 features, including all high availability options, data warehousing, partitioning, parallelism and advanced security. Dozens of years of experience in all key database disciplines including database administration, database and SQL tuning, monitoring, database availability, disaster recovery, database security and auditing. Extensive experience in new product evaluation and implementation.

Basic Administration Skills:

  • Online, Offline REORG and Usage of Utilities – Statistic, REORG Checks, Integrity Checks
  • Snapshot Analysis – Performance, Locks, Applications, Space, SQL, Temp Space and Connectivity
  • Configuration and DB2 Connect Support – Nodes and DB Configuration
  • Import, Export, Load Data and Usage of DB2PD, DB2LOOK and DB2MOVE Migration
  • Logs and Archive Logs Management
  • AIX Monitoring Tools – Usage of DB2TOP, Topas, VMSTAT,SAR, PS Commands
  • Resolve Errors and Problems
  • Managing Objects, Security, Privileges and Profiles
  • User Administration and Audit Support
  • Incident / Problem & Change Management
  • Install/Fix Pack New Versions V9/1, V9.5, V9.7 – Including SAP Environments
  • Plans, Package and Security Administration
  • Monitoring Daily Jobs & Taking Corrective Action

High Availability Skills:

  • Experience in HADR
  • Backup and Recovery
  • DR Design
  • DR Test Plan Creation and Execution

Strategic Skills:

  • HA System Design, Implementation, Administration and Monitoring
  • SQL and Info Sphere CDC Replication
  • Data Load, Data Refresh and Roll Forward Data on Large Scale
  • Performance, Tuning, Configuration and Snapshot Analysis

Basic Administration Skills:

  • Database Objects Management
  • DB2 PLANS PACKAGES – Access Path Analysis
  • Resolve Security Issues
  • Online and Batch REORG
  • Specialist – Design Backup, Recovery, Rebuild Index and Statistics Updates
  • DB2 Utilities – Check Data, Report recovery, Repair, Mod Recovery
  • Coordinate and Resolve IBM PMRs
  • Monitoring Space, Logs, CPU, SQL, Buffer Hits, DB2 Connect, OMEGAMON
  • Management Reports Preparation – Space, Buffer Hit Ratio, Replicator Delay
  • Space Monitor DASD Tool for Maintaining and Monitoring DASD Volumes z/OS
  • BMC Tools – Change Manager z/OS
  • Strong Working Knowledge of CA Management Suite for z/OS

High Availability Skills:

  • Performed Disaster Recovery Testing
  • Data Refresh at Subsystem Level Using IBM Utilities and Replication Tools
  • Fallback Application Databases

Strategic Skills:

  • Perform Database Performance Tuning - Explain Analysis, SQLPA, OMEGAMON DB2
  • Specialist - Data Warehousing Replication From z/OS DB2 to AIX DB2 Environment
  • Install and Maintain - Info Sphere CDC Software – Data Mirror / IBM UDBDB2
  • Install/Upgrade Info Sphere CDC Real Time Replication
  • Tool z/OS DB2 to AIX DB2
  • Creation of Instance and Subscriptions
  • Usage of Insert Update Delete Flip Logic
  • Usage of Journal Control Fields
  • Setting and Mapping Tables
  • Handle Bi-Directional Replication
  • System Parameter and Notification/Alerts
  • Create Delay Monitor Scripts
  • Usage of Online Scripts for Replication Status
  • Access Server and Management Console Usage – Windows and AIX
  • Export and Import Projects
  • Bit Conversion for Instances

Technical Skills

DB2 Versions DB2 Database Administration for Versions 10.5 and Earlier
Operating Systems z/OS, Sun, Sun Solaris x86 32 Bit and 64 Bit, IBM AIX, IBM Linux, Linux x86, Linux x86 64 bit, Linux Itanium, Windows, Windows 32 Bit and 64 Bit
Database Features Fail Safe, Real Application Clusters, Active Data Guard, Partitioning, ETL, OLAP, Advanced Security, DB2 Secure Backup, DB2 Clusterware, Automatic Workload Management, Data Encryption Toolkit, Memory
Management, Storage Management, Advanced
Tools DB2 Administration Tool, DB2 Bind Manager, DB2 High Performance Unload, DB2 Path Checker, DB2 Query Monitor, DB2 SQL Performance Analyzer, DB2 Table Editor, DB2 Object Comparison Tool, DB2 Storage Management Utility, DB2 Buffer Pool Analyzer, Optim pureQuery Runtime for z/OS, Optim Query Tuner for DB2 z/OS, DB2 Change Accumulation Tool, DB2 Log Analysis Tool, DB2 Cloning Tool, InfoSphere Optim Test Data Management Solution, InfoSphere Replication Server, DB2 Recovery Expert, DB2 Utilities Suite, Tivoli OMEGAMON XE for DB2 Performance Expert on z/OS, DB2 Utilities Suite
close button