Posted 3 months ago

Teradata DBA

ClevelandOn-siteFull-time

AI Summary

The Teradata DBA designs, implements, and maintains Teradata database systems for a banking-domain customer, optimizing performance, managing security, and executing complex SQL, stored procedures, and load utilities.

About this role

Teradata DBA

Ventures Unlimited is a service centric organization. Our success begins with our ability to apply our relationships, leverage technologies, and identify talent - often in combination - to an endless array of real-world customer needs

Title: Teradata DBA
Location: Cleveland, OH
Type: Fulltime// Permanent
Compensation: Base Salary + Benefits
Interview Process: Phone and Skype Hire
End Customer: Banking domain

Description:
• Need at least 7 years of experience in Teradata tools and utilities
• Need at least 2 years Teradata Database Administration experience.
• Experienced in performance optimization techniques and Structured Query Language (SQL) tuning. Demonstrated knowledge of Performance Data Collection and Reporting (PDCR) and Database Query Logging (DBQL)
• Ability to write complex Teradata SQL queries, stored procedures, triggers, functions
• Practical experience in managing the internal and external Teradata database security
• Strong understanding of Teradata Load Utilities, MVC, TPT, BTEQ scripts
• High degree of efficiency installing and configuring Teradata systems with Teradata
• Expertise with installing, maintaining, using all the Teradata tools (ex BTEQ, SQL Assistant, TPUMP, TD Administrator, ODBC, MLOAD, Fastload, etc)

Nice to have skills:
• Informatica 9.X (Power Exchange, Power Center) is plus
• Knowledge of UNIX scripting is a plus
• Understanding of CA7 is a plus
• Experience in migration project from Oracle to Teradata is plus
• Data warehouse experience is plus