Consulting Performance Analyst II+ at Teradata India Pvt Ltd (2023-03 – Present)
Member of Performance Shared Services Team, supporting multiple global clients on performance assessment, PDCR services, SQL tuning, and Teradata Workload Management (TASM).
- Led offshore team for DB2 to Teradata forklift migration for healthcare client, including logical and physical data modeling, index strategy, and capacity planning, improving query performance and data warehouse design.
- Deployed Teradata optimization techniques such as Secondary Indexes (SI), Partitioned Primary Indexes (PPI), and Join Indexes (JI), reducing monthly T-core consumption by ~30% and lowering infrastructure cost.
- Executed Teradata to Snowflake migration involving ~1.5 PB of enterprise data and onboarding of 3,000+ analytics and business users, ensuring secure data access, warehouse segmentation, performance optimization.
DB Administrator at Amdocs Development Centre India LLP (2021-05 – 2023-03)
Acted as application DBA for a major telecom client, managing development and production environments with a strong focus on database availability, security, SLA adherence, and incident resolution.
- Served as Snowflake Administrator, managing end-to-end Snowflake platform operations.
- Supported data migration and ingestion pipelines from on-prem (Teradata) to Snowflake.
- Created and managed virtual warehouses, databases, schemas, stages, and file formats.
- Implemented RBAC roles, masking policies, and secure data access controls.
- Managed Snowflake Time Travel and Fail-safe for data recovery and retention.
- Optimized warehouse performance and reduced credit consumption through right‑sizing and workload tuning.
Senior Engineer at Brillio Technologies (2020-04 – 2021-05)
- Handled DBA operations for Teradata production environments including production failures, performance issues, Viewpoint monitoring, and health checks.
- Facilitated bulk data loading using Teradata utilities, improving data load performance and accuracy for ETL pipelines.
- Led performance tuning initiatives to address spool space issues and long-running SQL queries.
- Reduced DB storage costs by ~20% through effective use of compression techniques.
Senior Systems Engineer at Cognizant Technology Solutions (2017-11 – 2020-04)
- Developed and optimized complex Teradata SQL queries and stored procedures for enterprise data warehouse reporting and analytics workloads.
- Designed and implemented data transformation logic using advanced SQL, including window functions, analytical functions, multi-table joins, and subqueries.
- Built and maintained ETL pipelines using Teradata utilities (FastLoad, MultiLoad, TPump, BTEQ) for large-scale batch data ingestion.
- Played a key role in production upgrades from Teradata 15.0 to 16.20 and from 16.20 to 17.20 Intelliflex, including change planning, testing, execution, and post-upgrade validation.
- Troubleshot and resolved ETL pipeline failures and data load issue.
