5+ years experience of Teradata administration experience or 4+ years of Teradata administration experience and 6+ years experience in the 

administration of another data warehouse/BI environment. 

 

Excellent knowledgeable in SQL performance tuning, database tuning parameters, administration, maintenance and monitoring for Teradata.

 

Working knowledge of incident and problem management.

 

Experience with database migrations, for both hardware refreshes and environment upgrades.

 

Monitor server status

Monitor alerts/errors 

Resolve alerts using ViewPoint, SQL Assistant, TD Administrator 

Monitor Backups status 

Monitor DB space 

Route alerts appropriately for correction 

Perform DB health checks & reporting 

Set up maintenance blackouts 

User, profile and access management 

Teradata appliance setup / installation 

Incident management/Change Requests/ Review of Standards 

 

Database maintenance 

 

Perform database backup/restores/data copy

 

Database refresh /cloning 

 

Knowledge Management – Enhancing SOPs for regular activities, KEDB 

 

Trend Analysis on CPU Heat/ AWT exhaust analysis  & Various Metrics 

 

Application DBA activities including scripting and deployment 

 

Reviewing Backup Strategy 

 

Database patch management-Teradata H/W, S/W Upgrades, Patching updates 

 

Infrastructure Review 

 

Capacity Planning- Disk space & CPU 

 

Review major changes that affect architecture 

 

Review database new releases and  perform impact analysis 

 

Disaster Recovery Planning / Strategy formulation