DB2 DBA

Tasks and Responsibilities Handling the task of managing database structure, storage allocation, database access, roles, users and privileges on Production and Non-Production database servers. Jobs monitoring Space monitoring Db2 checkouts UTS conversion for dev UT conversion for prod Create db2 objects as per request Working on DRDA requests Fixing database issues Create new jobs Scheduling jobs Checking and Sign off Audit reports Capacity planning Prepare SQL queries Attend meeting system and application meetings Involving toggle migrations Working 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 DB2 Provide 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.