Apply for this Job
- Perform DB2 upgrades, migrate from older version to newer version DB2, reviewing the enhancements and activating the function level, make online and offline system parameter (DSNZPARMs) changes.
- Should have good knowledge on SMP/E RSU maintenance process (Receive/Apply/Accept/Restore), applying maintenance through SMP/E
- Installation and management of DB2 and associated third party products.
- Configure and manage DB2 in a parallel sysplex environment.
- Develop innovation, strategies, processes and best practices in software management.
- Creating Database objects, Tablespaces, Tables, Views, Indexes etc.
- Coordinating with application team for design related issues, object changes.
- Experience with DR (Disaster Recovery), adhere to process and security compliance
- Experience in Online utility: Running Reorgs, unload, load and Runstats, Backup and Recovery of Table spaces (copy & recover), Repair, Load/Unload utilities and troubleshooting restricted object to RW.
- Ensure integrity, availability and performance of DB2 database systems by providing technical support and Maintenance.
- Ability to craft and alter of DB2 object according to custom's requirement (Ex: Database, Table space, Table, Index, etc.)
- Generate reports for performance analysis when required, run explain for the queries identified and review the results, perform SQL tuning if required.
- In-depth knowledge on monitoring the application threads, tuning the SQL queries, making modifications to the query for better performance.
- Installing third party tools in DB2. Applying maintenance and providing support for those tools.
- Troubleshoot and solving production database issue.
- Good hands-on experience with DB2 command interface (familiar with other command), Stop/Start Databases, display command, cancel thread and term utility
- Proficient in Stand-alone utilities: DSNJU003 and DSNJU004, DSNJ003 to change DB2 BSDS, DSNJU004 to print BSDS. Trained with DSN1COPY.
- Ability to provide Grants to users for appropriate groups/authorities, familiar with DB2 privileges.
- Working knowledge of SQL, knows to use query to check catalog table and find necessary details for system usage
- Experience with replication from Mainframe to other RDBMS is a plus.
- Experience on tools like Log analyzer, BMC Apptune, Catalog/Change manager, BMC utiities, CA sysview for DB2, QMF , Omegamon is an advantage.
Date Posted: 07 April 2025
Apply for this Job