Db2 Administration

Experience Range : 5 to 8 years

Location : Delhi, Noida

Notice Period : Immediate Joinner

Job 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.
• Managed large, mission-critical databases. Interpreted business requirements and recommended solutions.
• Installation and configuration of DB2 Database servers for standalone and DPF environments in Linux and AIX operating systems.
• Performing table space re-balancing for ensuring the equal data distribution across all the data mounts and applying compress methods on tables for storage savings.
• DB2 pureScale Skills .. Backup, restore, and roll forward operations

A) Instance monitoring

B) Database alert management

C) Database storage management

D) Access management

E) Remote installation and configuration of the Db2 pureScale Feature

F) Creation and deletion of computing resources

G) Addition and removal of hosts from the cluster manager and shared file system H) Host system maintenance

I) Topology changes (add or drop members)

J) Topology changes (add or drop CFs)

K) Backup, restore, and rollforward operations within Db2 pureScale Feature