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