Mainframe Developer

Role : 1- Mainframe IMS DB Tools Remote IBM 1 year *BGV must be fully cleared *Subcontracting permitted by end client Key Skills: • IMS system programming (install, configure, maintain) • IMS in Parallel Sysplex administration • IMS tools expertise – IBM, BMC, Broadcom/CA • z/OS systems programming fundamentals • Tool migration / conversion experience ROLE PROFILE Job Description/ Responsibilities Core Technical Skills: • Install, configure and manage IMS in a parallel sysplex environment • Install, configure and manage IBM IMS Tools • IMS systems programming • Establishing policies and procedures pertaining to database management, DR, security, maintenance and utilization • Reviewing new versions of IMS for functionality, advising how they benefit the client • Evaluating change requests and determine impact to assigned clients • Vendor consultations for problems and questions • DR recovery of application objects • Lead and execute complex migrations to IBM IMS Tools from 3rd party products • Develop a project plan with defined phases (Planning, Conversion, Implementation, Cutover) and timelines, ensuring alignment with client objectives and internal best practices • Conduct customer training sessions and develop presentation materials for IMS Tools and migration processes Database Skills: • Database Administration • Knowledge of IMS database organization using access methods of VSAM and OSAM • Full function database organization types • HSAM, HISAM, SHISAM, HDAM, HIDAM, INDEX, GSAM • Definition and use of LOGICAL databases • HALDB (partitioned): PHDAM, PHIDAM, ILDS, PSINDEX, etc. • Fast Path databases (DEDBs) • Database Design and related utilities • DBD source coding and DBDGEN • PSBGEN source coding and PSBGEN • How databases are processed using secondary indexes (PROCSEQ=) • Correct usage of PROCOPT= to minimize database locking • ACBGEN • Online Change • IMS Catalog and IMS Management of ACBs • Database monitoring • Space management • Database dataset space reporting for proactive outage avoidance. • How to immediately fix an out of space condition for a VSAM database dataset Optional Skills: • BMC IMS Tools experience • Broadcom IMS Tools experience • Z/OS scheduling expertise • IMS DBA experience • Troubleshooting and solving production database issues • Install, configure and manage IMS in a parallel sysplex environment • Install, configure and manage IBM IMS Tools • IMS systems programming • Establishing policies and procedures pertaining to database management, DR, security, maintenance and utilization • DR recovery of application objects • Lead and execute complex migrations to IBM IMS Tools from 3rd party products Role : 2- Mainframe DB2 Tools Specialist Remote IBM 1 year *Subcontracting permitted by end client Key Skills: • Db2 for z/OS system programming • Db2 utilities administration (IBM + Broadcom/CA) • JCL, PROC & control card conversion to IBM utilities • Db2 job delivery, testing & documentation ROLE PROFILE Job Description/ Responsibilities Core Technical Skills: • Install, configure, and manage IBM Db2 for z/OS environments in a Parallel Sysplex architecture. • Install, configure, and administer IBM Db2 Tools and Utility Suites.Strong knowledge of Db2 systems programming, utilities, and database administration. • Establish policies and procedures pertaining to database management, disaster recovery, security, maintenance, and utilization. • Review new IBM Db2 Tool releases and functionality, providing recommendations on adoption and business value. • Evaluate change requests and determine impact to assigned client environments. • Provide vendor consultation and technical guidance for Db2 Tools migration activities. • Lead and execute migrations from Broadcom/CA Db2 Tools to IBM Db2 Tools. • Convert Broadcom/CA Db2 Utility JCL, Procedures, and Control Cards to IBM Db2 Utilities standards. • Develop project plans with defined phases including assessment, conversion, implementation, testing, cutover, and post-migration support. • Validate converted jobs, procedures, and utilities to ensure operational readiness and compliance with IBM standards. Optional Skills: • Broadcom/CA Db2 Tools administration experience. • IBM Db2 Tools implementation and support experience. • z/OS scheduling and automation expertise. • Mainframe systems programming experience. • Db2 DBA experience. • JCL, REXX, ISPF, and utility automation skills. • SMP/E installation and maintenance experience. Database Skills: • Database Administration • Db2 for z/OS subsystem administration and maintenance. • Database, Tablespace, Index, and Catalog management. • Db2 Utility execution, monitoring, and optimization. • Backup, Recovery, and Disaster Recovery procedures. • Database change management and migration processes. • SQL performance analysis and tuning. • Utility scheduling and automation. • Database monitoring and reporting. • Space management and capacity planning. • Package, Plan, and Access Path management. • Performance diagnostics and workload analysis. • Production support and problem determination. IBM DB2 Tool Migration Skills • Conversion of Broadcom/CA Db2 Utility JCL and Control Cards to IBM Db2 Utilities standards. • Delivery and validation of converted Db2 Jobs, Procedures (PROCs), and Control Cards. • Analysis of existing utility execution processes and implementation of IBM best practices. • Development of migration standards, testing strategies, and cutover procedures. • Install, configure, and manage IBM Db2 for z/OS environments in a Parallel Sysplex architecture. • Install, configure, and administer IBM Db2 Tools and Utility Suites. Strong knowledge of Db2 systems programming, utilities, and database administration. • Review new IBM Db2 Tool releases and functionality, providing recommendations on adoption and business value. • Lead and execute migrations from Broadcom/CA Db2 Tools to IBM Db2 Tools. • Convert Broadcom/CA Db2 Utility JCL, Procedures, and Control Cards to IBM Db2 Utilities standards.