We provide IT Staff Augmentation Services!

Oracle Dba Resume

SUMMARY:

  • Have 22 years experience on IT fields, including 8 years as DB2 DBA in development and production environment
  • Handle efficiently and carefully maintenance activities (backup/recovery, performance
  • Monitoring, tuning, Reorganize, Monitoring storage space, database, Allocation and (Grant/Revoke authority) Related to DB2 Database
  • Administration of banking computer systems with large size Data
  • Proficient in daily support activities which include maintaining and testing backups, monitoring logs, monitoring thread activity, resolving job abend issues, locking issues and contentions, scheduling administration activities
  • Experienced in working with large table spaces, processing and maintenance of partitioned table spaces, NPIs and DPSIs
  • Applying new features added in DB2 versions to improve maintenance Speed, performance and resource availability for application
  • Using parallel Unload, Load, Rebuild index, Confidential and also Rebalance, add, drop or rotate partitions
  • Give consultant to application developer for physical designing and Implementing Database objects and checking to achieve best performance
  • Facilitate application development and client problem resolution with optimum speed and efficiency performance
  • Providing DB2 administration operations and tuning performance with DB2 ADB tool
  • Providing migration from Oracle to DB2 via IBM tool kit by using ODBC connection, extraction all objects from ORACLE Database (source Database) to converting to same DB2 Database (Target Database) objects
  • Using DB2 Connect and DBArtisan to unload/load Data between ORACLE and DB2 Database
  • Strong working knowledge of the mainframe environment, including proficiency and skill in z/OS, DB2, DB2 ADB tool,TSO/ISPF, JCL, PL/1,COBOL, CICS, VSAM, REXX
  • I have Knowledge of logical Data Modeling and physical Data modeling for designing and creation Database from model with Applying Erwin Data modeling tool
  • Database Administration and Programming experience in Maintenance, production support, development and migration projects.
  • Ability to work independently or as an effective team player

TECHNICAL SKILLS:

Database: DB2V9/ZOS,DB2 UDB, ORACLE/Linux, MYSQL, ADABAS/OS390/ZOS, ACCESS, SQL SERVER

Access method: VSAM

Programming Languages: PL/1, COBOL, SQL,REXX,JCL, NATURAL, PHP, ASP, SHELL SCRIPT in Linux, (VBSCRIPT, JAVASCRIPT, VB6, JAVA, C++, CLIPPER, Assembly

Software, Development Tools and Utilities: DB2 ADB. Unload, Load, Copy, Confidential, Recovery, Rebuild, Modify, Repair, QUIESCE, DSN1COPY,Explain, SPUFI,DB2 COMMAND

Environment: VM/ MVS/ OS390/ Z/OS,TSO, CICS,CEMT,CECI,CEDA, Windows, Linux

PROFESSIONAL EXPERIENCE:

Confidential

ORACLE DBA

Responsibilities:

  • Monitoring, tuning, Reorganize, Monitoring storage space, database, Allocation and (Grant/Revoke authority) Related to DB2 Database
  • Administration of banking computer systems with large size Data
  • Proficient in daily support activities which include maintaining and testing backups, monitoring logs, monitoring thread activity, resolving job abend issues, locking issues and contentions, scheduling administration activities
  • Experienced in working with large table spaces, processing and maintenance of partitioned table spaces, NPIs and DPSIs
  • Applying new features added in DB2 versions to improve maintenance Speed, performance and resource availability for application
  • Using parallel Unload, Load, Rebuild index, Confidential and also Rebalance, add, drop or rotate partitions
  • Give consultant to application developer for physical designing and Implementing Database objects and checking to achieve best performance
  • Facilitate application development and client problem resolution with optimum speed and efficiency performance
  • Providing DB2 administration operations and tuning performance with DB2 ADB tool
  • Providing migration from Oracle to DB2 via IBM tool kit by using ODBC connection, extraction all objects from ORACLE Database (source Database) to converting to same DB2 Database (Target Database) objects
  • Using DB2 Connect and DBArtisan to unload/load Data between ORACLE and DB2 Database

Hire Now