Teradata DBA & Performance Tuning Expert

Ali Fraz

********@*****.*** **** highway *** W, Apt # 616, Austin TX 78736 +1-469-***-****

https://www.linkedin.com/pub/ali-faraz/2a/365/b58

Objectives

To pursue a challenging position in a dynamic, growing organization that can utilize my experience of cutting-edge analytic data platforms, applications and related services.

Skills

Teradata Database Administration (TD 12, 13.0, 13.10,14.0,14.10)

Teradata DEV/QA/PROD environments Development, Maintenance & Planning

Teradata System Performance Tuning/Optimization

Query Writing/Optimization, SQL EXPLAIN plan analysis, Query Banding

Teradata Active System Monitoring (TASM) Workload design & analysis

Teradata Utilities (Teradata Parallel Transport (TPT), BTEQ, Fastload, Multiload, Fastexport, TPUMP)

Teradata Tools (SQL Assistant, TD Administrator, TSET, TD Index Wizard, Workload Analyzer)

Teradata Viewpoint Management & Monitoring

System Health Analysis/Reporting using PDCR, DBQL & Resusage data

Multi value compression (MVC), Block Level compression (BLC), Teradata virtual storage (TVS)

Physical Database Modeling/Design, Understanding of OLAP/OLTP

CNS Utilities - Packdisk, Scandisk, Checktable, rcvmanager, qrysession, DBScontrol

Capacity Planning & Forecasting, Support in Upgrades

Unity, Dual active systems, Teradata multi-system management

Teradata Applications Support (CIM/ARM/TRM)

Backups & Restore – BAR activities & strategies using NetVaulT, ARCMAIN

Disaster Recovery Planning & Management

System Administration & Basic Shell scripting (UNIX/LINUX)

ETL/BI Operations & Application Support (Informatica, Control-M, GCFR, SLJM)

Informatica Power Center Support & Development (Intermediate Level)

SLAs and OLAs management

ITIL Processes & Framework (Incident/Problem/Change/Release Management)

IT Service Management Tools & Methodology (ITSM Remedy, Service Now)

Certifications & Trainings

Teradata 12 Certified Database Administrator

Teradata 12 Certified Technical Specialist

Teradata 12 Certified Professional

ITIL v3 Foundation Certified in IT Service Management

Teradata System Performance - Larry Higa (2012-Prague)

Teradata Performance Optimization through Physical Design (2014-Manila)

Teradata Performance Optimization through Workload Management (2014-Manila)

Customer Service Skills & Mindset Program (2013-Islamabad)

Employment History

Optimum IT Solutions Inc. Plano, TX

Teradata Database Administrator June, 2015 – present

Teradata Corporation Islamabad

Teradata Database Administrator Oct, 2010 – May, 2015

My role over the last 5 years as a Teradata DBA has been to deal with operational elements of the Teradata DWH Dev/QA/Prod/ environments to ensure uninterrupted service to client applications and end users. I have worked with development and production teams to refine, manage and enforce Teradata best practices, ITIL standards and also ensure adherence to committed SLAs. I have worked with complex Teradata platforms both onsite & offsite with some reputable clients of Teradata across Europe & Middle East. Following is a list of roles that I have taken as a consultant:

MS CoE - DBA & Performance Tuning (Jan 2015 – May 2015)

International Region

In this role, my key focus was to conduct performance optimization assessments and enforce Teradata DBA best practices across MS accounts in Europe, Middle East, Africa & Asia Pacific region.

System performance tuning exercise on key MS accounts

Identification of performance issues & provide/recommend optimized solutions

Create user guides for performance tools

Assist in implementation of Teradata DBA standard best practices, DBA process automation

User/Developers training on DBA best practices & performance optimization techniques

Unilever (Sep 2014 – Dec 2014)

Teradata System Performance Tuning Specialist Offsite

In the large DWH environment of Unilever, I was assigned as a Performance tuning expert and successfully identified/fix performance issues system wide and optimize semantic jobs to ensure SLA compliance

Semantic layer performance tuning & optimization

TASM & Workload design & analysis

Performance reporting for Capabilities using PDCR

Dev/QA/Prod environment performance testing of new releases

Tuning/Re-writing of complex ETL/Business queries and SQL EXPLAIN plan Analysis

Physical data modeling/design

Unity, Dual active systems, Teradata multi-system management

Teradata Virtual Storage (TVS)

Backups (BAR) analysis & policy review

Root Cause Analysis for system degradation & provide optimized Solution Recommendations/Fix

Telenor (Jan 2014 – Sep 2014)

Teradata DBA Onsite

