We provide IT Staff Augmentation Services!

Sr. Teradata Dba & Hadoop Admin Resume

SUMMARY

  • 12 years of experience in Administering Teradata Production Databases wif 3 Years Onsite Experience Sr Teradata DBA. 6 month having Hadoop Admin.
  • As well as good Experience in Development, testing and implementation using Teradata DBA in UNIX / LINUX.
  • Strong analytical and problem - solving skills wif good interpersonal and communication skills.
  • Worked extensively to tune teh performance of SQL’s to attain optimum utilization of resources.
  • Experienced in undertaking sessions on Teradata architecture and utilities.
  • Monitoring and Supporting of Teradata Production database as Administrator.
  • Good Knowledge in UNIX Shell scripting, Stored Procedures, Data Labs etc.
  • Worked on using Teradata utilities (Multiload, Fastload, BTEQ and Fast Export) to load, transform and export teh data to/from a data warehouse.
  • Worked extensively on Backup and Recovery’s by using Netvault and Netbackup applications using TARAGUI
  • Good Knowledge in Dimensional Data modelling, Star/Snowflake schema design, Fact and Dimensional tables, Physical and Logical data modelling
  • Worked efficiently in various roles such as Sr Database Administrator, Database Administrator, Assistant Team Lead, Shift Lead and Team member on different assignments in diverse team sizes.

TECHNICAL SKILLS

Languages: UNIX, Shell Scripting, SED, AWK, HTML.

Operating Systems: Windows, Sun Solaris, Linux

Databases: Teradata V2R5/V2R6/V12/V13/v13.10,V 14, V14.10V15,V15.10

Eco System: Hadoop 2.x (Basic Knowledge)

Teradata Utilities: BTEQ, Multiload, Fastload and Fastexport

Administration Tools: Teradata Performance Monitoring (PMON) Tool Teradata Administrator,ViewPoint,TSETTeradata Index wizard, DataMover TDWM, Teradata Statistics wizard, Data Labs.

Backup Tools: Netbackup wif TaraGUI, Netvault

PROFESSIONAL EXPERIENCE

Confidential

SR. Teradata DBA & Hadoop Admin

Responsibilities:

  • Teradata installs patches and upgrades where necessary, but we will coordinates wif Teradata GSC Team and users.
  • Monitor and plan for Teradata disk space quotas. Promptly respond to warnings dat disk space is running low.
  • Supported Major upgrade activity from Teradata Version 15 to 15.10
  • Worked on VM Upgrades and actively participated teh Production database upgrade.
  • Refreshed teh data by using fast export, Multiload, fastload and ARC utilities.
  • Assisting developers/users to tune queries and reviewed teh SQL for missing joins & join constraints, data format issues, mis-matched aliases, casting errors.
  • Overseeing daily and weekly back-ups using Netbackup wif TaraGUI and DeDupication Technology.
  • Aborting queries consuming very high spool, high CPU or high IO after checking wif teh user.
  • Automated statistics collection process using Viewpoint Stats Manager Portlet.
  • Collected Multi-Column Statistics on all teh non-indexed columns used during teh join operations & all columns used in teh residual conditions.
  • Granted & Revoked Object Rights, System Rights on Databases/ Users/ Roles
  • Maintenance activities like Check Table, Scandisk, Packdisk using Ferret Utilities
  • System utilities - e.g., dbscontrol, ferreted.
  • User scripts and 3rd party applications like Atana Suite
  • Creating and managing user accounts and databases wif appropriate security.
  • Prepared shell scripts for monitoring teh system
  • Setup and researched on new features like Trusted Sessions.
  • Implemented LDAP autantication for enabling single sign on.
  • Install and use of FuzzyLogix functionality in Teradata Database.
  • Assist reporting users for query optimization and involved in supporting report Development using COGNOS, TABLEAU, Micro strategy, QLIKVIEW, Spotfire Applications.
  • 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.
  • Defining Alerts using Alert Policy Editor to Monitor Teradata System in order to take proactive like, database space exceeding threshold limits by sending emails, aborting idle sessions existing more TEMPthan certain threshold time
  • As Teradata DBA, responsible for maintaining all DBA functions (development, test, production) on three platforms in operation 24x7. Platforms included 9 node of Production 2750 appliance,4 nodes of Validation system 2750 appliance, 4 node of Testing and development systems 2750 appliance wif TD 15.10
  • Supporting & install PDCR for Performance data collection and reporting database which includes a toolkit & enable Viewpoint data collection.
  • Setup & Researching on Data Labs Mechanism in in Teradata Environment.
  • As Hadoop Admin, responsible for maintaining all Admin functions (development, Val, production) on three platforms in operation 24x7. Platforms included 11 nodes of Production, 11 nodes of Validation, 10 nodes of Testing and development Wif Teradata integrated Hadoop systems (storage of 128TB and 3 replica factors).
  • Monitoring Hadoop connectivity and performance of teh cluster using Ambari.
  • Performing teh cluster coordination via zookeeper.
  • Knowledge on Hadoop ecosystem such as HDFS, Map Reduce, Yarn, Hive and Zookeeper.
  • Moving teh data between Teradata and Hadoop using TDCH & querygrid functionality.
  • Backup and recovery of Name nodes files into Netbackup.
  • Be a Part of POC team and halp installing teh AsterR on teh Hadoop system.
  • Data load between AsterR and Hadoop system.
  • Responsible for managing teh Ambari Users and Groups.

