Immediate Joiner or 15 Days Notice Period Candidates only !!
FOR MORE INFO VISIT OUR WEBSITE- https : / / harinexsolutions.com /
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 timeGood experience to create tablespace management like adding and resizing..Good experience in data movement utilitiesGranting permissions at the user levelchecking DB health check (Monitoring tools) PD, TOPGood exp in offline reorg / online reorgcreating an instance and install DB2 productsHaving HADR knowledge -workingPerformance tuning(time issues)performing redirect restore between different serverstuning DBM and DB level configuration parametersknowledge in replication setups (SQL and Q) primary to standbyhow to tune queries- explain (current indexes) / advise plan(indexes)UPGRADING DB Versions / Rollback planPerform database maintenanceTroubleshoot the database for log files, rollback segments, table-spaces, database descriptors.Create definitions of logical data structures, tables, views, indexes, program specificationblocks, stored procedures and define their relationships
Follow naming conventions for database objectsSet data storage parameters for storage associated with the physical elements of the databaseEstimate and recommend storage requirementsMaintain and monitor the health and performance of RDBMSAnalyze alerts and logs including trace files (including data block corruptions, Enqueueresources, internal errors, and I / O read-write failures), database changes, background job status,