DB2 DBA with Mainframe || Cary or Charlotte, NC(Onsite) at Cary, North Carolina, USA |
Email: [email protected] |
From: Meenu Singh, Samson Software [email protected] Reply to: [email protected] Hi, Hope you are doing great! Role: DB2 DBA with Mainframe Location : Cary or Charlotte, NC(Onsite) 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. Thanks & Regards Meenu Singh Sr.Technical recruiter [email protected] Keywords: North Carolina Utah DB2 DBA with Mainframe || Cary or Charlotte, NC(Onsite) [email protected] |
[email protected] View all |
Fri Apr 26 01:21:00 UTC 2024 |