DB2 DBA - Cary or Charlotte, NC (ONSITE)

Hi,

Hope you are doing great!

My Name is Nisha Bisht from Amaze Systems Inc, and I am trying to reach you regarding a position.

If you are interested and available for this role, please share your resume.

Title : DB2 DBA

Location : Cary or Charlotte, NC(Onsite)

Job Type : Contract

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.

Nisha Bisht | Lead Recruiter
Amaze Systems Inc

USA: 8951 Cypress Waters Blvd, Suite 160, Dallas, TX 75019

Canada: 55 York Street, Suite 401, Toronto, ON M5J 1R7

E: nisha.b@amaze-systems.com | www.amaze-systems.com/

Amaze Systems is an Equal Opportunity Employer (EOE), and does not discriminate based on age, gender, religion, disability, marital status, race and also adheres to laws relating to non-discrimination on the basis of national origin and citizenship status.