Mainframe Consultant

OverviewAvanciers is hiring Mainframe IDMS Application DBA at Mississauga, ON, for one of our Fortune 500 clients. This is a Long Term contract role with the client.Job Title: Mainframe IDMS Application DBA/ Mainframe Legacy SystemsDuration: 1 yearKey ResponsibilitiesWe are seeking an experienced Mainframe Database Administrator with strong operational expertise in managing and maintaining legacy database systems, specifically focusing on IDMS. This role is critical for ensuring the performance, integrity, and high availability of production databases through proactive management, capacity planning, and rigorous change control.Core ResponsibilitiesPerform 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 maintenanceMonitor the IDMS instances by checking the databases logs and IDMS file spaces. Report any issues and work on resolutions.Monitor and tune the DBMS.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.Engage in performance and capacity management of the DBMS.Complete the expansion of databases that experience high volumes of updates or have less than 30% free space, to limit database fragmentation and optimize space utilization; Note: change windows for all DBMS changes vary by application and are usually performed outside business hours over the weekend.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.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.Utilize software tools and best practices, and follow Change Management processes as required, Database Management will encompass the following proactive and reactive activities supporting a variety of applications/DBs.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.Performing the following project delivery activities throughout its lifecycle phasesProactively identify database performance issues and provide recommendations and implement solutions for resolution.Support automated procedures to send weekly scheduled emails to Client Application Support primes and the Vendor Database Support Team, identifying the database areas with less than 30% free spaceSeniority levelMid-Senior levelEmployment typeContractJob functionInformation Technology and OtherIndustriesTelecommunicationsReferrals increase your chances of interviewing at Avanciers Inc. by 2xGet notified about new Mainframe Consultant jobs in Mississauga, Ontario, Canada.Additional related rolesDatabase Administrator - Dataverse SpecialistSQL Server Database Administrator SpecialistRQ09857 - Database Administrator - SeniorToronto, Ontario, Canada CA$65.00-CA$70.00 16 hours agoSenior Database Administrator- Ministry ExperienceWe’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI. #J-18808-Ljbffr