The Mainframe Systems Programmer provides support for on-going projects that require the installation, testing, and implementation of new operating systems and other 'system' software. Also, the Maintenance and debugging of systems software. Coordination and the IOGEN work for new MF hardware. Research and evaluation of new software and hardware products, assisting team members and other areas with technical questions and problem resolution. Monitoring and tuning of systems software. Functional knowledge, use of z/OS components and detailed knowledge of support products such as tape management, scheduling, security, monitoring systems, etc.
Backup and recovery processes and tools
Database knowledge (logical and physical design)
Experience with troubleshooting database performance issues and query tuning concepts
Perform data management tasks as required: loading / unloading, updating, restoring and removing data to ensure that database is accurate as a data source.
Perform Database Maintenance activities like Adhoc Reorgs, Runstats etc on demand from the application teams, as well as monitor the scheduled maintenance activities.
Monitor and manage Space: Purge obsolete data and reclaim space
Identify and troubleshoot databases issues with high priority.
Monitor database backups and Database maintenance jobs. Troubleshoot job failures and work with Operations as required.
Monitor the databases for any unusual activities and restrictive states and check the logs periodically for any issues.
Refresh Dev/Test databases with prod backup images as requested.
Working in a collaborative multi client Environment.
Knowledge of Cobol Programming.
Knowledge of Database Third party Software tools is a plus, (Omegamon, Tmon, BMC Suite, CA DB2 Toolset) is a Plus
Off Hours Support as required.
Participate in Oncall Schedule.
Platforms: z/os DB2, IMS
Bonus Platforms: IDMS, Adabase, Supra, System 2000, Datacom