Job ID: JOB_ID_7287
About the Role:
We are seeking a highly experienced Senior Teradata Systems Administrator to manage, optimize, and secure mission-critical enterprise data warehouse environments. This role focuses on high-level system administration, including software upgrades, migrations to Teradata 20.xx, and ensuring high availability across physical, virtual, and hybrid cloud infrastructures. You will serve as a technical lead for performance diagnostics and disaster recovery planning.
Key Responsibilities:
- System Lifecycle: Lead the installation, configuration, and migration of Teradata platforms (TD 16.xx to 20.xx).
- Performance Engineering: Conduct deep-dive SQL query analysis, interpret Explain Plans, and manage Workload Management (WLM) to meet Service Level Agreements (SLAs).
- Infrastructure Management: Administer Linux OS-level tuning and manage storage subsystems including SAN, NAS, and RAID configurations.
- Data Protection: Establish and test robust Backup and Recovery policies and Disaster Recovery (DR) procedures.
- Security & Compliance: Implement database security via LDAP/Kerberos and ensure strict adherence to SOX auditing and compliance standards.
- Monitoring & Automation: Utilize Teradata Viewpoint for proactive monitoring and develop automation scripts using Python or Bash with Ansible or Terraform.
Essential Skills:
- Expert knowledge of Teradata Architecture: AMP, BYNET, Parsing Engines, vprocs, and Spool Management.
- Hands-on experience with Teradata Utilities: BTEQ, FastLoad, MultiLoad, and Teradata Parallel Transporter (TPT).
- Proficiency in Performance Data Collection and Reporting (PDCR) and Database Query Logging (DBQL).
- Strong Linux System Administration (Kernel tuning, package management).
- Experience with NetBackup or similar enterprise backup solutions for Teradata.
Desirable Skills:
- Teradata Vantage on Cloud (AWS, Azure, or GCP) or VMware.
- Experience with Containerization and Virtualization concepts.
- Active Teradata Certified Administrator or Red Hat Certified System Administrator (RHCSA) credentials.
Keywords:
Teradata, DBA, System Administrator, Performance Tuning, SQL Optimization, Viewpoint, PDCR, DBQL, BTEQ, TPT, Linux, SLES, WLM, Disaster Recovery, SOX Compliance, Ansible, Python, Teradata 20.xx, Cloud Migration.
Special Requirements
MAX RATE $62 PER HR
Compensation & Location
Salary: $46 – $62 per year
Location: Dallas, TX
Recruiter / Company – Contact Information
Email: shi.kaushik@scalable-systems.com
Recruiter Notice:
To remove this job posting, please send an email from
shi.kaushik@scalable-systems.com with the subject:
DELETE_JOB_ID_7287