Need at least 10 years of experience in Teradata tools and utilities Teradata Database Administration experience.
Infrastructure DBA experience and Backup and Recovery experience
Teradata latest version Back-up and Recovery
Managing security policies and compliance
System Monitoring and Maintenance
Troubleshooting and Problem Resolution
Performance Tuning
Automation
Capacity Planning
Incident Management
Documentation
Release Management
Installs, configures and upgrades Teradata software and related products.
Backup, restore, migrate Teradata data and objects
Establish and maintain backup and recovery policies and procedures;
Manages and monitor system performance. proactively monitor the database systems to ensure secure services with minimum downtime? Implements and maintains database security;
Sets up and maintains documentation and standards.
Supports multiple Teradata Systems including independent marts/ enterprise warehouse.
Work with the team to ensure that the associated hardware resources allocated to the databases and to ensure high availability and optimum performance.
Responsible for improvement and maintenance of the databases to include rollout and upgrades.
Responsible for implementation and release of database changes as submitted by the development team? Work with end customer
Teradata , customer , datacenter, vendor co-ordinations? Forecast data, security audits? User account and access management? Teradata active system management and customer requests and system allocation? Backup and recovery
SOX compliance and audits
DB support from 3rd party vendors
Product evaluations
Oncall support and major incidents
Disaster recovery
Create long range disaster recovery
Customer feedback survey
Experienced in performance optimization techniques and Structured Query Language (SQL) tuning.
Demonstrated knowledge of Performance Data Collection and Reporting (PDCR) and Database Query Logging (DBQL)
Ability to write complex Teradata SQL queries, stored procedures, triggers, functions Practical experience in managing the internal and external Teradata database security