IBM DB2 Admin

Immediate Joiner or 15 Days Notice Period Candidates only !! FOR MORE INFO VISIT OUR WEBSITE- Must have:- Db2 Basic Command HADR Installation, Maintenance & Confirmation IBM db2 LUW Linux/Unix Requirements: • Candidate should have minimum of 5 years of relevant exp and below in DB2 • Having good knowledge in Db2 architecture • having good experience to create objects like table and index creation requested by the application team • Good experience in backup strategies like an online and offline backup. • Good experience in restore database and apply logs up to point in time • Good experience to create tablespace management like adding and resizing.. • Good experience in data movement utilities • Granting permissions at the user level • checking DB health check (Monitoring tools) PD, TOP • Good exp in offline reorg/online reorg • creating an instance and install DB2 products • Having HADR knowledge -working • Performance tuning(time issues) • performing redirect restore between different servers • tuning DBM and DB level configuration parameters • knowledge in replication setups (SQL and Q) primary to standby • how to tune queries- explain (current indexes)/advise plan(indexes) • UPGRADING DB Versions / Rollback plan • Perform database maintenance • Troubleshoot the database for log files, rollback segments, table-spaces, database descriptors. • Create definitions of logical data structures, tables, views, indexes, program specification blocks, stored procedures and define their relationships • Follow naming conventions for database objects • Set data storage parameters for storage associated with the physical elements of the database • Estimate and recommend storage requirements • Maintain and monitor the health and performance of RDBMS • Analyze alerts and logs including trace files (including data block corruptions, Enqueue resources, internal errors, and I/O read-write failures), database changes, background job status,

Apply Now