We provide IT Staff Augmentation Services!

Teradata Performance Dba Resume

SUMMARY

  • An experienced IT professional with 7 years and 5 months of experience in Teradata performance and operational DBA activities administering databases like Teradata 13.10, 14.10 and 15.10 on various platforms.
  • Expertise in Performance Tuning, Query Optimization and hands on experience on Teradata load and unload utilities (Bteq, Fload, Mload, FExp) and other Teradata tools like Viewpoint, Teradata SQL Assistant, TaraGui, NetBackup, DSA, Teradata Administrator and TSET
  • Have extensive experience on daily DBA tasks like Space management, User management, Object management, Performance tuning and Teradata Backup/Recovery
  • Extensive experience in analyzing data from various DBQL tables to measure query performance and identifying bottlenecks in query processing, such as skewed nodes( CPU Efficiency), skewed steps, queries causing high IOWait etc
  • Have good understanding on Teradata’s parallel architecture
  • Proficient in setting up and maintaining Workload Management using TASM
  • Involved in Software Development Life Cycle (SDLC) of various projects, including requirement gathering, system designing, application development, enhancement, deployment, maintenance and support
  • Proactive identification of inefficient/poorly performing queries and suggesting improvements to application support teams/development teams/users
  • Worked with Asia’s largest Telecom datawarehouse standing at 100 TB and one of world’s largest e - commerce datawarehouse standing at 3 Petabytes
  • Also worked with large retailing and financial clients
  • Have played responsible roles in Teradata version upgrade activity and migration activity of production system
  • Have handled issues with Teradata supported software/hardware with Teradata GSC using T@ys
  • Proficient with basic UNIX commands and Python scripting
  • Good in analyzing business needs of clients, developing effective and efficient solutions and ensuring client deliverables within committed deadlines
  • Have experience on Compression and Identifying the list of unused tables for effective utilization of System Space
  • Experience of production support and issue resolution in 24*7 environment
  • Good analytical and problem solving skills

TECHNICAL SKILLS

  • Teradata (Versions - TD-12, TD-13.10, TD-14.10, TD 15)
  • Viewpoint, SQL Assistant, Teradata Administrator, Teradata Manager,
  • Teradata system emulation tool(TSET), Visual Explain, Tara Gui, Veritas
  • Netbackup,, PMON
  • Multiload, Fastload, Fastexport, Tpump, BTEQ, TPT
  • WIN 9X/XP/2000, SUSE Linux Enterprise server 10

PROFESSIONAL EXPERIENCE

Confidential

Teradata Performance DBA

Environment: Teradata 14.10, Teradata 15.10

Responsibilities:

  • As part of Preventive performance team, involved in performance review of every new ETL & BO Report before it is moved to Production and suggest performance recommendation and providing & technical guidance if required
  • Performed query optimization and assisted ETL developers and users by analyzing DBQL data, explain plan and join strategy and Partitioning large tables to improve performance of sqls
  • As part of proactive team identifying problematic ETLs and reporting queries and providing suggestions or modifying or re-writing the query
  • Also handling job failures and report failures as part of reactive performance team
  • Monitoring all systems and with understanding of each and every job running on Teradata box and proficient in identifying performance and resource bottlenecks.
  • Generating reports according to clients requirement like CPU usage, Space usage, Gating, AWT usage, finding skewed queries and High-CPU Users/Batches & Applications.
  • Involved in Hardware upgrades & Cutover planning of Confidential ’s Teradata Servers.
  • Closely work with the GSC on NTA’s & Incidents that are found vulnerable to the systems.
  • Monitoring backup jobs and providing alternate or troubleshoot failed database backups.
  • Responsible for cleanup of unused/unneeded stats & multicolumn stats with width > 25.
  • Involved in setting up Querybands throughout the EDW including utility jobs.
  • Involved in on-call rotation to provide 24 /7 database support.
  • Involved in maintaining the data copy tool, which is used to copy across the dual prod systems
  • Maintain and provide access to users to Data Labs
  • Monitoring incident ticket queue and troubleshoot and resolve database incidents within SLAs

Confidential

Teradata DBA (Managed Services)

Environment: Teradata 13.10, Teradata 14.10

