Teradata developer h1.location_city

For over 16 years, Trilyon has been a leader in global workforce solutions, specializing in Cloud Technology, AI/ML, Software Development, Technical Writing, and Digital Transformation. We partner with top companies to deliver high-quality talent in engineering, IT, and emerging technologies. For additional information or to view all of our job opportunities, please visit our website https://trilyonservices.com/careers/

We are seeking a Teradata Infrastructure DBA to join our team. This role will involve managing, optimizing, and maintaining enterprise-scale Teradata environments, ensuring high availability, performance, and security. The ideal candidate will have experience in Teradata architecture, system administration, performance tuning, and database infrastructure, along with a passion for large-scale data platforms and operational excellence.

Job Title: Teradata Infrastructure DBA

Location: Seattle, WA / St. Louis, MO (On-site)

Duration: 6 Months (Extendable)

Job Description:

We are looking for an experienced Teradata Infrastructure DBA with strong expertise in Teradata platform architecture and enterprise database environments. The Teradata Infrastructure DBA will be responsible for installation, configuration, administration, and optimization of Teradata systems across distributed environments.

The Teradata Infrastructure DBA will work extensively on performance tuning, system monitoring, backup and recovery, and infrastructure management. The Teradata Infrastructure DBA will collaborate with cross-functional teams including developers, infrastructure teams, and business stakeholders to ensure seamless database operations and high system reliability.

Additionally, the Teradata Infrastructure DBA will drive automation, capacity planning, and disaster recovery strategies, ensuring compliance with enterprise security and regulatory standards. The Teradata Infrastructure DBA will play a critical role in maintaining system uptime, scalability, and performance across enterprise data warehouse systems.

Key Responsibilities:

1. Install, configure, and upgrade Teradata software and related components (6 10+ years experience).

2. Manage Teradata architecture including parsing engine, BYNET, AMPs, vprocs, hashing, and fallback mechanisms.

3. Monitor and optimize system performance including CPU, memory, disk I/O, and query execution.

4. Perform SQL tuning, query optimization, and analyze Explain plans.

5. Implement workload management (WLM), resource allocation, and query prioritization.

6. Manage backup, restore, disaster recovery planning, and high availability strategies.

7. Administer database security including roles, privileges, encryption, and compliance (SOX).

8. Perform Linux system administration (RHEL, CentOS, SLES, Oracle Linux) for Teradata environments.

9. Automate tasks using scripting (Bash, Python, or Perl) and tools like Ansible or Terraform.

10. Monitor systems using tools like Teradata Viewpoint, Prometheus, Grafana, or similar.

11. Manage Teradata utilities such as BTEQ, FastLoad, MultiLoad, TPT, and DBSControl.

12. Collaborate with stakeholders, vendors, and infrastructure teams for system improvements.

13. Perform capacity planning, forecasting, and system scalability improvements.

14. Lead incident management, root-cause analysis (RCA), and postmortems.

15. Support database releases, upgrades, migrations, and change management processes.

Required Skills & Experience:

• 6 10+ years of experience in Teradata DBA and infrastructure management.

• Strong expertise in Teradata architecture (BYNET, AMP, hashing, fallback, spool management).

• Experience with Teradata versions (16.x, 17.x, preferably 20.x).

• Strong SQL skills including complex query writing, tuning, and optimization.

• Experience with performance monitoring tools and diagnostics.

• Knowledge of backup, recovery, disaster recovery, and high availability systems.

• Strong Linux administration experience.

• Experience with scripting (Bash, Python, or Perl) and automation tools.

• Knowledge of security practices including LDAP, Kerberos, encryption, and auditing.

• Experience with monitoring tools such as Viewpoint (mandatory), Prometheus, Grafana, or Splunk.

• Strong problem-solving, communication, and stakeholder management skills.

Preferred Skills:

• Experience with Teradata on cloud platforms (AWS, Azure, GCP) or virtual environments.

• Knowledge of containerization and virtualization technologies.

• Experience with project management, migrations, and system upgrades.

• Certifications such as Teradata Certified Administrator or Linux certifications (RHCSA/RHCE).

• Proven track record in performance improvements and large-scale system optimization.

Additional Requirements:

• Must be a US Citizen or Green Card holder.

• Only open to W2 employees.

Why Join Us?

Trilyon, Inc., offers a comprehensive benefits package.
Opportunities for growth and professional development.
Collaborative and inclusive company culture

Equal Employment Opportunity (EEO) Statement:

Trilyon, Inc., is an Equal Opportunity Employer committed to diversity, equity, and inclusion. We do not discriminate based on race, color, religion, gender, gender identity, sexual orientation, national origin, age, disability, veteran status, or any other protected status under applicable laws. Our diverse team drives innovation, competitiveness, and creativity, enhancing our ability to effectively serve our clients and communities. This commitment to diversity makes us stronger and more adaptable.