TERADATA DBA

Role: Senior Teradata Database Administrator (DBA)

Location: Minneapolis, MN (Onsite)

Contract

Job Summary

• Perform day-to-day administration and support of Teradata database environments across development, test, and production.
• Install, configure, upgrade, patch, and maintain Teradata database systems.
• Monitor database health, availability, performance, capacity, and resource utilization.
• Perform Teradata performance tuning, including query optimization, workload management, indexing, statistics, and system-level tuning.
• Analyze and troubleshoot database performance issues, failed queries, locking/blocking, spool space, and resource contention.
• Manage Teradata users, roles, privileges, profiles, and security policies.
• Perform database backup, restore, recovery, and disaster-recovery activities.
• Support database migration, upgrade, and environment refresh activities.
• Monitor and manage Teradata space utilization, including permanent, temporary, and spool space.
• Work with development teams to review SQL and recommend database optimization strategies.
• Support high-volume data loads and ETL processes.
• Troubleshoot production incidents and participate in 24x7 on-call / rotational support, if required.
• Develop and maintain automation/scripts for database monitoring and administrative activities.
• Ensure database environments comply with enterprise security, governance, and operational standards.
• Collaborate with data engineering and cloud teams on modernization and migration initiatives.
• Maintain technical documentation, operational procedures, and troubleshooting guides.

Required Skills

• 7+ years of experience in Teradata Database Administration.
• Strong hands-on experience with Teradata architecture and administration.
• Strong knowledge of Teradata SQL.
• Experience with Teradata performance tuning and query optimization.
• Experience with:
  • Teradata Utilities
  • FastLoad
  • MultiLoad
  • FastExport
  • TPT (Teradata Parallel Transporter)
  • BTEQ
• Strong knowledge of database backup, recovery, replication, and disaster recovery.
• Experience managing Teradata users, roles, permissions, profiles, and security.
• Strong understanding of AMPs, Parsing Engines, BYNET, nodes, and Teradata architecture.
• Experience with workload management and resource management.
• Strong troubleshooting and production support experience.
• Strong Linux/Unix shell scripting skills.
• Advanced SQL and database performance analysis skills.