Confidential

SR. Teradata DBA

Responsibilities:

  • As Teradata DBA, responsible for maintaining all DBA functions (development, QA, UAT, production) on Four platforms in operation 24x7. Platforms included 30+6 nodes of Production, 15 nodes of Testing and development systems wif TD V14.10 & TD15.
  • Design and developed scripts for DBA Audit Reports and schedule in Control-M.
  • Use of all database administration tools to analyze system status/performance.
  • Teradata installs patches and upgrades where necessary, but we will coordinates wif Teradata GSC Team and users.
  • Supporting PDCR for Performance data collection and reporting database which includes a toolkit.
  • Responsible for providing teh best Teradata Datastage/Informatica Loading strategies for ETL processing of getting data into Data mart.
  • Setup core process required to source new data streams into Teradata data mart
  • Participated in teh design and development of a technical architecture dat will be aligned wif teh client’s business objectives.
  • Worked on NetBackup Technology to take teh backups wif TARAGUI application.
  • Involved in workload balancing through TASM.
  • Implemented new features of different Compression introduced in V14.10.(MultiValue, Block Level, columnar).
  • Explored on new feature like Teradata Virtual storage
  • 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 Performance Tuning.
  • Transfer Critical data into DR system by using Data Mover and schedule jobs in Control-M.
  • All client and DBA documents are uploaded into SharePoint Application and will access only DBA’s.
  • Resolving DataMover job issues while transferring data to DR system.
  • Using teh workload management tool and methodology to manage teh system workload to halp business team to meet SLA.
  • Performed database health checks and tuned teh databases using Teradata Viewpoint.
  • Wif teh in-depth expertise in teh Teradata cost based query optimizer, identified potential bottlenecks wif queries from teh aspects of query writing, skewed redistributions, join order, optimizer statistics, physical design considerations (PI/USI/NUSI/JI) etc. In-depth noledge of Teradata Explain and Visual Explain to analyze and improve query performance as Part of Performance Tuning
  • Analyzing sessions wif for high spool usage, high CPU usage, high disk usage, and high skew etc. when alerts are received.
  • Few projects are used agile methodology, and we will support for those applications as per SLA’s & Priorities.
  • We are able to run (and understand teh output from) CHECKTABLE and SCANDISK.
  • Analyze explains/statistics/diagnostics to isolate SQL problems.
  • Teradata SQL, OLAP functions, and Load/Unload utilities
  • Perform report development, MSTR architecture work, and interaction wif business, SMEs and client MSTR team, perform requirements-gathering and translate to technical requirements, document requirements/design.
  • Assist reporting users for query optimization and involved in supporting report Development using COGNOS, TABLEAU, MSTR, QLIKVIEW Application.
  • Did performance tuning, including collecting statistics, analyzing explains & determining which tables needed statistics. Increased performance by 35-40% in some situations.
  • Multiload, BTEQ, created & modified databases, performed capacity planning, allocated space, granted rights for all objects wifin databases, etc.
  • Deliver new and complex high quality solutions to clients in response to varying business requirements and Creating and managing user accounts.
  • Installed Teradata drivers for teh Teradata utilities.
  • Refreshed teh data by using fastexport and fastload utilities.
  • Used Teradata Administrator, Teradata Manager Tools & Viewpoint for monitoring and control teh system.

