DB2 DBA
Apply NowCompany: Omni Inclusive
Location: Cary, NC 27513
Description:
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.