John Joseph

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.

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.

Master of Computer Applications - Computer Applications - Annamalai University

Post Graduate Program - Cloud Computing - University of Texas, Austin