Teradata Infrastructure DBALocation: Remote with TravelDuration: FulltimeJob Description:Skills Desired:Teradata platform expertiseDeep knowledge of Teradata architecture: parsing, BYNET, AMP, vproc, fallback, hashing, PDCR, fallback, and spool management.Data distribution and primary index design; collecting statistics and understanding optimizer behavior.Experience with recent Teradata versions and releases migration/upgrade planning: TD 16.XX, TD 17.XX and preferably TD 20.XX.System administrationProvisioning and managing Teradata nodes and clusters (physical and virtual).OS-level skills: Linux administration (SLES/RHEL/CentOS/Oracle Linux) for Teradata on Linux, including kernel tuning, package management, user and permissions management.Storage subsystem knowledge: SAN, NAS, Fibre Channel, LUNs, RAID, and how storage impacts Teradata I/O and spool.Performance tuning and troubleshootingSQL query and plan analysis; collecting and interpreting Explain plans.Workload management (WLM) and resource allocation: query prioritization, throttling, and KRI/SLAs.Monitoring and diagnostics: using Teradata tools and logs to analyze spool, CPU, memory, disk I/O, network, BYNET contention.Backup, recovery & high availabilityBest practices for backups restore procedures, and disaster recovery (DR) planning and testing.Knowledge of fallback, AMP resilience, replication methods and physical vs logical protection.Security & complianceDB and platform-level security: roles, privileges, LDAP/Kerberos integration, encryption (at rest/in transit), auditing and compliance (SOx and Others as applicable).Secure configuration and hardening practices.Networking & infrastructureNetwork architecture for Teradata clusters, VLANs, link aggregation, low-latency requirements, and BYNET tuning.Integration with enterprise infrastructure: DNS, NTP, monitoring stacks, and identity providers.Automation, scripting & toolsScripting languages: Bash, Python, Perl for automation, maintenance, and custom monitoring. – one of themConfiguration management and automation tools: Ansible, Terraform, Chef, or Puppet (as used in the enterprise). – one of themFamiliarity with Teradata utilities and tools: BTEQ, FastLoad, MultiLoad, TPT (Teradata Parallel Transporter), DBSControl, Viewpoint, Teradata Studio/SQL Assistant.
– one of themObservability & toolingUse of monitoring/alerting tools (Viewpoint, Prometheus, Grafana, Splunk, Nagios, etc.) and designing dashboards and alerts. One of them, View point is mandatoryCapacity planning, trending, and forecasting for CPU, disk, spool, and concurrency.Soft skills & organizational capabilitiesIncident management and on-call experienceLeading postmortems, RCA (root-cause analysis), implementing corrective actions.Communication and stakeholder management: vendors, management and applicationsTranslate technical impacts to business stakeholders; coordinate with DBAs, developers, network/storage teams, and vendors.Good to haveProject & change managementExperience driving upgrades, migrations, and maintenance windows; adherence to change control and rollback plans.Mentoring and leadershipMentoring other DBAs, establishing runbooks, knowledge transfer, and operational documentation.Track record of successful upgrades/migrations, complex performance tuning wins, DR tests, and SLA-driven operations.Proven examples of measurable improvements (reduced query runtimes, increased concurrency, reduced downtime).Up-to-date knowledge of Teradata product direction (e.g., Vantage features) and integration with modern data ecosystems.Cloud & VirtualizationYears of experience: typically 5–10+ years in enterprise data platforms; several years specifically on Teradata for senior/system roles.Certifications (valuable, not always required)Teradata Certified Professional / Teradata Certified Administrator (current).Linux certifications (RHCSA/RHCE) and cloud provider certifications (AWS/Azure/GCP) where cloud deployments exist.Responsibilities:Installs, configures and upgrades Teradata software and related products.Backup, restore, migrate Teradata data and objectsEstablish and maintain backup and recovery policies and procedures.Manages and monitor system performance. proactively monitor the database systems to ensure secure services with minimum downtimeImplements 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, Working with end customerTeradata, customer, datacenter, vendor co-ordinationsForecast data, security auditsUser account and access managementTeradata active system management and customer requests and system allocationBackup and recoverySOX compliance and auditsDB support from 3rd party vendorsProduct evaluationsOn call support and major incidentsBackup restore, frequency and retentionDisaster recoveryCreate long range disaster recoveryCustomer feedback surveyExperienced 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