We provide IT Staff Augmentation Services!

Sr Teradata Admin Resume Profile

4.00/5 (Submit Your Rating)

Plano, TX

Summary

  • Certified TERADATA ADMIN ,Having around 9 years of experience in Teradata technology in different activities includes performance tuning, using Netbackup TARA GUI, Netvault, ARC utility for Backups/Restores, Good exposure in using TTU tools and utilities, Viewpoint, PMON, Teradata Manager for system monitoring and has experience in handling Hardware and database Upgradations are also part of my forte. Worked on Windows, MPRAS-UNIX and Linux platforms.
  • Having good experience in end-to-end Teradata DBA support which includes daily routine DBA activities, project code reviews, migration and upgrades of Teradata hardware software, backup scheduling monitoring Netbackup with TARA GUI, Netvault and ARC utility , other tools utilities TTU13 and 14 utilities, Teradata Administrator, Teradata Manager, dbscontrol etc , PDCR, DBQL, Capacity Planning and applying Agile methodologies for BI projects.
  • Worked with Fortune Global 500 companies like Bank of America, Barclays, Aviva and GE HealthCare.
  • Having mid-level ORACLE DBA experience and was involved in migrating Data Warehousing Oracle 9i databases to Oracle 10g RAC servers and adding partitions to critical Oracle databases of GE Healthcare client

Experience Role

Confidential

Sr Teradata Admin

Roles and Responsibilities:

  • Supporting 5 production, 3 DR and 8 DEV/SIT and UAT systems
  • Working with Retail banking, marketing, Home loans and Insurance, Anti-Money Laundering DB systems.
  • Close monitoring of all systems using Viewpoint and addressing the issues with application teams
  • Code reviews and deployments through CAB/ RFC's
  • Attempting the all other grants/ ad-hoc requests through Nexus , Maximo and ITSM tools
  • Backup scheduling and restores BAR and monitoring through Netbackup TARA GUI and mainframe tools.
  • Exposure in autosys scheduler
  • Provided solutions in code tuning
  • Access management
  • Creation of users and DB's through standard Stored procedures
  • Data copying to different environments through Data Mover
  • Environment/Data SQL synchronization using Teradata UNITY
  • Supporting with Mainframe and Teradata system engineers during the Teradata system maintenance

Confidential

Role Tech Lead

Role: Teradata Database Administrator Responsibilities

  • Extensive Experience in Teradata T13.10, T13, T12, V2R6 and V2R5.
  • Managing the users and running the scripts for maintenance through Teradata Viewpoint.
  • Data for Column level Compression.
  • Expertise in Database Administration - Teradata EDW Appliance
  • Profiling the
  • Creating profiles, roles and enabling the Query logging when required.
  • Moving data using Data mover between the environments.
  • Identifying and tuning most resource consuming SQLs
  • Preparing implementation strategies for Teradata objects for production enhancements
  • Actively involved in GEHC SOX audits
  • Involved in excellent planning of BI project review process checklists and provided continuous feedback to program teams during all project lifecycle milestones which helped GEHC BI projects to maintain quality, standards and improved performance.
  • Design and process preparation and execution of disaster recovery tests. Proper planning and co-ordination with all BI Teams made the activity successful for every quarter.
  • Perfect planning and co-ordination with Teradata support team and GEHC BI Teams, in executing the pre and post upgrade/NPARC node expansion activities. Always ensured to handover production system within the planned outage time.
  • Prepared and executed test cases, using HP Quality Center tool, for database activities like TD V13 upgrades, node expansion and backup enhancements etc.
  • Good knowledge in Teradata Backups using ARC utility, Netbackup, Netvault and TARA GUI tools.
  • Monitoring the regular system performance and state using Viewpoint.
  • Maintain Teradata database Objects and Indices, Space, Users, Purge Jobs and alerts associated with the Teradata environment.
  • Complete Teradata access requests new users, password resets, password unlocks and user deletion as required, following agreed processes.
  • Security Administration - Maintain Teradata roles and profiles
  • Configuring and Monitoring of alerts, queries, locking logger, access locks and database performance.

Confidential

Production database DBA

Roles and Responsibilities:

  • Database Administration using Teradata Manager, Administrator, PMON and Viewpoint.
  • Teradata Tools and Utilities SQL Assistant, BTEQ, Fast load, Multi-load etc .
  • Data migration/copy between servers PROD to Dev/Test using NPARC
  • User Creation/Maintenance.
  • Environment Creation.
  • Database/View refreshes.
  • Implementation of MVC
  • Release Management/Deployments
  • SQL Code Review
  • Monitoring
  • Support and co-ordination during Hardware and patch upgrades.
  • View point Administration
  • Check Table Pack Disk PDCR Maintenance etc
  • TASM Work load settings
  • Backup with TARA and Netbackup

We'd love your feedback!