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.