Apply on Employer Site

Ventures Unlimited Inc · 12 hours ago

Teradata Infrastructure DBA

Plano, TX

Full-time

Onsite

Senior Level

Ventures Unlimited Inc is seeking a Teradata Infrastructure DBA with expertise in Teradata architecture and system administration. The role involves managing Teradata nodes, performance tuning, backup and recovery, and ensuring security and compliance within the platform.

ConsultingInformation TechnologyStaffing Agency

Diversity & Inclusion

Hiring Manager

Prabhakar Choudhary

Responsibilities

Must have

Teradata platform expertise

Deep 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 administration

Provisioning 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 troubleshooting

SQL 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 availability

Best 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 & compliance

DB 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 & infrastructure

Network 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 & tools

Scripting languages: Bash, Python, Perl for automation, maintenance, and custom monitoring. – one of them

Configuration management and automation tools: Ansible, Terraform, Chef, or Puppet (as used in the enterprise). – one of them

Familiarity with Teradata utilities and tools: BTEQ, FastLoad, MultiLoad, TPT (Teradata Parallel Transporter), DBSControl, Viewpoint, Teradata Studio/SQL Assistant. – one of them

Observability & tooling

Use of monitoring/alerting tools (Viewpoint, Prometheus, Grafana, Splunk, Nagios, etc.) and designing dashboards and alerts. One of them, Viewpoint is mandatory

Capacity planning, trending, and forecasting for CPU, disk, spool, and concurrency

Soft skills & organizational capabilities

Incident management and on-call experience

Leading postmortems, RCA (root-cause analysis), implementing corrective actions

Communication and stakeholder management: vendors, management and applications

Translate technical impacts to business stakeholders; coordinate with DBAs, developers, network/storage teams, and vendors

Qualification

Teradata architecture expertiseLinux administrationPerformance tuningBackupRecoveryDB securityComplianceNetwork architectureScripting languagesConfiguration management toolsMonitoring toolsIncident managementCommunication skills

Required