Job Title: Teradata DBA
Work Location: Lincolnshire, IL (Onsite)
Duration: 6 Months+
Relevant Experience
(in Yrs) 5 Years
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 TYS) 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 including weekends Saturday and Sunday.
--
The Most Active and Happening #1 ERP/SAP Jobs Listserve for SAP Jobs in the US.
LIKE our Facebook page : https://www.facebook.com/ERPJobs
https://groups.google.com/group/sapjobs-usa
Follow us on Twitter:
https://twitter.com/sapjobsusa
Post your Jobs at SAP JOBS USA Linkedin Group by clicking this link
https://www.linkedin.com/groups/SAP-JobsUSA-4081187/about
Join our Professionals Networks in Linkedin
https://www.linkedin.com/groups/SAP-JobsUSA-4081187/about
https://www.linkedin.com/groups/Global-Network-SAP-Professionals-4081179/about
https://www.linkedin.com/groups/Network-SAP-Professionals-3874920/about
http://finance.groups.yahoo.com/group/SAPJobs-USA/
https://www.facebook.com/groups/mysapfico/
---
You received this message because you are subscribed to the Google Groups "SAP JOBS USA" group.
To unsubscribe from this group and stop receiving emails from it, send an email to SAPjobs-USA+unsubscribe@googlegroups.com.
To post to this group, send email to SAPjobs-USA@googlegroups.com.
Visit this group at http://groups.google.com/group/SAPjobs-USA.
For more options, visit https://groups.google.com/groups/opt_out.
No comments:
Post a Comment