Teradata DB Engineer

Description

Requirements Looking for a strong Data/Tools person to work with Teradata database engineering managers. Resource should be analytical,comfortable with dealing large amounts and data, coming up with solutions for design of data security, data access/authorization, etc Must have working experience with the entire technology stack of Teradata appliance (Teradata 13.10, Viewpoint, SWS, TVI, BAR, SLES)Must have working knowledge of Protegrity (Database encryption software) and Oracle Key Manager (used for encrypting tape backups)Implemented PDCR (PMCP) and can support itDesigned and implemented a production Change Control policy and procedures.Install all the client Teradata tools and have extensive experience with TTU 13.10 client tools including Teradata Manager, SQL Assistant (Queryman), Teradata Administrator (WinDDI)Configure Viewpoint, develop portlets, reports, logging, alerting, etc. Extensive BAR experience, setting up and maintaining production archive strategies. Have used NetBackup and am familiar with the GUI interface. Extensive experience, porting tables from one Teradata server to another. Extensive experience working with Teradata incidents through Teradata @ Your Service and the Global Support Center (GSC). Know how to use TSET to send the GSC information they need to analyze problems and create the problem on their in house Teradata system for analysis and code debugging. Extensive experience monitoring and maintaining a production Teradata environment. Familiar with logging onto the Teradata nodes, running tools from the Supervisor screen such as PackDisk, CheckTable, ScanDisk, and other diagnostic tools such as VProcManager, setting GDO parameters and other tools available on the Supervisor screen. Teradata database design and Teradata SQL experience. Expertise in Teradata load utilities like MLoad and OLELoad, Teradata Parallel Transport utility (TPT) coding, maintain and develop Unix scripts and BTEQ scripts Expert in planning and execution of hardware/software upgrades and expansion, extensive shell scripting, system tuning and troubleshooting on UNIX, knowledge of database recovery and restart procedures, database monitoring and skilled with periodic performance tuning.Indepth knowledge of Teradata Explain and Visual Explain to analyze and improve query performance, expert level knowledge of complex SQL using Teradata functions, UDFs, macros and stored procedures, expertise in Data Warehouse Metadata concepts, tools and repositories. Broad knowledge of diverse data administration methodologies, and tools, knowledge of runtime optimization, capacity management and planning, security, configuration, scheduling, and execution of maintenance utilities, implemented multivalue compression. Experience using Teradata TMON to monitor and manage Teradata RDBMS resource utilization (TASM), and have created alert policies for monitoring database space, average disk use, TASM priority scheduler. Extensive TPUMP V13 Teradata TTU V. 13.10 Release Teradata Parallel Transporter for near real time and eliminates batch window.TDQM Establishing and managing end user security procedures, Rolls and Authorization.Teradata Tools and Utilities Design, creating and tuning physical database objects (tables, views, indexes) to support normalized and dimensional models. Maintain the referential integrity of the database. Provided ongoing support of the environment by developing processes and executing object migrations, security and access privilege setup, and performance monitoring. Position Description 1.Provide leadership in working sessions for system design2.Clearly articulate requirements for data design3.Define or assist with best practices during the program 4. Plan, design and recomment solutions and design alternatives5. Provide advice to cross program leads on optimizing the efforts.6. Develop proven practices and develop standards, including those around change control, security design, data considerations, best practices, reporting/query/analytical best practices, etc.