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