Immediate Need for Teradata Database Administrator-NO OPT or CPT

 

Dear Professional,
Hope you're doing well!

 

Immediate Need for Teradata Database Administrator-NO OPT or CPT

 

Note: Passport copy or number is required for submission
USC,GC,GC-EAD,H4,L2,E3,TN, H1 Can Apply

 

Job title: Teradata Database Administrator
Work Location: Omaha, NE 68102
Duration: 4-6 Months
 
JD:
•             Responsible for maintaining all DBA functions (development, test, production) in operation 24×7.
•             Performance tuning, including collecting statistics, analyzing explains & determining which tables needed statistics to Increase performance by 35-40% in some situations.
•             Multiload, BTEQ, created & modified databases, performed capacity planning, allocated space, granted rights for all objects within databases, etc
•             Move/migrate databases between machines of different OS/platform.
•             Install patch sets and upgrade Teradata.
•             Automate data warehousing and datamart refreshes using Transportable table space option.
•             Work on creating and managing the partitions.
•             Perform database health checks and tune the databases using Teradata Manager.
•             Deliver new and complex high quality solutions to clients in response to varying business requirements and Creating and managing user accounts.
•             Install Teradata drivers for the teradata utilities.
•             Refresh the data by using fastexport and fastload utilities.
•             Use Teradata Administrator and Teradata Manager Tools for monitoring and control the system.
•             Create and modify MULTI LOADS for Informatica using UNIX and Loading data into IDW.
•             Load data from various data sources and legacy systems into Teradata production and development warehouse using BTEQ, FASTEXPORT, MULTI LOAD, FASTLOAD and Informatica.
•             With the in-depth expertise in the Teradata cost based query optimizer, identified potential bottlenecks with queries from the aspects of query writing, skewed redistributions, join order, optimizer statistics, physical design considerations (PI and USI and NUSI and JI etc) etc. In-depth knowledge of Teradata Explain and Visual Explain to analyze and improve query performance.
•             Perform 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.

 

Regards:
Mohammad Yaseen- IT Recruiter || IT Brainiac Inc.
Princeton Forrestal Village -116 Village Blvd. Suite # 200| Princeton NJ - 08540
Phone : 609-423-4871
Email : mohd.yaseen@itbtalent.com
Gmail : yaseen.itbtalent@gmail.com
Website: www.itbrainiac.com
 
This email message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.