DB2 DBA on AIX/ Unix , PAN India

• Daily management, maintenance, monitoring, tuning and support for DB2 v11.0 and V11.5 databases in UNIX environment (RHEL 5.0 to RHEL 7.2)
• Perform database software installations including database creation, configuration and applying fix packs and migration of databases as per the Patch Applicability Matrix
• 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.
• Installation and configuration of HADR/HACMP on standalone, DB2 pureScale and DPF DB2 servers and performing failover on yearly basis
• Provide on-call support in adherence to specific business and customer Service Level Agreements
• Installation and configuration of DB2 Database servers for standalone in 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
• Interact with the System Administrator for database issues including capacity planning, such as installation and configuration of new disks on Unix Systems
• Daily activities include removing deadlocks, transaction log resolution, bottle necks, dropping & recreating staging tables, optimizing complex queries using explain/db2exfmt

logs/Locking/WLM/Health Check/Audit log /High water mark/Diagnostic log/Transaction log/Migration from 9.7 to 10.5.x/11.x. through script