We provide IT Staff Augmentation Services!

Lead Teradata Dba Resume

SUMMARY

  • Over 15 years of work experience in IT Industry in the Teradata DBA/performance Tuning/ Teradata Developer / Generating Looker Reports /DBA Activities with Unix scripting in Data warehousing stream
  • Worked in full DBA/Development Life Cycle for different applications in different environments.
  • Experience on space management (Allocations), user access managements (Roles and profiles).
  • Experienced in Teradata performance tuning in all areas.
  • Teradata Client Installations in different environments.
  • Viewpoint monitoring, change workloads, monitor/abort blocking or blocked jobs
  • Experienced in TD utilities like TPT, BTEQ, Fast Load, Multi Load, Tpump, Fast Export, SQL Asst
  • Thorough understanding of BI & Data Warehousing Concepts with emphasis on Full ETL Life Cycle.
  • ESP Job preparation and ETL implementation using python frame work.
  • Active Batch Job scheduling and monitoring and preparing SSIS packages for ETL frame work.
  • Experienced with Teradata Tools like SQL Assistant, Teradata View Point, Teradata Manager
  • Experienced in Administrative activities like creating users, roles and performance monitoring
  • Working Knowledge on backup and recovery operations using Tera - Gui, Netback, Net volt.
  • Working Knowledge on Dimensional Modeling Concepts Star Schema and Snow Flake Schema
  • Experienced in using Erwin for the data models (FSLDM / BDW )
  • Experienced with UNIX shell scripting and processing files
  • Generating Looker Dash Boards using Look ML Code and Teradata database as back end
  • Domain knowledge like (Banking, Insurance, Retailer, Health care and Tele Communications)
  • Excellent skills in delivering the projects on time to ensure customer satisfaction
  • Possess leadership and managerial qualities along with problem-solving skills and can-do-attitude

PROFESSIONAL EXPERIENCE

Confidential

Lead Teradata DBA

Responsibilities:

  • Performance Tuning for long running queries and failed queries.
  • Creating Databases, Users and Other database objects.
  • Working on failed jobs during loads, data movement between environments.
  • Working on spool space issues and Stats recommendation and re defining if required.
  • Space moving and recovering by cleanup unwanted tables all the time.
  • Access Managements for all level of users and granting access accordingly.
  • Create and grant ROLES to the users as per the requirement.
  • Reviewed DDL and migrations till production.
  • Reviewed Objects and code as per the Teradata Best Practices.
  • Performance improvement suggestions and implementation
  • Attended the calls with data Architect to get the knowledge on data models.
  • Building the views in semantic layer.
  • Created the Teradata bteq scripts, TPT Scripts, Fastload, Multiload and Fastexport scripts.
  • Written the complex sqls for reporting.
  • Created and defined DDL’s for the tables at staging area.
 

Environment: Teradata 15.00, TD16.20, UNIX, Linux,SSIS, ActiveBatch and Windows

 

Confidential, Maryland heights, MO

Teradata DBA

Responsibilities:

  • Load monitoring using dash board, and working on failed loads (Tables for reports)
  • Fine tuning queries before deploy in production
  • Moving Space according to requirement within the environment.
  • Moving data between environments according to the requirements.
  • Worked closely with Architects/Modelers for launching new tables
  • Identified key areas in the ETL frame work where performance improvement needed.
  • Identifying the highly skewed tables and worked with modelers to redefine Indices
  • Working on JIRA Tickets and adhoc requests through e-mails.
  • Used Teradata Administrator and View Point Tools for monitoring and control the system.
  • Involved in DDLs migrations between environments.
  • Performance tuning, monitoring and reporting review system utilization by user.
  • Break fixes, table fixes, monitor on load failures, backup and archive activities on demand.
  • Created and granted ROLES to the users as per the requirement.

Environment: Teradata TD16.00, UNIX, Linux, and Windows

Confidential, Bloomfield, CT

Teradata DBA

Responsibilities:

  • Code review for ESP jobs for ad-hoc loads which are failed in regular jobs.
  • Performance improvements for reporting views (reporting view layer).
  • Creating tickets for any code changes, migrations and, code enhancements.
  • Fine tuning queries before deploy in production.
  • Looker dash Board creation for different reports and managing.
  • User story requests solving.
  • ETL code migration between environments till production implementation.
  • Involved in DDLs migrations, space requests and DDLs Version implementations.
  • Used Teradata Administrator and View Point Tools for monitoring and control the system.
  • Attending release management meetings and working with them till production deployment.
  • Performance tuning, monitoring and reporting review Looker Dash board utilization by users.

