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 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
Ability to mentor and show leadership qualities
Job Classification
Industry: IT Services & Consulting Functional Area / Department: Engineering - Software & QA Role Category: DBA / Data warehousing Role: Database Administrator Employement Type: Full time