Ref No.: 18-04781
Location: San Jose, California

Job Description :
1) Teradata Performance Tuning – Hands on experience on teradata performance tuning activities, good understanding of various performance tuning activities such as SQL Tuning, Index usage analysis – stats/ PJI's/ explain plans/ Spool Usage/ Skewness etc, System Performance tuning, TASM Settings and capacity planning
2) Teradata Platform Related Activities – Hands on experience on managing the platform activities – TASM/ Bteq/ Backup and Recovery/ Viewpoint alerts and monitoring.
3) Good understanding of Teradata architecture, experience in Teradata Administrative utilities & DSA
4) Ability to understand and generate reports from DBQL/reusage
5) Good understanding of Teradata Database System Control settings(DBS Control)
6) Basic knowledge on Unix scripting and Informatica, and reporting tools such as BO Reports, Tableau. Should be able to write simple shell scripts, understand basic concepts of Informatica, and Reporting tools.
7) Should act as a liason between the DBA team and Teradata Support teams to resolve issues like performance and product support as and when needed.
8) Experience with Teradata Viewpoint 15 & TD 14.10/15
9) Flexibility in working on a 24*7 support model (eg weekend shifts)

At KAYGEN, we are always looking for dynamic, talented and experienced individuals. We invite you to join our team of talented IT professionals, consulting at client locations across the globe. Our culture is team-orientated; we strive to stand by our core values of respect, honesty and integrity. Our team of experienced staffing experts will work with you to find you the best opportunity. For more information please visit us at