Environment: Teradata 14.10 & 15, Viewpoint, NETBACKUP, TARA GUI, TSLAM Application, Teradata Administrator, Teradata Index wizard, Teradata SQL Assistance, Teradata system Emulation Tool (TSET) and Teradata utilities like BTEQ, Fastexport, Fastload, Mload, TPT, Atana Suite, PDCR, DataMover, Data Domain etc.

Confidential

SR. Teradata DBA

Responsibilities:

  • Teradata installs patches and upgrades where necessary, but we will coordinates wif Teradata GSC Team and users.
  • Monitor and plan for Teradata disk space quotas. Promptly respond to warnings dat disk space is running low.
  • Worked on VM Upgrades and actively participated teh Production database upgrade.
  • Refreshed teh data by using fast export, Multiload, fastload and ARC utilities.
  • Assisting developers/users to tune queries and reviewed teh SQL for missing joins & join constraints, data format issues, mis-matched aliases, casting errors.
  • Overseeing daily and weekly back-ups using Netbackup wif TaraGUI and DeDupication Technology.
  • Aborting queries consuming very high spool, high CPU or high IO after checking wif teh user.
  • Automated statistics collection process.
  • Collected Multi-Column Statistics on all teh non-indexed columns used during teh join operations & all columns used in teh residual conditions.
  • Granted & Revoked Object Rights, System Rights on Databases/ Users/ Roles
  • Maintenance activities like Check Table, Scandisk, Packdisk using Ferret Utilities
  • System utilities - e.g., dbscontrol, ferreted.
  • User scripts and 3rd party applications like Atana Suite
  • Creating and managing user accounts and databases wif appropriate security.
  • Prepared shell scripts for monitoring teh system
  • Setup and researched on new features like Trusted Sessions.
  • Explored on new feature like Teradata Virtual storage
  • 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.
  • Defining Alerts using Alert Policy Editor to Monitor Teradata System in order to take proactive like, database space exceeding threshold limits by sending emails, aborting idle sessions existing more TEMPthan certain threshold time
  • As Teradata DBA, responsible for maintaining all DBA functions (development, test, production) on three platforms in operation 24x7. Platforms included 9+3 node of Production 6700 appliance,6+3 nodes of Pre production system 6700 appliance, 6 node of Testing and development systems 2650 appliance wif TD V14
  • Supporting PDCR for Performance data collection and reporting database which includes a toolkit
  • Setup and researched on LDAP Mechanism on all systems.

Confidential

Teradata DBA

