Daily jobs added for your total convenience. The best opportunities in the GTA!

Teradata DBA

Amyantek Inc.

This is a Contract position in Toronto, ON posted July 18, 2017.

Position: Teradata DBA
COntract Role

•             Experience in Physical Database Design and Implementation. Strong in Building and Tuning SQL’s.

•             Experience in carrying out Teradata system upgrade initiatives.

•             Experience in Archiving, Recovering DB using Net backup and Net vault.

•             Proficient in shell scripting to automate routine tasks.

•             Production support with changes, Backup & recovery, coordinate patch installation, open and follow up incidents with GSC.

•             Physical Implementation and maintenance of Tables, views, Join Index, sparse index etc.

•             Determines overall architecture of databases, ownership, rights, create and Maintain Users Profiles and Roles for EDW. Code DDL, load scripts, triggers, procedures, macros to assist application developer.

•             Support and Mentor Business users, ETL users and Developers for Terdata related issues.

•             Monitor and isolate skewing sessions, objects causing hot amps. Monitor the Resource usage, Parallel efficiency of Nodes and VProcs using Disk utilization charts.

•             Support system upgrade, run space Maintenance utilities. Assist users with report problems or spool problems.

•             Acts as consultant to end users, providing performance best practices for reporting and sql development

Experience required – 8+ years

Skills Required

  • Education level: None
  • Work experience (years): None

Package

Salary: N/D