Job Seekers, Please send resumes to resumes@hireitpeople.com

Detailed Job Description:

Mainframe DB2 Database administration activities

Day - to-day tasks of monitoring Batch jobs and taking timely actions to fix Batch support issues Maintenance activities such as REORG, RUNSTATS and other regular DB2 utilities such LOAD, UNLOAD, REPAIR etc.Perform Database Backup and Restore Perform Data refresh of Test database systems from Production database Create and maintain Database objects such as Tables, Indexes, Triggers, etc.Technical proficiency of SPUFI, QMF, OPTIM and nice to have BMC Catalog Manager, Change Manager and Mainview Performance tuning of long running and CPU intensive jobs, SQL queries Perform Database change requests such as running SQL queries, Loading of data, access related requests

Mainframe System admin activities

Technical proficiency of BMC Control-M product Day-to-day activities if monitoring daily Batch jobs, FTP jobs, re-start/re-run of jobs, Scheduling of Jobs Analysis of Jobs related of Mainframe System and fixing them Coordination with other team members for timely resolution Documentation of Resolution of Tickets Provide RACF related access requests Nice to have DASD Storage management activities such as Allocation of DASD Volumes Perform Back up of requested data files

Technical Skills Required:

TSO/ISPF, JCL, VSAM, COBOL, CICS, DB2, SQL DB2 Database Administration DB2 Admin Products viz. IBM or BMC DB2 related tools such as SPUFI,QMF, OPTIM and nice to have BMC admin products such as BMC Catalog manager, Change manager, Mainview BMC Control-M Scheduler/Automation

Basic Qualifications:

5+ years of Application Support-Mainframe-L1 or L2 Support MF System Admin Requirements: z/OS HCD/IOCP, SMP/E, JES2, TSO, SDSF, TCP/IP, VTAM, DFSMS, RMM, RMF/SMFWLM, IPCS, Netview, Unix System Services, RACF, ServerPac z/OS install/upgrade experience DB2/QMF System level support, installation/migration/troubleshooting, (DBA experience a plus) CICS System level support, installation/migration/troubleshooting BMC Control-M Install/upgrade/troubleshooting experience Operation/scheduling/job error resolution experience ISV Software BMC DB2 Software Suite (Catalog Manager, Change Manager, DASD ManagerLoad/Plus, Unload/Plus) BMC Mainview for DB2/CICS Cincon Mantis ASG PRO/JCL Compuware (File/AID, XPEDITER TSO/CICS) Software Engineering of America ($AVRS, TRMS) Micro Focus ChangeMan ZMF/DS