Category
Request Details
Title
Teradata Database Administrator
Number of Resources
1
Location
India - remote
Seniority
Associate
Required Tech Skills
See below.
Optional Tech Skills
See below.
Start Date
ASAP
Duration
TBD
Budget Range
Up to 23 USD
Currency
USD
Overlap
CEST
Work Model
Remote
Dual Employment
Not allowed for this project
Client Job Title: Teradata Database Administrator (DBA)
Adastra Job Title: System Engineer
This role is strictly focused on System-Level Workload Management, Resource Governor Architecture, and TASM (Teradata Active System Management) Tuning.
It is not a SQL/Query-level performance tuning or indexing role. The ideal candidate must possess deep expertise in controlling system concurrency, configuring Priority Scheduler dynamics, managing resource partitions, and enforcing enterprise SLA governance using Teradata Viewpoint / Workload Designer.
Key Responsibilities
TASM Ruleset Design & Rule Architecture
- Understand the currently TASM Ruleset and Architecture with minimal supervision.




- Document the improvements required suitable for the current usage pattern on the systems.
- Architect, configure, test, deploy enterprise TASM rulesets using Teradata Workload Designer in Teradata Viewpoint.
- Design and implement System Throttles, Workload Throttles, and Query Arrival Rate Throttles to maintain system stability and prevent resource exhaustion (e.g., AMP Worker Thread / AWT depletion).
- Establish System Filters and Workload Filters to intercept and block rogue, unoptimized, or non-compliant queries prior to execution.
- Define and maintain Workload Definitions (WDs) and Workload Groups to categorize inbound database sessions accurately based on user attributes, application, database, and statement criteria.
- Manage resource allocation across diverse workload tiers: Tactical, Service (interactive/BI), Batch/ETL, and Low/Idle/Dev priority workloads.
- Optimize Delay Queue dynamics to control concurrency spikes during peak business hours w

📌 Teradata Database Administrator (India)
🏢 AdAstra
📍 India