Teradata Admin

 Responsibilities:

• Manage Teradata database objects including databases, users, roles, profiles, and views.
• Perform database performance tuning by analyzing queries, execution plans, skewness, join strategies, and optimizer statistics.
• Monitor system performance using tools like Viewpoint and analyze DBQL, ResUsage, and access logs.
• Implement workload management including resource partitions and query classification before execution.
• Manage database security including access control, roles, privileges, and authentication policies.
• Handle space management across systems including permanent, spool, and temporary space optimization.
• Perform capacity planning by analyzing historical and current system usage trends.
• Use compression techniques such as MVC and BLC to optimize storage utilization.
• Perform data archiving and restoration using utilities like DSA and ARCMAIN.
• Execute data loading and unloading using Teradata utilities such as FastLoad, MultiLoad, TPT, FastExport, and BTEQ.
• Implement QueryGrid and manage cross-system data connectivity.
• Handle production incidents and provide L2 support for Teradata environments.
• Ensure system maintenance including defaults, restarts, and stability management.