Responsibilities:
• Support multiple Teradata systems including development/UAT, disaster recovery, and the enterprise warehouse production systems and business applications.
• Manage/Monitor Teradata system performance, including workload management, query performance and tuning, physical node behavior, and amp distribution.
• Have a basic understanding of physical database implementations, PPI, skew analysis, join methods, and data access paths.
• Administer access policies including non-public data masking/encryption policies in conjunction with corporate standards.
• Support some Mainframe administrative functions including archive processing and job scheduling.
• Understand practices of storage management, data movement, archive, restore, and disaster recovery and be able to support.
• Work closely with Sr. DBAs and Application projects teams on implementation of database changes to support large project initiatives and BAU work.
• Code, test, and implement stored procedures and scripts which will automate selected DBA tasks.
• Manage/Monitor Teradata system performance, including workload management, query performance and tuning, physical node behavior, and amp distribution.
• Have a basic understanding of physical database implementations, PPI, skew analysis, join methods, and data access paths.
• Administer access policies including non-public data masking/encryption policies in conjunction with corporate standards.
• Support some Mainframe administrative functions including archive processing and job scheduling.
• Understand practices of storage management, data movement, archive, restore, and disaster recovery and be able to support.
• Work closely with Sr. DBAs and Application projects teams on implementation of database changes to support large project initiatives and BAU work.
• Code, test, and implement stored procedures and scripts which will automate selected DBA tasks.
Qualification
• Working knowledge of Teradata RDBMS at both physical and logical levels.
• Working knowledge of Teradata suite of tools: TDWM, BTEQ, ARCMAIN, FASTEXP, FASTLOAD, MLOAD, TPUMP, TPT, DBQL, SQL Assistant, PDCR, Teradata STUDIO and Teradata Administrator.
• Basic knowledge of Mainframe interfaces and execution; TDP, JCL, TSO, ISPF, FICON, NDM.
• Working knowledge of Viewpoint, Teradata Data Mover, DSA, Teradata BAR technology
• Working knowledge of Teradata suite of tools: TDWM, BTEQ, ARCMAIN, FASTEXP, FASTLOAD, MLOAD, TPUMP, TPT, DBQL, SQL Assistant, PDCR, Teradata STUDIO and Teradata Administrator.
• Basic knowledge of Mainframe interfaces and execution; TDP, JCL, TSO, ISPF, FICON, NDM.
• Working knowledge of Viewpoint, Teradata Data Mover, DSA, Teradata BAR technology
