Mainframe DB2 System Programmer

6+ years of experience as mainframe DB2 System Programmer

Skills involves and not limited to, o Evaluate and implement new features/functions of DB2 and associated third party products. o Extensive use of utilities and Performance Monitoring tools using BMC, CA and IBM products. o Consultant on DB2 database applications architecture o Knowledge of SMP/E and can prepare for and apply maintenance to a DB2 subsystem o Engineer and execute the processes to upgrade and/or apply maintenance to releases / versions of mainframe database system software, and associated third party products o Maintain DSNZPARMs o Implement automated disaster recovery mechanisms for Mainframe Database subsystems and associated third party products. Participate in all recovery coordination activities o Create & modify WLM address spaces for stored procedures as needed o Database security management o Backup/Recovery strategies o Strategy Reviews o Scalability Analysis o Database Architecture design strategy o Planning Database maintenance window o Capacity planning o Monitor and troubleshoot DB2 address spaces for any potential issues o DB2 Database configuration across difference Mainframe LPARs