Need DB2 DBA with Mainframe
Posted on :
27-04-2024
Employer Active
The job posting is outdated and position may be filled
Job Alert
You will be updated with latest job alerts via emailValid email field required
Send jobs
Share
Send me jobs like this
Job Alert
You will be updated with latest job alerts via emailValid email field required
Send jobs
Job Description
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 NonProduction 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 NonProduction 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 clientserver environment.
- Creating and Managing clustered indexes and nonclustered indexes to increase the performance of database queries.
- Handle space issues on Production and NonProduction 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.
Employment Type
Full Time
Key Skills
Report This Job
Disclaimer: Drjobpro.com is only a platform that connects job seekers and employers. Applicants are advised to conduct their own independent research into the credentials of the prospective employer.We always make certain that our clients do not endorse any request for money payments, thus we advise against sharing any personal or bank-related information with any third party. If you suspect fraud or malpractice, please contact us via contact us page.
