Db2 Database Administrator
- Vlink
- 4 - 8 years
- Noida, Gurugram
- 3 months ago
- Email to a friend
- Report this job
Job Description
Project: NTPC
Work Location: Noida
Work Mode: In-Office (Mon-Sat)
Notice Period: Immediate to 30 Days
If you meet the criteria please send your application at um*********n@vl******o.com
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
Job Classification
Industry: IT Services & ConsultingFunctional Area / Department: IT & Information SecurityRole Category: IT Infrastructure ServicesRole: IT Infrastructure Services - OtherEmployement Type: Full timeContact Details:
Company: VlinkLocation(s): Noida, Gurugram+ View Contact
Keyskills: Database Administration RDBMS IBM DB2
Fraud Alert to job seekers!
₹ Not Disclosed
Similar positions
Job Listings
We are in open beta version of website, please let us know if any issues, at: info(at)indigojobs.in