- Backup and recovery processes and tools
- Troubleshoot 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.
- Off Hours Support as required.
- Participate in Oncall Schedule.
Required Qualifications
- Minimum of 10 years of related experience
- Bachelor s degree required and/or equivalent work experience
- Knowledge of z/os DB2, and IMS platforms
- Database knowledge (logical and physical design)
- Ability to perform and lead complex projects
- Knowledge of Parallel Sysplex emphasized and WLM - Work Load Manager
Other Qualifications
- Ability to perform skill set of a Mainframe System Programmer
- Working in a collaborative multi client Setting.
- Knowledge of Cobol Programming.
- Knowledge of Database Third party Software tools is a plus, (Omegamon, Tmon, BMC Suite, CA DB2 Toolset) is a Plus
- Ability to mentor and show leadership qualities
📌 Senior Mainframe Systems Programmer (Pune)
🏢 Ensono
📍 Pune