Teradata Application DBA

Title:

Teradata Application DBA Location:

Lansing, Michigan.

Hybird Schedule:

Onsite:

Wed/Thur and Remote:

Mon/Tue/Fri Required Skills 8+ years' experience with Teradata V17+ 5+ years' experience in ETL using awk and Shell Scripting in a Unix/Linux environment 5+ years' experience with experience with Teradata Utilities (TPT, Mload, Fastload, BTEQ, etc.) 3-5+ years' experience with performance tuning within a Teradata environment (SQL Joins, Indexes, Viewpoint, Explains) 3-5+ years' experience in loading data from multiple source systems 3-5+ years' experience SQL Skills that include working with joins, indexes, partitions at table level and performance tuning skillsets 1+ years' experience with BI reporting tool along with basic modelling operations and maintenance issues. Experience working with end users/customers to understand system and business issues and perform technical analysis to develop solutions Ability to provide targeted training and technical guidance to development teams for troubleshooting and batch support Must be able to work independently and not rely on team members Communicate effectively, verbally and in writing, with programmers, analysts, immediate supervisor, management, system users, operations, other State agencies and the private sector. Recognize, gather, correlate, and analyze facts, draw conclusions, define problems, and devise solutions and alternatives and make appropriate recommendations. Preferred but not Required Skills Certified Teradata Master Experience maintaining Dashboards and other basic reports related to data warehouse on a daily basis. Experience with Teradata Studio/Teradata SQL Assistant Experience with cloud based BI tools/Data Warehouse implementations Previous experience with State Government