Responsibilities:

  • As Teradata DBA, responsible for maintaining all DBA functions (development, test, production) on three platforms in operation 24x7. Platforms included 7+3 node of Production, 6 nodes of Testing and development systems wif TD V14.
  • Use of all database administration tools to analyze system status/performance.
  • Teradata installs patches and upgrades where necessary, but we will coordinates wif Teradata GSC Team and users.
  • Supporting PDCR for Performance data collection and reporting database which includes a toolkit
  • Responsible for providing teh best Teradata Datastage/Informatica Loading strategies for ETL processing of getting data into Data mart.
  • Setup core process required to source new data streams into Teradata data mart
  • Participated in teh design and development of a technical architecture dat will be aligned wif teh client’s business objectives.
  • Worked on NetBackup Technology to take teh backups wif TARAGUI application.
  • Involved in workload balancing through TASM.
  • Tested and Implemented new features of different Compression introduced wif V14.10.(MultiValue, Block Level, columnar).
  • Setup and researched on new features like Trusted Sessions.
  • Explored on new feature like Teradata Virtual storage
  • 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.
  • Using teh workload management tool and methodology to manage teh system workload to halp business team to meet SLA
  • Performed database health checks and tuned teh databases using Teradata Viewpoint.
  • Wif teh in-depth expertise in teh Teradata cost based query optimizer, identified potential bottlenecks wif queries from teh aspects of query writing, skewed redistributions, join order, optimizer statistics, physical design considerations (PI/USI/NUSI/JI) etc. In-depth noledge of Teradata Explain and Visual Explain to analyze and improve query performance.
  • Analyzing sessions wif for high spool usage, high CPU usage, high disk usage, and high skew etc. when alerts are received.
  • We are able to run (and understand teh output from) CHECKTABLE and SCANDISK.
  • Able to determine for wat tables teh PACKDISK is necessary and run it wif teh appropriate parameters.
  • Analyze explains/statistics/diagnostics to isolate SQL problems.
  • Teradata SQL, OLAP functions, and Load/Unload utilities
  • Perform report development, MSTR architecture work, and interaction wif business, SMEs and client MSTR team, perform requirements-gathering and translate to technical requirements, document requirements/design.
  • Assist reporting users for query optimization and involved in supporting report Development using COGNOS, TABLEAU Application.
  • Few projects are used agile methodology, and we will support for those applications as per SLA’s & Priorities.
  • Did performance tuning, including collecting statistics, analyzing explains & determining which tables needed statistics. Increased performance by 35-40% in some situations.
  • Multiload, BTEQ, created & modified databases, performed capacity planning, allocated space, granted rights for all objects wifin databases, etc.
  • Worked on creating and managing teh partitions.
  • Deliver new and complex high quality solutions to clients in response to varying business requirements and Creating and managing user accounts.
  • Installed Teradata drivers for teh Teradata utilities.
  • Refreshed teh data by using fastexport and fastload utilities.
  • Used Teradata Administrator, Teradata Manager Tools & Viewpoint for monitoring and control teh system.
  • Working as a Teradata DBA, doing DBA activities dat are Implementation of data and table-level security, setting up access rights and space rights for Teradata environment. Performance tuning, Monitoring and reporting Review system utilization by user.

Environment: Teradata 14, Viewpoint, NETBACKUP, TARA GUI, TSLAM Application, Teradata Administrator, Teradata Index wizard, Teradata SQL Assistance, Teradata system Emulation Tool (TSET) and Teradata utilities like BTEQ, Fastexport, Fastload, Mload, TPT, Atana Suite, PDCR etc.

Confidential

Teradata DBA

