Teradata DBA

E*Pro Inc; Cleveland (OH); On-site; Full time

Job summary

A leading IT consulting firm located in Cleveland, Ohio, seeks an experienced Teradata Database Administrator. The ideal candidate will have at least 7 years of expertise in Teradata tools and utilities and a minimum of 2 years in database administration. Responsibilities include installing and configuring Teradata software, managing system performance, and implementing database security measures. This role demands a proactive approach to maintaining optimal database performance and ensuring security with minimal downtime.

Qualifications

• At least 7 years of experience in Teradata tools and utilities.
• Minimum of 2 years Teradata Database Administration experience.
• Experience in performance optimization techniques and SQL tuning.

Responsibilities

• Install, configure, and upgrade Teradata software and related products.
• Backup, restore, and migrate Teradata data and objects.
• Establish and maintain backup and recovery policies and procedures.

Skills

Teradata tools and utilities

Teradata Database Administration

SQL tuning

Performance Data Collection and Reporting

Complex SQL queries

Teradata Load Utilities

Tools

BTEQ

SQL Assistant

TPUMP

TD Administrator

MLOAD

Fastload

Job description

E*Pro Consulting service offerings include contingent Staff Augmentation of IT professionals, Permanent Recruiting and Temp-to-Hire. In addition, our industry expertise and knowledge within financial services, Insurance, Telecom, Manufacturing, Technology, Media and Entertainment, Pharmaceutical, Health Care and service industries ensures our services are customized to meet specific needs. For more details please visit our website www.epro-tech.com

Job Description

Required Skills

• 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)

Roles And Responsibilities

• Installs, configures and upgrades Teradata software and related products.
• Backup, restore, migrate Teradata data and objects
• Establish and maintain backup and recovery policies and procedures;
• Manages and monitor system performance. proactively monitor the database systems to ensure secure services with minimum downtime
• Implements and maintains database security;
• Sets up and maintains documentation and standards.
• Supports multiple Teradata Systems including independent marts/ enterprise warehouse.
• Work with the team to ensure that the associated hardware resources allocated to the databases and to ensure high availability and optimum performance.
• Responsible for improvement and maintenance of the databases to include rollout and upgrades.
• Responsible for implementation and release of database changes as submitted by the development team