Teradata DBA Resume

SUMMARY

Over 8+ years of IT industry experience and expertise working with Data Warehousing Technologies.
Have 7 years of experience on Teradata Database Administration.
Part of Teradata software upgradation team: from TD 12 to TD13.10
Experience in Various Versions of Teradata including Teradata V2R4/R5/R6/12/13.10 and various versions of Teradata Utilities.
Experience working on enterprise servers (5550) & appliances (2650).
Experienced working with a complex system of size 230TB having 32 nodes of 5550 with 800 AMP’s.
Extensive experience on performance tuning of SQL’s using various tuning methods like, analyzing the explain plan, analyzing skews (Table level, SQL level), working with Statistics collection, working with indexes (PI, SI, JI, AJI,PPI, MLPPI), to use temp tables like Volatile/Global Temp Tables, applying Compression, etc
Implemented various Teradata recommended best practices in Optimization & Performance Tuning.
Extensive knowledge in Teradata Architecture, Design, Development and Optimization of applications.
Expertise in working with Teradata Utilities: Multi Load, Fast Load, TPT, Fast Export, TPUMP, BTEQ.
Work with Developers & DM on troubleshooting and fine tuning of scripts.
Worked with DM team to review the Data models and finalize the objects.
Experienced working on Data Warehousing concepts such as Facts, Dimensions and Schemas.
Worked on Erwin tool to build the Logical data models.
Proficient in using Teradata Administrator for managing Databases, Users, Tables, Indexes, statistics, managing permissions( Roles & Profiles), addressing the user issues such as resetting passwords, unlocking user ID’s etc.
Hands on working with Teradata Viewpoint to monitoring bad queries, aborting bad queries, looking for blocked sessions and working with development teams to resolve blocked sessions.
Worked on PDCR to generate performance related reports using PDCR tool kit.
Migration of database objects across different environments.
Involved in database upgrades, TTU client software upgrade.
Worked on capacity planning, reported disk and CPU usage growth reports using PDCR tool kit (DBQL, Resusage, AmpUsage, DBC tables)
Set up the TASM with the proper partitions and workloads based on Service Levels. Set up Teradata Query manager to automate many of the DBA tasks such as collection of statistics, monitoring spool space, candidate tables for purge, etc.
Worked on scheduled Backups, Collecting Statistics, DBQL, AmpUsage, ResUsage jobs. Created and scheduled various Teradata recommended Performance, Capacity, trending and activity reports such as Space, Usage, Access, security reports.
Involved in Backup, Archive, Recovery, Purging, post & pre scheduled outages, modifying resource conditions etc.
Experienced working as on-call/production support DBA.
Experience in planning and coordinating Disaster recovery solution for Teradata.
Proficient in UNIX Scripting.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship