John Joseph
Teradata Principal Architect
Hire this person
Send a job offer directly to this candidate
About
Accomplished Teradata Principal Architect with 24+ years of expertise in Enterprise Data Architecture, Data Warehousing, Cloud Migration, and Performance Engineering across Retail, Healthcare, Finance, and Travel domains. Recognized for leading enterprise-scale Teradata to Cloud transformations (Azure, GCP), optimizing workloads, and implementing secure, high-performing data ecosystems. Skilled in stakeholder engagement, agile delivery, and cross-functional leadership to deliver scalable, cost-efficient, and compliant data solutions.
Experience
Lead Systems Architect - CVS Health
(2014-10)
- Lead architect for the migration of On-Prem Teradata to Google Cloud (Teradata Tenant), overseeing multi-PB data movement.
- Designed and implemented enterprise Teradata workload and capacity planning across Retail, Pharmacy, PBM, and Aetna LOBs.
- Established database and OS-level audit governance, ensuring compliance with enterprise data security standards.
- Developed real-time DBQL/Splunk monitoring for proactive anomaly detection and automated reporting on skewed queries and missing statistics.
- Managed DR planning and annual environment validation, ensuring zero-data-loss recovery protocols.
- Directed IAM streamlining, OS & DB baseline security enforcement, and automated alerts (FIM-based) across production nodes.
- Experience with Data governance, data security, data quality, data lineage, data catalog and compliance practices.
- Knowledge on Vantage Systems with Database Version 20.00.
- Partnered with leadership to align data architecture with enterprise cloud modernization and performance optimization goals.
Infrastructure Technical Specialist - CITI Bank
(2011-08 - 2014-10)
- Managed multi-system Teradata environments (COB, PROD, DEV) focusing on performance, capacity, and workload optimization.
- Led multiple system upgrades (v13.0 → v14.0) and Teradata Service Connect integration across international teams.
- Designed physical implementation strategies in collaboration with ETL teams, ensuring optimized resource utilization.
- Supported Cognos reporting performance improvements via TASM rule tuning and query optimization.
Sr. Teradata DBA - Sabre Holdings
(2006-07 - 2011-08)
- Architected and managed enterprise Teradata Data Warehouse environments for global travel data operations.
- Designed and implemented security frameworks (DBQL, PMCP/PDCR) and access control mechanisms.
- Led performance optimization initiatives using PPI, join indexes (HJI, SJI, AJI), and space allocation management.
- Supported global regions with capacity management, tuning, and system upgrade strategies (6.0 → 12.0).
Data Warehouse DBA - Walmart Stores Inc
(1999-07 - 2006-07)
- Managed one of the world's largest Teradata databases (300TB+) for enterprise decision support systems.
- Led architecture for Active Data Warehouse rollout, enabling near real-time POS data ingestion (<15 min latency).
- Directed system migration initiatives using Teracopy for 300TB+ of data across Teradata 5400 systems.
- Implemented PPI, Roles, and Priority Scheduler optimization for 80K+ daily query workloads.
- Mentored offshore teams in ETL and database design best practices, ensuring global code standardization.
Programmer Analyst - International Software Consulting Inc
(1998-12 - 1999-07)
- Worked on Y2K remediation projects on Mainframe and Teradata environments.
Education
Master of Computer Applications - Computer Applications - Annamalai University
Post Graduate Program - Cloud Computing - University of Texas, Austin
