Teradata Infrastructure DBA
Share
Job Location:
Seattle, OR - USA
Monthly Salary:
Not Disclosed
Posted on:
30+ days ago
Vacancies:
1 Vacancy
Job Summary
Job Title: Teradata Infrastructure DBA
Location: Seattle WA
Type of Hire: FTE /Permanent
Skill: Teradata
Minimum Experience: 6 - 8 Years
Qualification: BACHELOR OF COMPUTER SCIENCE
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 TD and preferably TD .
- 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 View point 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.
Good to have
Project & change management
- Experience driving upgrades migrations and maintenance windows; adherence to change control and rollback plans.
- Mentoring and leadership
- Mentoring 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 & Virtualization
- Years 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.
Role and Responsibilities
- Installs configures and upgrades Teradata software and related products.
- Backup restore migrate Teradata data and objects
- Establish and maintain backup and recovery policies and procedures.
- Manages and monitor system performance. proactively monitor the database systems to ensure secure services with minimum downtime
- Implements 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 customer
- Teradata customer datacenter vendor co-ordinations
- Forecast data security audits
- User account and access management
- Teradata active system management and customer requests and system allocation
- Backup and recovery
- SOX compliance and audits
- DB support from 3rd party vendors
- Product evaluations
- On call support and major incidents
- Backup restore frequency and retention
- Disaster recovery
- Create long range disaster recovery
- Customer feedback survey
- Experienced 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
Thanks & Regards
Sukhwinder Singh
