Immediate Openinng :-Teradata DBA.....Lincolnshire, IL...12+ Month

Hi Partner,
Hope you are doing good,
I have a urgent direct client requirement, please send me your updated resume if you are interested .
below is the complete JD for the requirement.

Position : Teradata DBA

Location: Lincolnshire, IL
Duration :- 12+ Months

Job description:

Technical/Functional Skills • Has extensive experience working with Teradata day-to-day maintenance activities, Space Management, Performance Tuning, Capacity planning and Backup/Recovery strategies. • Experienced in working with Teradata ETL tools like Fast Load, Multi Load, Tpump and Fast Export. Also worked extensively on Teradata Query Submitting and processing tools like BTEQ and Teradata SQL Assistant. • Raise any issues with the Teradata supported software/hardware with Teradata (using T@YS) and manage these through to resolution. • Proactive identification of inefficient/poorly performing queries and suggesting improvements to application support teams/development teams/customers • Has experience with installation and configuration along with Upgrades and Debugging. • Proficiency with Database Query Log (DBQL) Query Performance Tuning, Teradata Active System Management (TASM), Protegrity Data Encryption Technologies. • Expertise in using Visual Explain, Index wizard, Statistics wizard to tune the bad queries and analyze the plans implement the recommendations to gain the performance. • Very strong on Teradata SQL query optimization techniques like: EXPLAIN feature, COLLECT STATISTICS, Secondary Indexes (USI, NUSI), Partition Primary Index (PPI), Volatile and global temporary tables etc. • Extensive knowledge on Dimensional Data modeling, Star Schema/snowflakes schema, Fact and Dimension tables • Highly experienced in SQL performance tuning/SQL optimization and debugging of ETL process. • Gathered information required for TSAM (Teradata Active System Management) implementation analyzing Teradata work Load analyzer, View Point, DBQL, Teradata administrator. • Hand's on Teradata Parallel Transport, Index wizard, SET etc.   Roles & Responsibilities 24X7 support as production DBA Attend meetings on a daily , monthly and weekly basis with the SMEs , Managers and Directors Preparation of status reports and submitting them to the immediate managers for review and feedback To be available after office hours as well in case of emergency support required includsing weekends Saturday and Sunday.

 

 

 

 

Thanks & Regards,
Amit Kumar
Technical Resource Specialist
Email: akumar@sysmind.com
Gtalk: recruiter.amitk@gmail.com
SysMind LLC
38 Washington Road, Princeton Junction, NJ: 08550
Ph:609-897-9670 *2155
M: 609-297-0794

P Help! Preserve trees. Please don't print this e-mail unless you really need to.

 

 

 

 

 

 

 

--
 
---
You received this message because you are subscribed to the Google Groups "Best IT Consulting Group" group.
To unsubscribe from this group and stop receiving emails from it, send an email to best-it-consulting-group+unsubscribe@googlegroups.com.
To post to this group, send email to best-it-consulting-group@googlegroups.com.
Visit this group at http://groups.google.com/group/best-it-consulting-group.
For more options, visit https://groups.google.com/groups/opt_out.