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 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.

J-18808-Ljbffr