DB2 z/OS Mainframe Job DescriptionWe are seeking an experienced DBA to maintain and support our DB2 z/OS Mainframe database. Key responsibilities include:1. Data Maintenance:- Create new tables/indexes in the Development environment.- Add/modify columns in Development environment tables.- Create/modify indexes in the Development environment.- Transfer structural changes to user test, pre-production and production environments.1. User Support:- Collaborate on table and index design.- Manage locks on DB2 tables.- Configure ASUTIME for expensive queries.- Investigate maximum locked page issues (Reason code: 00C90069).- Analyze DB2 statement audits.- Automatically update data in DB2 every 30 minutes.- Schedule massive UPDATEs/DELETES/INSERTs, locking tables as needed.- Manage RACF users.- Autorize users to read views in Production environment.- Resolve SQLCODE=-805 errors due to version mismatches.- Refresh Stored Procedures.- Review and modify VALIDPROCs in Assembler language.- Recover tables from previous day copies.- Fix query errors.- Collaborate on complex query development.- Generate reports for managers.1. Management:- Recover tables from previous day copies.- Modify tables for replication to Kafka/PostgreSQL.- Monitor with Mainview for DB2 and Apptune.- Rerun CONTROL-M processes after error resolution.- Review Automatic Administration executed over last weekend.- Apply Maintenance and version updates to DB2, QMF, and BMC Products.