We provide IT Staff Augmentation Services!

Teradata Database Admin - Dba Resume

2.00 Rating

SUMMARY

  • Over 10 years of IT experience in Database Development,Designing, Administration (DBA) and Management.
  • Around nine years of experience in Teradata Administration, Development and building all the phases of Enterprise Data Warehouse.
  • Extensively worked on Teradata utilities TASM, Teradata Dynamic Workload Manager (TDWM), Teradata Administrator, Teradata Manager, Priority Scheduler, PMON, BTEQ, Fastload, Multiload, Fastexport and Teradata SQL Assistant.
  • Experience in archiving, restoring data on Teradata using ARC utility and TARA GUI.
  • Created workloads to control concurrent sessions and exceptions by using TASM components Teradata Dynamic Workload Manager (TDWM) and Priority Scheduler.
  • Performed Capacity Planning on Space Management and System Health Trend Periodically for the future enhancements and Pipeline Projects.
  • Troubleshooting and analyzing problems like job hangs, slowdowns, inconsistent rows, revalidating headers for tables with RI constraints, PPIs and configuration.
  • Wrote various UNIX scripts for Database extraction from different server locations and filtering data.
  • Capably used Mainframes (COBOL - II, DB2, IMS DB/DC, CICS, JCL, VSAM, ISPF, TSO and MQ Series).
  • Strong working experience in planning and carrying out of Teradata system Extraction, Loading Processes, Data Warehousing, MPP and Large-Scale Database Management and Reengineering.
  • Proficient in Teradata Database Design (Physical and Logical), Application Support, Performance Tuning, Optimization, User & Security Administration, Data Administration and setting up the Test and Development environments.
  • Experience in query and database management tools like TDQM, Teradata manager, Queryman, Priority Scheduler and Performance monitor.
  • Involved in Data Migration between Teradata, MS SQL server, DB2 and Oracle.
  • Programming experience in Teradata SQL, Stored Procedures, Macros and Triggers.
  • Used most efficient way of data and DDL backups and environment refreshes.
  • Configured Teradata Manager on servers for monitoring and alert purpose.
  • Extensively worked on creating the JCL’s in MVS environment.
  • Strong experience in query and database management tools like DB2I and SPUFI.
  • Responsible for the design and implementation of the entire DW Dimensional Model architecture using Join Indexes and Partitioned Primary Indexes to achieve and exceed the desired performance.
  • Extensively worked on tools like Xpeditor, Changeman, and File-aid.
  • Experience in handling VSAM files in mainframe and working with them.
  • Good experience in scheduling the mainframe jobs using CA7

We'd love your feedback!