Database Administrator

About the Company

• Vlink is hiring for DB 2 Admin for Noida Location.

Experience: 5-8 Yr. Location: Noida. Work Mode: Onsite

• 6 days working.

Notice Period: Imm. Joiner. About the Role

• 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. Required SkillsGood knowledge in Db2 architecture

Experience in creating objects like table and index creation requested by the application team

Experience in backup strategies like an online and offline backup

Experience in restore database and apply logs up to point in time

Experience in creating tablespace management like adding and resizing

Experience in data movement utilities

Granting permissions at the user level

Checking DB health check (Monitoring tools) PD, TOPExperience 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

Performing database maintenance

Troubleshooting the database for log files, rollback segments, table-spaces, database descriptors

Creating definitions of logical data structures, tables, views, indexes, program specification blocks, stored procedures and define their relationships

Following naming conventions for database objects

Setting data storage parameters for storage associated with the physical elements of the database

Estimating and recommending storage requirements

Maintaining and monitoring the health and performance of RDBMSAnalyzing 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

Setting up and implementing database reorganizations

Testing and implementing patches and upgrades

Implementing and managing security rules and access authority as per security policy

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

Enabling Proactive monitoring to ensure Minimal/ Zero system disruptions/performance issues/ outages

Incorporating takeaways from major incidents into monitoring to prevent repetitions

Performing any other day-to-day administration and support activities Interested candidate can share their updated profile on below mentioned mail: ***********

Regards As Ever, Ankit Malik