We provide IT Staff Augmentation Services!

Mainframe Database Administrator Resume

0/5 (Submit Your Rating)

SUMMARY:

  • Knowledge acquisition from incumbent on Mainframe service delivery
  • Identify risk during transition, provide mitigation and track till completion
  • Manage escalations and track Service Delivery and ensure SLA compliance including with vendors
  • Review and update the SOP documents on regular basis
  • Support on all in - flight and upcoming project activities
  • Recommend and perform customer-approved database streaming and replication procedures
  • Ensure completion of authorized Service Requests, Changes, Problem tickets
  • Experience with database physical and logical design, query analysis and optimization
  • Define and provide guidance for database creation, configuration, upgrade, patches and refresh requirements
  • Recommend operating system and database performance monitoring, tuning and configuration changes
  • Provide technical assistance and subject matter expertise to applications groups
  • Provide database storage management and capacity management recommendations
  • Define and manage database security and access permissions in consultation with customer
  • 7+ Years of experience in IDMS v17 & v18.5, DB2 v10, VSAM Database Administration on z/OS
  • Experience in IDMS v17 & v18.5 (Primary), DB2 v10, VSAM Database Administration on z/OS
  • IDMS, VSAM, DB2 internals, installation, upgrade, patching, configuration and operations
  • Logical and physical database design skills
  • Experience in SMPE and ISV tools installation and migration
  • Create and maintain database entities, including instances, databases, table spaces and tables
  • Experience in Data Sharing setup in Parallel Sysplex environment
  • Database DR, Cloning, Backup/Recovery, HA and Point In Time Recovery (PITR) expertise
  • Experience with Database ISV Tools and Products like OmegaMon and AdminTool
  • Proficiency in IDMS, DB2, VSAM Systems Performance Tuning and Capacity Planning
  • Application related performance tuning; Write, modify, and debug database specific SQL queries
  • DBA related utilities like Unload, Load, DSNJU003, DSNJU004,Reorg, Runstats, image copy
  • REXX, CLIST, JCL, JES and Assembler knowledge

TECHNICAL SKILLS:

Keywords: IDMS v17 & v18.5, DB2 v10, VSAM Data Sharing, Buffer Pool tuning, PITR

We'd love your feedback!