Responsibilities:

  • Worked on NetBackup Technology to take teh backups wif TARAGUI application.
  • As Teradata DBA, responsible for maintaining all DBA functions (development, test, production) on three platforms in operation 24x7. Platforms included 2580, 6 node for production, 2node for development and testing, 6680 2+1 node wif TD V14.
  • Setup core process required to source new data streams into Teradata data mart
  • Participate in teh design and development of a technical architecture dat will be aligned wif teh client’s business objectives.
  • Responsible for providing teh best Teradata Datastage Loading strategies for ETL processing of getting data into Data mart.
  • Involved in workload balancing through TASM.
  • Tested new features of different Compression introduced wif V13.10.(MultiValue, Block Level).
  • Setup and researched on New features like Trusted Sessions.
  • Explored on new feature like Teradata Virtual storage
  • 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.
  • Using teh workload management tool and methodology to manage teh system workload to halp business team to meet SLA
  • Performed database health checks and tuned teh databases using Teradata Manager.
  • Wif teh in-depth expertise in teh Teradata cost based query optimizer, identified potential bottlenecks wif queries from teh aspects of query writing, skewed redistributions, join order, optimizer statistics, physical design considerations (PI/USI/NUSI/JI ) etc. In-depth noledge of Teradata Explain and Visual Explain to analyze and improve query performance.
  • Analyzing sessions wif for high spool usage, high CPU usage, high disk usage, and high skew etc. when alerts are received.
  • Use of all database administration tools to analyze system status/performance.
  • Analyze explains/statistics/diagnostics to isolate SQL problems.
  • Teradata SQL, OLAP functions, and Load/Unload utilities
  • Perform report development, MSTR architecture work, and interaction wif business, SMEs and client MSTR team, perform requirements-gathering and translate to technical requirements, document requirements/design.
  • Did performance tuning, including collecting statistics, analyzing explains & determining which tables needed statistics. Increased performance by 35-40% in some situations.
  • Multiload, BTEQ, created & modified databases, performed capacity planning, allocated space, granted rights for all objects wifin databases, etc.
  • Worked on creating and managing teh partitions.
  • Installed Teradata drivers for teh Teradata utilities.
  • Refreshed teh data by using fastexport and fastload utilities.
  • Used Teradata Administrator, Teradata Manager Tools & Viewpoint for monitoring and control teh system.
  • Working as an Off-Shore Teradata Lead DBA, doing DBA activities dat are Implementation of data and table-level security, setting up access rights and space rights for Teradata environment. Performance tuning, Monitoring and reporting Review system utilization by user

Environment: Teradata 14, ViewPoint, NETBACKUP, TARA GUI, TSLAM Application, Teradata Administrator, Teradata Index wizard, Teradata SQL Assistance, Teradata system Emulation Tool (TSET) and Teradata utilities like BTEQ, Fastexport, Fastload, Mload, TPT, Atana Suite etc.

Confidential

Teradata DBA

Responsibilities:

  • Working as a Teradata Production DBA in a large environment.
  • Experience using Viewpoint& Teradata Administrator to Monitor and Manage Teradata Database.
  • Creating Teradata objects like Databases, Users, Profiles, Roles, Tables
  • Granting & Revoking of Object Rights, System Rights on Databases / Users / Roles for Security administration.
  • Monitoring of Sessions, Nodes, and VPROC Information.
  • Analyzing and changing of TASM settings
  • Aborting long running session for ADHOC user and Tune those queries.
  • Preparing teh Database Monitoring scripts and schedules teh scripts in Crontab.
  • Reallocating Disk Space - Move Space.
  • Preparing Database / Table Space Usage reports.
  • Backup job scripting and monitoring in Netbackup by using TARA Application.
  • Done Query rewriting concepts to improve teh performance of teh queries.
  • Investigating Space Usage & Monitoring teh growth of teh databases.
  • Support to teh GSC team for Installations, upgrade and patch for Teradata client software as required.
  • Support Business Systems Application development team wif technical and development, and maintenance of Teradata databases, including performance monitoring, tuning, problem resolution and data dictionary administration.
  • Oversee Teradata NetBackup backups through TARA GUI. Respond to backup failure, releasing locks and restarting failed backups when time constraints permit.

Environment: Teradata 13/13.10, Teradata Manager, ViewPoint, NETBACKUP, TARA GUI, Atana Suite, Teradata Administrator, Teradata Index wizard, Teradata SQL Assistance, Teradata system Emulation Tool (TSET) and Teradata utilities like BTEQ, Fastexport, Fastload, Mload, Atana Suite etc.

Confidential

Teradata DBA

Responsibilities:

  • Monitor teh Teradata Database for any/all activities impacting it
  • Acting as an "eye wif cognizance" monitoring teh activity impacting Teradata
  • Database running 24x7.
  • Hourly report to Teradata SPOC
  • End of Day observations to Confidential BI managers & Teradata SPOC
  • Aborting Sessions wif HIGH AMPCPU

Environment: Teradata 13, Teradata Manager or ViewPoint, Teradata Administrator, Teradata Index wizard, Teradata SQL Assistance, Teradata system Emulation Tool (TSET) and Teradata utilities like BTEQ, Fastexport, Fastload, Mload etc.

Hire Now