Responsibilities:

  • Tuning poorly performing queries of worse Batches and Users which affects the system badly that appear on daily scorecard. Analyzing Explain Plan, DBQL and PDCR information for providing them the tuning solutions, recommendations & technical guidance to increase the query performance (High Parallel Efficiency & Low skew).
  • Good in monitoring Viewpoint for all 5 systems and with understanding of each and every job running on Teradata box and proficient in identifying performance and resource bottlenecks.
  • Generating daily performance scorecard report to analyze the overall system status such as CPU usage, Space usage, Gating, AWT usage, PE, finding out top 10 skewed users and batches, High-CPU Users/Batches & Applications.
  • Handling P1 issues like production ETL job failure with Spool out error, TASM abort, query running slow, delay and blocking issues.
  • Implementing Multi level compression and PPI extension activity.
  • Involved in Creating/Modifying macro/procedure as per client requirement
  • Execution of change requests for DDL & DML statements from the users
  • Performing SOX audit activity every week to find out non-compliance accounts present in the system and guiding them about the compliance.
  • PI revision, Secondary Index and Join Index creation.
  • Viewpoint Alert policy setup to send notifications in case of any unforeseen scenarios or issues.
  • Involved in activities like Creating Databases, Users, Roles, Profiles, etc. Granting and Revoking object / System Privileges on Databases / Users / Roles through ticketing tool (Trace).
  • Executing Managed services audit queries on the system.
  • Attending various client calls
  • Automating Reports on excel sheets

Confidential

Teradata DBA (Managed Services)

Environment: Teradata 13.10, Teradata 14.10

Responsibilities:

  • Daily handling of tickets raised by users regarding account creation, access grants, space movement and tuning requests
  • Daily Tuning of poorly performing as well as highly skewed/high CPU consumer queries of worse Batches and Users by analyzing Explain Plan, DBQL and PDCR information for providing them the tuning solutions and recommendations.
  • Regular monitoring of Viewpoint for all 4 systems and proficient in identifying performance and resource bottlenecks.
  • Creating users, roles, profiles and databases as per requirement
  • Handling P1 issues like production ETL job failure with Spool out error, TASM abort, query running slow, delay and blocking issues.
  • Was involved in Teradata Database upgrades and Teradata Node level expansion activities and make sure that the same go through smoothly, these also involve doing benchmarking before and after these upgrades to check the improvement/degradation in system performance as whole after these activities are completed, also monitor performance and test and correct errors after such upgrades. Measuring spool/perm space requirement after upgrade. Taking DDL back-up of all JOIN Index/Secondary Index and creating back once upgrade is done.
  • Time to time Implementation of MVC and PPI extension.
  • Performing SOX audit activity every quarter to find out non-compliance accounts present in the system and guide them about the rules & requirements for compliance.
  • PI revision, Secondary Index and Join Index creation.

Confidential

Teradata DBA (Managed Services)

Environment: Teradata 13.10, Teradata 14.10

Responsibilities:

  • Was involved in handling the DBA steps in migration activity and system upgradation for production system
  • Engaged with GSC as and when required to resolve critical issues
  • Creation and Maintenance of Users, Databases, roles and profiles manually and through Database Administrator tool Access rights Management, Space Management.
  • Creation of tables, views, macros and procedures, Purging of DBQL tables.
  • Performance Monitoring & tuning.
  • Managed Backup Operations by taking periodic backups of databases through Tara GUI and NetBackup.
  • Hands on various Teradata tools & utilities like Pmon, Viewpoint, Bteq, Teradata Administrator, TSET

Confidential

Teradata DBA

Environment: Teradata 12

Responsibilities:

  • Implementation of New Database, including Creating users, Database Objects etc
  • Compression analysis and implementation. Did Multi value compression on many tables.
  • Space Management: Current Space usage analysis, and recommendation regarding the utilization of space.
  • Creating users and User rights management.
  • Profile and Role management of database users
  • Creation of physical database objects (tables, views, indexes, Macros, Procedures)
  • Preparation of backup and restoration scripts and monitoring (Veritas Net backup and TARA GUI),
  • Performance Monitoring: Identified potential bottlenecks with user queries from the aspects of query writing, skewed redistributions, join order, optimizer statistics etc. Usage of Teradata Explain and Visual Explain to analyze and improve query performance. User sessions analysis, resource usage analysis and implementation of the required Workloads.
  • Analysis, selection and implementation of the system wide object demographic Statistics.
  • Advice structural changes and gives STATS collection recommendations wherever required.
  • Recreating the tables with new PI for resolving skew/space issues.
  • Setting the rules and throttles in the TDWM.
  • Archiving and Purging of Tables for space Maintenance.

Hire Now