I was assigned in a leading Telecom company of Pakistan as a Teradata DBA expert where I accomplished to optimize Teradata DWH system & stream line EDW operations.

Prod/QA/Dev environment DB Objects maintenance, Space Management, Security Management

Table design and index selection, Managing Roles/Rights/Profiles, Views/Macros/Stored Procedures

Teradata viewpoint monitoring & management, User creation, Rights, System Alerts setup

Capacity Planning (Saved 46-TB space)

Multi Valued Compression, Block level Compression

Auto Stats Collection Process Implementation/Maintenance, Stats Optimization

DBC Purging and History maintenance, System reporting using DBQL/Resusage Data

TASM workload analysis & implementation for efficient CPU utilization and workload throttling

Query optimization/tuning, SQL EXPLAIN plan analysis

Troubleshooting of ETL big-batches & PL Reports

Development/QA/Production migration, testing & deployments

Process automation, SLA’s/OLA’s maintenance

Offshore Team Management, Project documentation (Operational Manuals/Run-book)

Qatar Telecom - Ooredoo (Apr 2013 – Dec 2013)

Teradata DBA Onsite – Qatar

As a Teradata DBA in leading Telecom Company of Qatar, I introduced Teradata DBA best practices to optimize Teradata DWH Production/Development system & stream line EDW operations.

Development/Production systems DBA activities

Database Objects development, maintenance & planning

Table design and index selection & Stats management

CNS Utilities - Packdisk, Scandisk, Checktable, rcvmanager, qrysession, DBScontrol

Physical Database Modeling/Design

Data Backups & Restore using Netvault

Multi Valued Compression for Large tables

DBC Purging and History maintenance, System reporting using DBQL/Resusage Data

ETL Jobs query tuning & optimization, SQL EXPLAIN plan Analysis

Troubleshooting/Support of Informatica ETL batches, Incident/Problem resolution & Hotfixes

Offshore Team Management, Project documentation (Operational Manuals/Run-book)

Nokia (Apr 2011 – Apr 2013)

I worked in the challenging DWH environment of world's largest manufacturer of mobile handsets, where I served in multiple roles, as a Performance DBA as well as Informatica ETL lead.

Teradata Performance Optimization Specialist Onsite – Finland

Teradata System Performance tuning/optimization for Production/ QA & XLDB systems

Advanced Teradata Database Administration, Physical Data Modeling/Design

Query Optimization (Review/Re-write/Test SQL code) BTEQ’s/Macros/Views/Business queries

SQL EXPLAIN plan analysis, SQL Re-writing & Testing

Semantic layer aggregation tuning / recommendations

Performance testing of new releases

Stats Usage analysis & Optimization, Multi Value Compression (MVC) for large tables

TASM Workload analysis & recommend changes, Capacity Planning

Root Cause Analysis for system degradation & provide optimized Solution Recommendations/Fix

Reduced applications execution time and High resource savings in terms of CPU/IO & Space

Informatica Lead ETL Application Support Onsite – Finland

Incident/Problem Analyst for Demand & Delivery (DND) applications to adhere agreed SLA

Monitoring and troubleshooting of Informatica ETL batches & PL Reports

Informatica Power Center(Monitor and Manager) Support & Development

ETL Reporting, Data Validations, Source Data Reconciliations

Physical Data Modeling/Design

Teradata database objects creation/maintenance, Index review, Stats management

Project documentation for new releases (Operational Manuals for DND applications)

Statoil (Oct 2010 – Mar 2011)

Teradata DBA Offsite

As Teradata DBA in the leading energy company of oil & gas production, my duties were to perform DBA activities some of which are as below.

Dev/QA/Prod Environment Database Administration

DB Space/Spool Management, User management, Security management

Database objects creation and maintenance, Capacity Planning

Table Index usage review & analysis, Multi value compression, Stats collection & usage analysis

Manage Roles, Rights, Account Strings & Profiles

Teradata Loading Utilities

Packdisk, Scandisk, Checktable

DBC data maintenance and housekeeping

Data Backups & Restore

Gjensidige (Oct 2010 – Mar 2011)

Teradata DBA & Application Support Offsite

I was assigned on Norway's largest financial services Datawarehouse platform to provide DBA & Teradata Relationship Manager (TRM) Level 1 support

Teradata Relationship Manager (TRM) Level 1 support / Batch Troubleshooting

Teradata Database Administration activities for Dev/QA/Prod environments

System reporting

Data Backups & Restore using Netvault

Education

Forman Christian College

2010 - Bachelors of Sciences - Computer Sciences (Honors)

Valedictory Award Winner 2010

References

To be furnished on request.

Contact this candidate