Teradata Infrastructure DBA

Teradata Infrastructure DBA

Location: Seattle, WA (Onsite) Duration: W2 Contract Experience: 10+ Years

Job Description

Infrastructure DBA experience and Back up and Recovery experience

Teradatas 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

Backup restore, frequency and retention

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

Need at least 10 years of experience in Teradata tools and utilities Teradata Database Administration experience.

Roles & Responsibilities

Managing security policies and compliance:

Monitor security and compliance including SOx audit controls to ensure adherence to financial and IT controls, identifying potential risks, and implementing corrective actions to maintain integrity.

System Monitoring and Maintenance:

Monitor Teradata systems for performance issues, optimize the performance, and ensure high availability and disaster recovery capabilities.

Troubleshooting and Prob

Teradata