DB2 Professional

• DB2 DBA with exp range 6-10 Years detail JD below:
• 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.
• Designing appropriate Database configuration parameters and tuning buffer pools for better optimised database performance.
• Separating the file systems enforced the UDB database standard practice and it also simplified table space and file system maintenance
• Managing DB2 Security by implementing patch management, password management, license management and GSD across all servers.
• Interact with the System Administrator for database issues including capacity planning, such as installation and configuration of new disks on Unix Systems.
• Responsible for searching various DB2 Fix Packs for v9.7 and v10.5/11.1 and providing assessment about these Fix Packs to the upper management. Accordingly applying various Fix Packs to v9.7 and v10.5/11.1 database servers.
• Performing weekly offline and daily online backups and restore functions using Symantec Net Backup. Redirect restored test databases with production databases. Moved databases from one server to another or from existing file systems to new file systems..
• Daily activities include removing deadlocks, transaction log resolution, bottle necks, dropping & re creating staging tables, optimizing complex queries using explain/db2exfmt.
• Deployed various scripts on production servers- Backup/Runstats/Log collection/Archive
• logs/Locking/WLM/Health Check/Audit logHigh water mark/Diagnostic log/Transaction log/Migration from 9.7 to 10.5.x/11.x. through script.

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