Mainframe IDMS DBA Requisitos: The responsibilities and deliverables include but not limited to following: - Performing the following project delivery activities throughout its lifecycle phases - Monitor the IDMS instances by checking the databases logs and IDMS file spaces. Report any issues and work on resolutions. - Perform implementation migration activities for Database records and structures such as IDMS Elements/ Records/ Processes/Dialogs/Maps/Subschemas to different databases. - Perform DMPS and IDMS File maintenance - Resolve tickets logged for Database support within any SLAs or standard practices defined by Bell. - Resolve technical queries and database modification requests from Application Programmers. - Attend Project meetings and provide database support related to project activity. - Act as the liaison for contact with the third-party database vendors. - Provide technical database support. - Provide Incident Management support for database issues in response to Incident notifications. - On Call Support and duty manager rotation. - Proactively identify database performance issues and provide recommendations and implement solutions for resolution. - Monitor and tune the DBMS. - Engage in performance and capacity management of the DBMS. - Monitor database storage pools. - Analyze database growth, running/supporting weekly scheduled batch reports on DBMS database areas and monitor database growth from the previous week to help trend and predict growth. - Some Test system changes can be done during business hours with Client approval. - Build and support DB restructure changes as requested by the Client and perform the changes in test and Production during the negotiated change windows. - Support database purges as built by the Client. - Maintain operational procedures for scheduling database areas online/offline/retrieval mode in support of the Client's batch schedules. - Set up and executing backup and recovery procedures associated with expansions and restructures. - Create and maintain database journal backup jobs. - Assist the Client with running recovery batch job streams upon Client request or during the annual DR test. - Maintain DBA DR documentation, procedures, jobs and support the DR test. - Use PMDC to perform IDMS system/DB performance and tuning. - With assistance from IDMS system installers review batch and OPER statistics such as but not limited to Active Tasks, Active Users, DB I/O, Run Units, and LTERM Storage to ensure system resources are healthy. - Database Instance Support - 2 Test and 7 production databases. - Application DBA support to System DBAs. - Support System DBAs for preventative maintenance, patches, upgrades and/or fixes identified by the third-party database vendor. - Note change window for IDMS system work is Sunday morning from 2:30 AM EST to 7:30 AM EST. - The database upgrades to new versions of the database management system (DBMS) to maintain currency.