Environment: Teradata 15.00, UNIX, Linux, python, Informatica and Windows

Confidential

Teradata DBA

Responsibilities:

  • Load monitor from dash board, csv file loads and data loads for common tables (Maintenance tables).
  • TPT preparations for ad-hoc loads which are failed in regular jobs.
  • Worked on reporting views (aggregated view layer).
  • Creating tickets for any code changes, code enhancements.
  • Fine tuning queries before deploy in production.
  • As a Teradata DBA involved full support in different environments like DEV, TEST,UST and PROD.
  • Database creation for different purposes. Creating and managing user profiles and accounts.
  • Ticket solving using HPALM and HPSM.
  • Moving Space according to requirement with in the environment.
  • Moving data between environments according to the requirements.
  • Involved in DDLs migrations, space allocations and DDLs Version implementations.
  • Used Teradata Administrator and View Point Tools for monitoring and control the system.
  • Data movement and implementation of database and table-level security, setting up access rights for various Teradata environments.
  • Performance tuning, monitoring and reporting review system utilization by user.
  • Involved in end to end DBA activities Life Cycle of different applications.

Environment: Teradata 14.00, UNIX, Linux and Windows

Confidential, Dublin, OH

Teradata DBA

Responsibilities:

  • Performance tuning of Teradata code, analyzing the explain plan and determining which column/index/table needed to collect statistics, improved the performance up to 40%-50%.
  • Analyzed the skew ness and suggested the changes to Primary Index at the time of development to resolve the performance bottle necks.
  • Involved in preparing Physical Data Model (PDM).
  • Worked closely with Modelers while creating physical tables.
  • Capacity planning based on project planning.
  • Analyzed the space requirement and assigning and recovering.
  • Database / Users / Other objects creations.
  • Space assignment and recovering.
  • Granted Access Rights between databases.
  • Created and granted ROLES to the users as per the requirement.
  • Reviewed DDL for the objects.
  • Published the DDLs into repository.
  • Reviewed Objects and code as per the Teradata Best Practices.
  • Stats recommendation and defining.
  • Performance improvement suggestions and implementation.
  • System monitoring completing daily basis incidents from multiple application teams.
  • Designed and Developed Informatica mappings, mapplets, sessions and workflows for data Loads.
  • Did migration of the code between environments having all the components in sync.

Environment: Teradata 14.0, unix, Control-M

Confidential, Phoenix, AZ

Lead Teradata DBA

Responsibilities:

  • Database / Users / Other objects creations.
  • Space assignment and recovering.
  • Granted Access Rights between databases.
  • Created and granted ROLES to the users as per the requirement.
  • Reviewed DDL for the objects.
  • PI Selection attributes.
  • Published the DDLs into repository.
  • Reviewed Objects and code as per the Teradata Best Practices.
  • Stats recommendation and defining.
  • Performance improvement suggestions and implementation
  • Discussed the requirements with client.
  • Attended the calls with data Architect to get the knowledge on data models.
  • Involved in preparing the low-level technical design documents.
  • Building the views in semantic layer.
  • Created the Teradata bteq scripts, Fastload, Multiload and Fastexport scripts.
  • Written the complex sqls using OLAP functions.
  • Created and defined DDL’s for the tables at staging area.

Environment: Teradata 12, TD13.0, TD 13.10, UNIX, Linux and Windows

Confidential, Virginia, VA

Lead Teradata DBA

Responsibilities:

  • As a Teradata DBA involved in user creations, DDL implementation, code migration, scheduling and monitoring load jobs.
  • Implementation of database and table-level security, setting up access rights for Teradata environments.
  • Performance tuning, monitoring and reporting review system utilization by user.
  • Involved in work load management by balancing workloads for optimal performance.
  • Space management, capacity planning for feature trends based on existing trends.
  • Scheduling backups and other database maintenance activities.
  • View point monitoring, alerting Outages during patch-ups, upgrades
  • Creating and managing user profiles and accounts.
  • Granting privileges and access rights according to requirements.
  • Monitoring and controlling the system using Teradata Administrator and View point Tools.
  • Database clean ups and production implementations during project releases.

Environment: Teradata 13.0, TD 13.10, UNIX, Linux and Windows

Hire Now