Teradata DBA

Ventures Unlimited Inc; Cleveland (OH); On-site; USD 90,000 - 120,000; Full time

Benefits offered by this job

Base Salary + Benefits

Job summary

A technology services company in Cleveland is seeking a skilled Teradata DBA with over 7 years of experience in Teradata tools and database administration. The ideal candidate will excel in SQL tuning and performance optimization techniques. Responsibilities include managing database security and writing complex SQL queries. This position offers a full-time contract and includes a competitive salary plus benefits.

Qualifications

• 7+ years of experience with Teradata tools and utilities.
• 2+ years of experience in Teradata Database Administration.
• Experience with performance optimization and SQL tuning.

Responsibilities

• Manage Teradata database security effectively.
• Write complex Teradata SQL queries and procedures.
• Install and configure Teradata systems.

Skills

Teradata tools and utilities

SQL tuning

Teradata Database Administration

Performance optimization techniques

Writing complex SQL queries

Tools

Teradata Load Utilities

BTEQ

SQL Assistant

TPUMP

MLOAD

Fastload

Job description

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

Job Description

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

Additional Information