Mainframe/DB2 System Support Engineer (8-10 yrs)

Company Description :

Maintec Technologies is a leading provider of mainframe outsourcing, data center management, and IT staffing services in the USA and overseas.

With headquarters and a data center in Raleigh, North Carolina, and an additional data center in Bengaluru, India's "Silicon Valley," Maintec offers innovative solutions to meet the diverse needs of its global clients.

Role Description :

This is a full-time on-site role for a Mainframe DB2 System Support Engineer at Maintec Technologies in Bengaluru.

The role involves day-to-day tasks such as technical support, troubleshooting, system administration, and ensuring network security for mainframe systems running DB2 databases.

Qualifications :

- Environment Subsystem setup, Backup & Recovery and Data Sharing.

- Experience and Expertise in Monoplex, SYSPLEX architecture and data sharing architecture.

- Experience in DB2 subsystem setup both Stand-alone and data sharing.

- Experience and Expertise on tweaking DB2 ZPARMs.

- Good knowledge on DB2 DRDA architecture and Communication database.

- Experience in DB2 backup and recovery scenarios traditional image copy, FLASH, mirroring etc., methodology.

- Experience in REXX/CLIST and ISPF programming skills.

- Good knowledge on transactional environment like CICS, IMS architecture and interface with DB2.

- DB2 Data sharing skills Installation, customization, DB2 structures, CFRM policy, DB2 CF recovery, Data sharing locking mechanism etc.

Software migration/maintenance :

- Experience and good exposure to SMP/E process.

- Experience and Expertise on software migration and maintenance procedures Install,- backout, re-migration process DB2 V9, V10, and V11.

- Experience and good exposure to unsupported, new features in the recent versions of DB2 on z/OS software (V11, V10 etc.,).

- Experience and Expertise on SMP/E basics and debugging.

- Good knowledge on process related to PMR tickets and co-ordination with L2 development support.

- Good Knowledge on DB2 Health check, DB2 security and Patch management.

ISV Products/Tools :

- Good exposure to the Installation and maintenance of IBM tools like OMEGAMON, DB2 Admin, HPU etc.

- CA Suite of tools like RC Migration/update/Query etc., Fast Load/Unload, Insight etc.

- BMC Suite of tools.

- Experience and expertise in IBM utilities like REORG, RUNSTATS, LOAD, UNLOAD etc.

- Experience in IBM tools/products is mandatory.

- Candidate should have good experience in both BMC and CA products or either one is okay.

- Experience in problem debugging and Vendor specific PMR ticketing procedure.

Problem Solving & Performance :

- Good knowledge and experience on DB2 traces, SMF, RMF and WLM.

- Good knowledge and experience on SMF Statistics, accounting and performance reports.

- Good knowledge on Virtual storage tuning like Buffer Pool, EDM Pool and thread storage parameters.

- Good knowledge on SYSPLEX, data sharing and distributed problem-solving skills.

- Expertise on monitoring tools like IBM Omegamon, CA Insight, BMC Mainview etc.

- Good Knowledge on z/OS and DB2 system performance tuning methods.

Additional/Nice to have Skills :

- Experience in DB2 Connect and IBM Data Studio.

- DB2 Cloning process IBM DB2 Cloning Tool or any customized in-house Tools.

- SAP/DB2 architecture knowledge SAP Service marketplace, SAP note reference like 81737 etc.

- SAP/DB2 Maintenance procedure.

- Experience in SAP note, high availability solutions, GUI DB transactions etc.

- PeopleSoft/DB2 architecture.