Cognos 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. Impleme...