Working as an On-Site Teradata Lead DBA, doing DBA activities that are Implementation of data and table-level security, setting up access rights and space rights for Teradata environment. Performance tuning, Monitoring and reporting Review system utilization by user.

Acted as a liaison between the offshore and onsite teams.

Responsibility of production support people?

Monitoring the given scheduling tool

For the fail jobs need to raise defects in defect training tools clear quest, drop a mail to production manager/production head

Production vendor

Production manager

Development Lead/manager

Developer

Note: For seeing the data in flat file Generally we go for ULTER Real time

How do you connect your server and how are you working with your corresponding tools?

StartRunMSTSC[Remote Desktop server]

What type data loading in your project?

There are different load

A)Indirect load

i)Incremental(or)Delta lad

ii)Histronized

B)Direct load

What is Granularity of you project?

We having Granularity, the lowest Granularity is day wist

The level of data loading

Explain semi complex issue in your project?

Having duplicate in the tables(pay using queries we use to resolve it)

Working with error table and exception handling table[identifying the error in the tables reflecting file, table later loading it]

HR Question?

“At TekSlate, we are trying to create high quality tutorials and articles, if you think any information is incorrect or want to add anything to the article, please feel free to get in touch with us at info@tekslate.com, we will update the article in 24 hours.”