ZOS DB2 Database Administrator

09 Jun 2024

Vacancy expired!

Outstanding opportunity for a zOS (Mainframe) DB2 Database Administrator with one of most influential enterprise clients. This position will be responsible for day-to-day database administration of existing BNSF's mainframe zOS DB2 databases and will include defining, planning, implementing and supporting physical zOS DB2 databases for the enterprise. Perform an array of standard database administration tasks in DB2 including the conversion from Data Models to physical design and creation. Provide rotating 24x7 on-call support for BNSF’s zOS DB2 environments as necessary Position requires ten (10) or more years’ total experience as a physical DBA in DB2 including extensive knowledge of all aspects of zOS DB2 including monitoring and performance tuning. 5+ years of expertise with BMC’s Database Administration Tools including NGT, DASD Manager, Catalog Manager, Change Manager, Recovery Manager or RMAN a must. 3+ years experience with IBM’s Database Management Utilities Load, Unload, Recover, Rebuild, Reorganization, Stats, Image Copy, DB2 Fast needed. Must possess a strong understanding of SQL and a strong understanding of DB2 PLAN and PACKAGE. Experience with IBM’s zOS utilities JCL, IDCAMS and IEBCOPY required. Must have a strong ability to analyze zOS Syslog and DB2 Master Log information to resolve issues. A strong understanding of DB2 and zOS security is essential. Ability to trace, analyze and resolve database connectivity issues needed. An understanding of REXX, CLIST & JCL needed. Ability to perform database monitoring and performance tuning using BMC’s DB2 Performance Tools including Apptune and MainView highly desired. An understanding of Data Replication and Data Propagation and ability to write DB2 Stored Procedures are strong plusses. Must be a team player willing to be coached on client-specific zOS DB2 processes and procedures. Must be able to explain technical issues to non-technical (management) individuals. Desired skills: DBA, DB2, zOS DB2, Performance Tuning, NGT, DASD Manager, Catalog Manager, Change Manager, Recovery Ma, Load, Unload, Recover, Rebuild, Reorganization, Stats, Image Copy, DB2 Fast, zOS utilities, JCL, IDCAMS, IEBCOPY, REXX, CLIST, JCL, Apptune, MainView, Data Replication, Data Propagation, DB2 Stored Procedures Local candidates preferred

  • ID: #42660586
  • State: Texas Fortworth 76131 Fortworth USA
  • City: Fortworth
  • Salary: USD70 - USD75
  • Job type: Contract
  • Showed: 2022-06-09
  • Deadline: 2022-07-20
  • Category: Et cetera