Saman Irfan

Worked as Database Performance Specialist for Teradata Client 'Dutch PostCode Lottery' from Netherlands to help performance optimization of Long Running ETL processes using Query Tuning, Physical Design Changes and various other performance optimization techniques. Provided support as subject matter experts (SME) for Database Performance Optimization Strategies.

In Teradata, I have worked with number of customers internationally as Database Performance Specialist and Lead Database Administrator. I was responsible for Database Administration, Database Performance Tuning & Optimization, Workload Management, Data Compression, SQL & Stored procedure scripting, Physical Data Modelling, Capacity planning & Forecasting, Disaster Recovery Management and Security Administration.

Worked as a Senior Database Performance Engineer involved in Database Performance improvement activities for Teradata Production System at PepsiCo (United States). Proactive identification of problematic queries using Viewpoint Query Spotlight portlet or using DBQL history tables. Resolution of problematic queries using various possible methodologies i.e. Query Tuning Techniques, Physical Design Changes (Secondary, Join Indexes etc.), Statistics Recommendations etc.

Worked as a Lead DBA responsible for Teradata Client OP Pohjola from Finland. Main Responsibilities included: Database Administration Database Performance Tuning & Optimization Workload Management Data Compression SQL & Stored procedure scripting Physical Data Modelling Capacity planning & Forecasting Disaster Recovery Management and Security Administration.

Teradata Client: ICELAND Foods Led the Performance Optimization Activities on Teradata System for Optimal System Performance. Good knowledge in Incident, Problem management and post-mortem analysis skills. Performed Teradata Unity (Data Mover) Process Monitoring. Analyzed Key Performance Metrics and made recommendations for improvements. Partnered with various teams to evaluate tools and technology best suited for project needs.

Performed Teradata Database Administration activities on Production and Development System. Worked closely with development teams to help maintain architectural standards and assisted in timely delivery of solutions and processes. Performed Backup and Restore Management using Teradata ABU. Proactive and Reactive monitoring, troubleshooting and resolution of critical issues. Implemented Teradata Service Improvement Plan on Teradata Production System.

Worked as an ETL Operations and Database Administrator resource involved in maintaining Database as well as Developed, monitored, and maintained ETL processes, reporting applications, and Data Warehouse design.