Role: DB2 DBA withMainframe
Location : Cary orCharlotte NC(Onsite)
Tasks and Responsibilities
* Handling the task of managing databasestructure storage allocation database access roles users andprivileges on Production and NonProduction databaseservers.
* Jobs monitoring
* Space monitoring
* Db2checkouts
* UTS conversion for dev
* UT conversion for prod
* Create db2objects as per request
* Working on DRDArequests
* Fixing database issues
* Create new jobs
* Schedulingjobs
* Checking and Sign off Auditreports
* Capacity planning
* Prepare SQL queries
* Attend meetingsystem and application meetings
* Involvingtoggle migrations
* Working on pre db2migration tasks.
* Handling DB2 version releasefor Production and NonProduction Environment.
* Daily activities include monitoring Databases checkingerror logs checking the log file size and free space in the datadrives checking Index fragmentation and connectivity of thedatabases.
* Create Jobs Alerts and MaintenancePlans.
* Upgrading/Migration the DB2
* Provide database support such as User permissionmanagement backup/restore activities Index fragmentation statisticsupdates and database performance related issues on clientserverenvironment.
* Creating and Managing clusteredindexes and nonclustered indexes to increase the performance ofdatabase queries.
* Handle space issues onProduction and NonProduction database server.
* Create Knowledge articles to document knownissues.
* Backup Design & Management.Performance tuning on Database/System. Patch/upgrade Management forDatabase on Server.
* Day to DayTroubleshooting with Application. Space/deviceManagement.
* Configuring and ManagingProduction as well as Test database. Creating newdatabases.