Teradata Architect

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. #J-18808-Ljbffr ATGS LLC