Position: Teradata Infrastructure DBA

Location: Seattle, WA

Contract

Job Description:

• Infrastructure DBA experience and Backup and Recovery experience, specifically DSA experience

• Teradata's latest version DSA Backup and Recovery

• Data centers, backups etc. Working with onsite and offshore teams , system alerts, monitoring, etc.

• performance analysis and tuning , Best practices implemented on current system

• Work load management experience

• TSAM/TASM experience scale

• Windows Server administration

• Query grid, PDCR

• BAR experience

• Tara

• DDL backups

• End park

• Experience on stored procedures

• ETL coding or work with tools

• Admin experience of passwords , permissions

• Teradata upgrades and process followed

• Teradata OS upgrade done ( Teradata 17, 20)

• Virtualization in BAR

• Oncall support

• scrum agile experience

• 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

Must Have Skills:

• Need at least 5 years of experience in Teradata tools and utilities

• Need at least 2 years Teradata Database Administration experience.

• 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