Ability to take on responsibilities as a Teradata engineer with good knowledge on Teradata administration; coordinates upgrades with the vendors and participates in the disaster recovery exercises.
Able to perform security audits and develop framework, which includes designing and implementing roles, profiles and accounts.
Able to create stored procedures to support the continued functioning of the Teradata data warehouse.
Work collaboratively with the database operations team and the vendor to resolve incidents and mitigate risks.
Manages and monitor system performance, Proactively monitor the database systems to ensure and secure services with minimum downtime
Demonstrated knowledge of Performance Data Collection and Reporting (PDCR) and Database Query Logging (DBQL)
Expertise with installing, maintaining, using all the Teradata tools (ex BTEQ, SQL
Assistant, TPUMP, TD Administrator, ODBC, MLOAD, Fast load, etc.)
Expertise in Space management: setup the purging policy, implementing compression techniques.
Experience in performance tuning-required.
Provide recommendations for tuning including statistics optimization, sampled statistics, stats recollection, data distribution, indexes, PPI, join optimization.
Performance optimization of resource intensive ETL and individual user queries.
Work with others as a team and provide recommendation for process improvement.
Providing suggestions to DBA's on optimal workload management settings in
TASM to be able to meet response-time SLA's as well as optimize resource consumption.
Ability to conduct trainings and handling meetings with users, analysts, developers-preferred.
Exposure and Knowledge on Postgres Database is a plus.