DB2 DBA

Database AdministratorHandling the task of managing database structure, storage allocation, database access, roles, users and privileges on Production and Non-Production database servers.Jobs monitoringSpace monitoringDb2 checkoutsUTS conversion for devUT conversion for prodCreate db2 objects as per requestWorking on DRDA requestsFixing database issuesCreate new jobsScheduling jobsChecking and Sign off Audit reportsCapacity planningPrepare SQL queriesAttend meeting system and application meetingsInvolving toggle migrationsWorking on pre db2 migration tasks.Handling DB2 version release for Production and Non-Production Environment.Daily activities include monitoring Databases, checking error logs, checking the log file size and free space in the data drives, checking Index fragmentation and connectivity of the databases.Create Jobs, Alerts and Maintenance Plans.Upgrading/Migration the DB2Provide database support such as User permission management, backup/restore activities, Index fragmentation, statistics updates and database performance related issues on client-server environment.Creating and Managing clustered indexes and non-clustered indexes to increase the performance of database queries.Handle space issues on Production and Non-Production database server.Create Knowledge articles to document known issues.Backup Design & Management. Performance tuning on Database/System. Patch/upgrade Management for Database on Server.Day to Day Troubleshooting with Application. Space/device Management.Configuring and Managing Production as well as Test database. Creating new databases.