Teradata DBA

IBA InfoTech Inc.
Jacksonville, United States of America
yesterday

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Senior

Job location

Jacksonville, United States of America

Tech stack

Query Performance
Business Software
ETL
Data Security
Relational Databases
Disaster Recovery
Perl
Hadoop
Monitoring of Systems
Job Control Language (JCL)
Interactive System Productivity Facility (ISPF)
Python
Mainframes
SQL Databases
TCP/IP
Teradata
Scripting (Bash/Python/Go/Ruby)
Data Storage Management
Information Technology

Job description

  • Support multiple Teradata systems including independentmarts, development/uat, disaster recovery, and the enterprise warehouse systems and business applications.
  • Manage / Support DR solution including DB object/access rights etc. sync.
  • Manage/Monitor system performance, including workload management and throttling in TASM, query performance and tuning, physical node behavior, and amp distribution.
  • Consult on physical database implementations, PPI, skew analysis, join methods, and data access paths.
  • Work with Teradata GSC in resolving RDBMS/TMS related incidents.
  • Implement and administer access policies in conjunction with corporate standards.
  • Support Mainframe administrative functions including Teradata TDP connections..
  • Support Unix/Linux level process, scripts, and tools for system management and data movement.
  • Automation of support process using Unix / Linux Scripting, Teradata SPL.
  • Manage, design, support, development and consult on practices of storage management, archive, restore, and disaster recovery.
  • Support Teradata Hardware / Software including TTU projects. Knowledge of ETL/SQL Tools, Hadoop etc.

Requirements

  • Advanced working knowledge of Teradata RDBMS at both physical and logical levels.
  • Advanced working knowledge of Teradata suite of tools; DataMover,BAR DSA, TASM, QueryGrid , BTEQ, ARCMAIN, FASTOAD, MLOAD, TPUMP, TPT, DBQL, PDCR, Viewpoint.
  • Familiar with Teradata Systems setup, GDO, DBSControl etc.
  • Working knowledge of Mainframe interfaces and execution; TDP (Channel and TCP/IP), JCL, TSO,ISPF, NDM.
  • Experience with Linux / Unix operating systems including strong scripting expertise in Shell and Perl / Python.

Apply for this position