Teradata DBA with SOX Experience

Job Title

Required Skills:

• 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