DB2-UDB Administration
Published date: 2024/01/10
- Location: Mumbai, Maharashtra, India
Detailed Job Description
Experience: 5 to 8 Years
• Experience in DB2 UDB 10.5 Fixpack 6 and 10.1,9.7 And MSSQL 2014 and 2016, MongoDB 3.2,3.4,3.6.3 Installations, Configurations and Administration and upgradation
• Having an experience in handling Production databases up to 1TB in production environment. § Efficient Knowledge in maintaining the logs of Offline & Online Backups.
• Experience with Installing Fix packs & Migrating the Databases.
• Proficient in taking database Backups and recovering the database with Timestamps.
• Recovery – Full database recovery and roll forward recovery to end of logs for no transaction loss or to specific point in time recovery. § Experience in Utilities of Dropped Table Recovery, Redirected Restore Operations.
• Expertise in Using Export, Import and Load utilities to export and import the data from and to files.
• DB2 Performance Utilities - REORGCHK, REORG, RUNSTATS.
• Logging Strategy – Configure database logging for performing hot/cold backups.
• Performance Tuning – Buffer pool tuning, database manager, database configuration parameter tuning for optimal functionality.
• SQL Tuning using db2advisor and db2explain tools Facility.
• Troubleshooting Tools – db2diag, db2trace, db2dart, db2support, db2pd.
• Monitoring Tools – Snapshot monitors and Event monitors.
• Database Cloning – Across same platform using Redirected Restore, different platform using db2look and db2move
Experience: 5 to 8 Years
• Experience in DB2 UDB 10.5 Fixpack 6 and 10.1,9.7 And MSSQL 2014 and 2016, MongoDB 3.2,3.4,3.6.3 Installations, Configurations and Administration and upgradation
• Having an experience in handling Production databases up to 1TB in production environment. § Efficient Knowledge in maintaining the logs of Offline & Online Backups.
• Experience with Installing Fix packs & Migrating the Databases.
• Proficient in taking database Backups and recovering the database with Timestamps.
• Recovery – Full database recovery and roll forward recovery to end of logs for no transaction loss or to specific point in time recovery. § Experience in Utilities of Dropped Table Recovery, Redirected Restore Operations.
• Expertise in Using Export, Import and Load utilities to export and import the data from and to files.
• DB2 Performance Utilities - REORGCHK, REORG, RUNSTATS.
• Logging Strategy – Configure database logging for performing hot/cold backups.
• Performance Tuning – Buffer pool tuning, database manager, database configuration parameter tuning for optimal functionality.
• SQL Tuning using db2advisor and db2explain tools Facility.
• Troubleshooting Tools – db2diag, db2trace, db2dart, db2support, db2pd.
• Monitoring Tools – Snapshot monitors and Event monitors.
• Database Cloning – Across same platform using Redirected Restore, different platform using db2look and db2move
0 page views
Related listings
-
Admin Assistant - Vile parle - Mumbai H HR Search India Private MumbaiAdmin ExecutiveWe are one of the leading Manpower Consultants, catering to various industry verticals on a Pan-India scale. We have huge requirements in terms of Junior Level to Top Management positions in various industry segments. Job Profile: - 1. Inward & O...2026/11/09
-
Office Administrator thaAdmin ExecutiveJob Summary We are looking for a reliable Office Administrator.They will undertake administrative tasks, ensuring the rest of the staff has adequate support to work efficiently. The tasks of the office administratorwill include bookkeeping and mentor...2026/11/09
-
Admin Assistant - Vile parle - Mumbai H HR Search India Private MumbaiAdmin ExecutiveWe are one of the leading Manpower Consultants, catering to various industry verticals on a Pan-India scale. We have huge requirements in terms of Junior Level to Top Management positions in various industry segments. Job Profile: - 1. Inward & O...2026/11/09