IBM Db2 DBA / Db2 DBA / Db2 Database Administrator

Hello Professionals, I hope you are doing well!

This is RASHEED AKBAR from "Amaze Systems Inc." and I have the following position. Please let me know if you are interested / have anyone. Thanks!

POSITION#: 1030387

Position: IBM Db2 DBA / Db2 DBA / Db2 Database Administrator

No. of Positions: 1
Work Location: Cary, North Carolina / Charlotte, North Carolina (Fully Onsite 5 days/week)

Duration: Long Term Contract

Client / Implementer: HCL

Required Skills: Upgrading/Migration the DB2, database support such as User permission management, backup/restore activities, Index fragmentation, statistics updates and database performance related issues on client-server environment etc.

Job Description:

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