Teradata DBA with more than 10 years experience including some experience with Teradata V17.20 or higher.
Support Application DBA functions including DDL creation, SQL scripting, problem research, change deployments, on call rotation support, etc.
Assist with design, development, implementation, documentation, and support of automated DBA processes using Teradata and Unix/Linux scripting.
Support multiple Teradata systems including development/UAT, disaster recovery, and the enterprise warehouse production environments.
Implement and administer access policies in conjunction with corporate standards.
Support some Mainframe administrative functions including archive processing and job scheduling.
Manage, design, support, document, and consult on practices of storage management, archive, restore, and disaster recovery.
Work closely with Application projects teams on implementation of database changes to support large project initiatives and BAU work.
Complete any assigned training courses and attend any required team meetings/calls to learn about and stay up to date on internal DBA team processes and tools. Provide high level weekly written status report to manager.
Work independently with minimal supervision, with general guidance from more seasoned DBA team members or managers
Required Qualifications
Advanced working knowledge of Teradata RDBMS at both physical and logical levels.
Advanced working knowledge of Teradata suite of tools: Teradata Studio, TDWM, BTEQ, ARCMAIN, FASTOAD, MLOAD, TPUMP, TPT, DBQL, PDCR.
Working knowledge of Mainframe interfaces and execution; TDP, JCL, TSO, ISPF, FICON, NDM.
Working knowledge of Viewpoint, Teradata Data Mover, Teradata BAR technology.
Working knowledge of Unix/Linux scripting (KSH, BASH, PERL).
Desired Qualifications
Familiar with Teradata Systems setup, GDO, DBSControl, Multitool, etc.
Working knowledge of QueryGrid, DSA, Taraserver, NPARC, TASM
Working knowledge of job schedulers: CA-7, AutoSys, etc. Replication technologies, Golden Gate.
Familiar with REXX scripting.
Familiar with Hadoop and Cloud concepts and technologies
Familiar with project and change management solutions and automation software, such as Agile, Remedy, Ansible.