db2 dba
Published date: 2024/01/10
- Location: Chennai, Tamil Nadu, India
• Should have experience of DB2 Installation, Configuration.
• Should have experience with various types of DB2 Backups & Restoration. Restoration using redirect.
• Candidate should have good understanding of Database archival, Database upgrade techniques.
• Ability to craft and alter of DB2 object according to requirement (Ex: Database, Table space, Table, Index, etc.).
• Demonstrable experience with DB2 common command (familiar with other command), Stop/Start Databases, Display command, cancel thread and term utility.
• Good Knowledge/Experience of Reorg/Runstats, Export /Import/Load, query optimization.
• Ability to provide Grants to users for appropriate groups/authorities, familiar with DB2 privileges.
• Have good understanding of Database partition feature, HADR.
• Troubleshooting General DB issues and performance issues. Working knowledge of SQL, knows to use query to check catalog table and find necessary for system usage.
• Experience in using utilities such as db2top db2pd, db2move, db2look, db2expln and db2advis.
• Experience in supporting, maintenance and monitoring of DB2 UDB Databases.
• Experience of DMS/SMS Tablespace Management, Active/Archival log management.
• Experience in analyzing db2diag logs, Monitoring of Lock-Waits & Long Running Queries.
• Experience in Shell Scripting
• Should have experience with various types of DB2 Backups & Restoration. Restoration using redirect.
• Candidate should have good understanding of Database archival, Database upgrade techniques.
• Ability to craft and alter of DB2 object according to requirement (Ex: Database, Table space, Table, Index, etc.).
• Demonstrable experience with DB2 common command (familiar with other command), Stop/Start Databases, Display command, cancel thread and term utility.
• Good Knowledge/Experience of Reorg/Runstats, Export /Import/Load, query optimization.
• Ability to provide Grants to users for appropriate groups/authorities, familiar with DB2 privileges.
• Have good understanding of Database partition feature, HADR.
• Troubleshooting General DB issues and performance issues. Working knowledge of SQL, knows to use query to check catalog table and find necessary for system usage.
• Experience in using utilities such as db2top db2pd, db2move, db2look, db2expln and db2advis.
• Experience in supporting, maintenance and monitoring of DB2 UDB Databases.
• Experience of DMS/SMS Tablespace Management, Active/Archival log management.
• Experience in analyzing db2diag logs, Monitoring of Lock-Waits & Long Running Queries.
• Experience in Shell Scripting
0 page views
Related listings
-
SERVER STORAGE & CLOUD EXPERTDatabase AdministratorSkillset • Server Design, Implementation, Installation, Configuration • Strong understanding and experience of Design & Implementation with enterprise hardware platforms (HP/Dell/Cisco blades/Racks etc.) and operating systems (VMware/Windows/Linu...2026/11/09
-
Performance Database Administrator CoimbatoreDatabase AdministratorWe are looking for self-motivated, great team-player and passionate Performance DBA to support production AWS PostgreSQL databases. Responsibilities And Tasks • Maintain database performance, stability and scalability, and data integrity. • Performan...2026/11/09
-
Hiring SQL Database AdministratorDatabase AdministratorSQL DBA • Pune/Bangalore/Chennai/Gurgaon – 5+ years Job Link :: About the team This role is a part of our Remote Infrastructure Management Team. Review, analyze, develop, install, modify, maintain and/or support major subsystem software components in...2026/11/09