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