Mainframe IDMS Application DBA

Overview

Remote
Depends on Experience
Accepts corp to corp applications
Contract - W2
Contract - Independent
Contract - 12 Month(s)
Able to Provide Sponsorship

Skills

IDMS
Mainframe
Database
Database Administration
Migration
Change Management
Streaming
Incident Management
Storage
Recovery

Job Details

Mainframe IDMS Application DBA

Remote
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.

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.

Proactively identify database performance issues and provide recommendations and implement solutions for resolution.

Monitor and tune 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.

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 space.

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.

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.