Teradata Architect

ATGS LLC; San Jose (CA); On-site; USD 120,000 - 150,000; Full time

Job summary

ATGS LLC is searching for a Senior Teradata Architect based in San Jose, California. The ideal candidate must have a Teradata Master Certification (12-14) and will be responsible for system performance optimization, project management, and supporting customer presentations.

The role requires advanced knowledge in Teradata and experience in SQL tuning, capacity planning, and database design reviews. Join ATGS to contribute to innovative solutions and help our clients achieve business success!

Qualifications

• Must be Teradata Master 12-14 Certified.
• Experience managing work requests and change requests.
• SQL tuning and performance optimization knowledge.

Responsibilities

• Responsible for customer presentations and solution sizing.
• Conduct project management and performance optimization.
• Provide critical system support and root cause analysis.

Skills

Advanced knowledge of Teradata

System performance tuning

SQL tuning and performance optimization

Expert knowledge of database optimization techniques

Excellent problem-solving skills

Education

Teradata Master 12-14 Certification

Job description

ATGS is a leading IT services, consulting and outsourcing company delivering exceptional business solutions and customer value to its customers worldwide. ATGS offers end‑to‑end innovative and leading edge solutions to help corporations leverage technologies, outperform their competition and acquire sustainable growth. We have proven capabilities in new and emerging technologies and extensive experience across a broad range of industries and domains which enable us to deliver world‑class, scalable and reliable business systems. We have been a steadfast company focused on the progress of our clients and developing trustworthy relationships with our customers, partners and employees. We at ATGS believe that "Simplicity is the ultimate sophistication" and always strive to build extendible and scalable technology solutions which fulfill the requirements of our customers in the most agile and simple ways. We are committed to help enterprises achieve business certainty and competitive advantage in the constantly changing marketplace in a transparent and customer centric manner. With our unique global delivery model, we focus on providing innovative and customized solutions that can be delivered quickly and cost effectively to complex business environments.

Job Description

Must be Teradata Master 12-14 Certified, willing to work M-F local and onsite, and a Senior Teradata Architect.

• Advanced knowledge of Teradata, UNITY and/or Unified Data Architecture.
• System performance tuning and capacity planning experience, including production and interpretation of PMCP reports to determine causes of poor performing code.
• SQL tuning and performance optimization, BTEQ, Shell script knowledge.
• Expert knowledge of Teradata database optimization techniques.
• Experience translating logical models to optimal physical models.
• Experience advising developers and development teams from design through build phase.
• Excellent problem‑solving skills with demonstrated experience managing and resolving work requests and change requests.

Responsible for customer presentations, system requirements definition, solution sizing, configuration, benchmark/proof‑of‑concept design & execution, project management, capacity planning analysis, system usage analysis, database design reviews, performance optimization, troubleshooting, critical system support, root cause analysis, and customer education.

Expertise in development and delivery of professional services offers

• Physical design & implementation.
• Performance optimization.
• Data mart consolidation (TMA).
• Performance data collection & reporting (PDCR).
• Capacity planning.
• Security.
• Tactical query design.

Contributions to Teradata Knowledge Management System

• SQL scorecard.
• Benchmark project plan.
• CDS calculator.
• Upgrade test planning.
• Online archive backup time estimator.
• Automated data validation routines.
• Query shaping for DBQL analysis.

Qualifications

Must be Teradata Master 12‑14 Certified.