We provide IT Staff Augmentation Services!

Sr.db2 Dba Resume

5.00/5 (Submit Your Rating)

Columbia, MO

SUMMARY:

  • Confidential has over 23 years of DB2/UDB DBA (Database Administration) experience on RS/6000 and Confidential Mainframe environments under large scale Confidential /MVS Mainframe computers.
  • Installation, Creation and maintenance of DB2 objects, DB2 V9.7&V10.5, V11.1,DB2 CONNECT V10.1, HADR, HACMP, SAP BASIS, AIX/UNIX/Linux, Windows NT, Sun Unix, Korn Shell, MVS/OS390 and z/OS, DB2 UDB LUW V9.7, Data Prop and Q Replication, ORACLE and Databases administration.
  • Experienced in SQL Analysis, Logical and Physical Data Modeling for relational databases, DB2 UDB Database implementation and configuration, DB Admin and Maintenance Plans (including backup/restore using TSM, disaster recovery) interacting with developers and utilizing CASE tools like Accelerator.
  • Experienced in providing DBA support for Confidential DB2 V10 on z/OS and DB2 UDB V10.5 LUW on AIX and Confidential DB2 DWE platforms. Experience also includes designing, implementing, maintaining and supporting large DB2 databases of 60 TB size in a data warehouse environment and re - engineering in many different shops, instance and database creation and configuration in non-partitioned (EE) and partitioned (EEE/ESE) database server including multiple logical (MLP) and multiple physical partition (MPP) configurations.
  • Experienced with DB archiving and Disaster Recovery Techniques using Confidential ’s, Data Propagation and Data Replication using Confidential UDB V9.7 DPROP tool, Data Joiner, and Network data mover,
  • Experienced in using BMC Patrol knowledge module for DB2 UDB V9.7 DWE and DB2 system performance monitoring tools to define DB2 UDB system alarms to predict and prevent systems failures.

EXPERIENCE:

Confidential, Columbia, MO

Sr.DB2 DBA

Responsibilities:

  • Provided DB2 DBA support for databases on DB2 UDB DBA V10.1, V10.5 and V11.1 (Linux on series) UNIX/AIX platforms.
  • Performance tuning of DB2 UDB V10.1 Production databases and tuning of SQL queries. This is an on-going process.
  • Experienced in Migration of DB2 UDB V9.7 to DB2 UDB V10.1, V10.5 and V11.1 on UNIX/AIX and Linux platforms.
  • Installation of DB2 UDB V10.5 and V11.1 and Upgrade Fix packs on LINUX/UNIX/AIX platforms.
  • Install and configure DB2 CONNECT V10.1 Personal Edition on WINDOWS, UNIX/AIX platforms for host connectivity (DRDA) via MS SNA Server and TCP/IP protocols to DB2 for OS/390 and z/OS.
  • Experienced in resolving Locking issues within the application and tuning of DBM and DB configuration parameters. Monitored the Tablespace utilization and AIX disk space.
  • Monitored DB2 UDB Databases using snapshot monitoring and Event Monitoring.
  • Experienced in UNIX/AIX programming and very good at shell scripting.
  • Participated in disaster recovery and planning.

We'd love your feedback!