Datacenter Facility Manager

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