Your browser does not support javascript! Please enable it, otherwise web will not work for you.

Db2 Administrator @ Vlink

Home > DBA / Data warehousing

 Db2 Administrator

Job Description

Note: This is a contract position and requires 6 days working from the client location and looking for Immediate joiners.

  • 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 & Consulting
Functional Area / Department: Engineering - Software & QA
Role Category: DBA / Data warehousing
Role: Database Administrator
Employement Type: Contract

Contact Details:

Company: Vlink
Location(s): Noida, Gurugram

+ View Contactajax loader


Keyskills:   Database Administration Access Management Performance Tuning Troubleshooting Backup And Recovery Patch Management & Upgrades Operational Excellence DB2 Architecture Database Security Database Object Design Security & Access Management

 Job seems aged, it may have been expired!
 Fraud Alert to job seekers!

₹ Not Disclosed

Similar positions

Mainframe DB2 DBA

  • Tata Consultancy
  • 7 - 12 years
  • Bengaluru
  • 4 days ago
₹ Not Disclosed

Mainframe DB2 DBA Admin Not Developer

  • Tata Consultancy
  • 7 - 12 years
  • Mumbai
  • 23 days ago
₹ Not Disclosed

Database Administrator

  • Sunquest Information
  • 3 - 7 years
  • Bengaluru
  • 23 days ago
₹ Not Disclosed

Senior Mainframe IMS & Db2 Database Administrator

  • Cirruslabs
  • 6 - 10 years
  • Hyderabad
  • 26 days ago
₹ 9.5-19.5 Lacs P.A.

Vlink

M/s. Vlink India Pvt Ltd For more details visit www.vlinkinfo.com