Db2 Purescale
1 month ago
Shahpur, India
LTIMindtree
Full time
Primary Skills - DB2 purescale,Db2- Luw Db AdministrationExperience - 5 to 7 yearsLocation - DelhiJob Description-Daily management, maintenance, monitoring, tuning and support for DB2 v9.0 and V9.5 databases in UNIX environment (RHEL 5.0 to RHEL 7.2) and windows platforms.-
Perform database software installations including database creation, configuration and applying fix packs and migration of databases as per the Patch Applicability Matrix.-
Performing weekly offline backups and daily online backups to Disks/TSM and tapes using scripts and manual methods.-
Responsible for application SQL Query tuning, database parameter tuning, operating system tuning, memory tuning.-
Database Backup/Recovery on databases and file system backups. Redirect Restore to move application from Development, QA and Production.-
Implementing purging policies over the database servers as per the customer data retention periods.-
Installation and configuration of HADR/HACMP on standalone, DB2 pureScale and DPF DB2 servers and performing failover on yearly basis.-
Efficiently carried out DBA responsibilities in planning DB2 version migration activities, in migration phases and in performing post migration tasks-
Daily and weekly database Maintenance and data movement activities such as backup, reorgchk, reorg, run stats, export, import, load and all related activities for OLAP database.-
Provide on-call support in adherence to specific business and customer Service Level Agreements.-
Managed database instances for Consolidated Online trading system in DB2 UDB in version 9.7/10.1/v10.5/11.1 on AIX 6.1 and Linux (RHEL 7) servers.-
DB2 pureScale Skills .. Backup, restore, and roll forward operations