Teradata Database Admin - Dba Resume
2.00/5 (Submit Your 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