Description :

Job Overview :

Experienced DB2 Database Administrator with strong expertise in DB2 architecture, performance tuning, backup/restore operations, HADR, replication setups, and end-to-end database maintenance.

Skilled in ensuring database availability, stability, and security while supporting application teams with object creation, query optimization, and proactive monitoring.

Location : Noida

Work Arrangement : On-site (Monday- Saturday) 9AM - 6PM IST

Job Description : DB2 Admin

Key Responsibilities :

- Candidate should have minimum of 4 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, operating system logs read-write failures), database changes, background job status, operating system logs

- Set up and implement database reorganizations

- Test and implement patches and upgrades

- Implement and manage security rules and access authority as per security policy

- Assist in RDBMS specific command selection (e.g., SQL, DL/I) to optimize performance

- Enable Proactive monitoring to ensure Minimal/ Zero system disruptions/performance issues/ outages.

- Incorporate takeaways from major incidents into monitoring to prevent repetitions.

- Perform any other day-to-day administration and support activities