We provide IT Staff Augmentation Services!

Teradata Dba Resume

Atlanta, GA

SUMMARY

  • Teradata 12 Certified with over 11 + years of experience supporting data warehouses residing on Teradata used all Teradata utilities (Multiload, Fastload, Fastexport, BTEQ, Queryman, TD Manager, PMON, SQL Assistant, Visual explain,arcmain) extensively.
  • Extensive experience in Administration and maintenance of Dev, Stage, prod and standby databases for DSS and Data Warehousing environment
  • Experienced in UNIX Shell scripting as part of file manipulation and text processing.
  • Good experience with Teradata query performance and tuning using collect statistics and secondary indexes.
  • Monitoring Teradata perm space for availability and monitor Teradata CPU/Load utilization.
  • Experienced in Dynamic workload and Resource Management using viewpoint and TDWM
  • Programming experience in Teradata SQL.
  • Expertise in Application Development with knowledge of full software development life cycle.
  • Proficient in complex Data Warehousing concepts including in Data mart and Data Mining using Dimension Modeling (Star Schema, Snow - Flake Schema Design and Normalized structures (3NF)).
  • Proficient in using Teradata Administrator for managing Databases, Users, Tables, Indexes, statistics, managing permissions (Roles & Profiles), addressing the user issues such as resetting passwords, unlocking user ID’s etc.
  • Hands on working with Teradata Viewpoint as a part of eyes on glass activity monitoring and aborting bad queries, looking for blocked sessions and working with development teams to resolve blocked sessions system tuning capacity planning

TECHNICAL SKILLS

Tools: &Utilities: viewpoint, Teradata Administrator, Teradata SQL Assistant, BTEQ, MLOAD, TPT, PMON, Teradata Manager, informatica 9, Teradata Administrator, Teradata manager, SQL Server management studio, Erwin data modeler tool

Databases: Teradata 15/14/12, MS SQL Server 2005

Languages: SQL, Unix Shell scripting, bteq

Technologies: Data Warehousing

Operating Systems: Windows 95/98/2000/2003/ XP/Vista/7, Sun Solaris 5.6, UNIX-

PROFESSIONAL EXPERIENCE

Confidential, ATLANTA, GA

Teradata DBA

Responsibilities:

  • Responsible for Teradata SQL Tuning and System Performance tuning of whole system interpretation of PDCR Reports in order to determine causes of poor performing code
  • Advising developers and development teams from design through build phase
  • Conducted several sessions with key business analysts to get the requirements related Reports, KPIs capacity planning of system system performance tuning
  • Performed extensive Data Profiling on the source data by loading the data sample into Database using Database Load Utilities.
  • Worked with Data Modelers to create a star schema model for the above subject areas and made sure that all the requirements can be generated from the models created.
  • Created High level and detail design documents for above data mart projects containing process flows, mapping document, initial and delta load strategies, Surrogate key generation, Type I and Type II-dimension loading, Balance and control, Exception processing, Process Dependencies and scheduling.
  • Identified the required dependencies between ETL processes and triggers to schedule the Jobs to populate Data Marts on scheduled basis.
  • Backing up data using Netvault
  • Designed and coordinated the backfill process to load data into Data Marts.
  • Worked with DBA team to ensure implementation of the databases for the physical data models intended for the above data marts. Created proper Teradata Primary Indexes (PI) taking into consideration of both planned access of data and even distribution of data across all the available AMPS. Considering both the business requirements and factors, created appropriate Teradata NUSI for smooth (fast and easy) access of data.
  • Created proper Teradata Primary Indexes (PI) taking into consideration of both planned access of data and even distribution of data across all the available AMPS. Considering both the business requirements and factors, created appropriate Teradata NUSI for smooth (fast and easy) access of data.
  • Extensively used the Teradata utilities like BTEQ, FastLoad, MultiLoad, DDL Commands and DML Commands (SQL).
  • Created several BTEQ scripts involving derived tables and volatile/Global temporary tables for adhoc purpose to extract data for several business users on scheduled basis.
  • Involved in the collection of statistics on important tables to have better plan from Teradata Optimizer.
  • Did the performance tuning of user queries by analyzing the explain plans, recreating the user driver tables by right primary Index, scheduled collection of statistics, secondary or various join indexes.
  • Implemented data level, object level and package level security in framework manager to achieve highly complex security standards.
  • Created Master Detail reports, drill through and custom prompting reports, and Scheduled reports for efficient resource utilization.
  • Created Query Prompts, calculations, Conditions & Filters. Developing Prompt pages and Conditional Variables. Involved in Testing and improving Report Performance.
  • Involved in analysis of Extraction, Transformation and Loading ETL process.
  • Involved in creation of the mappings between sources and target tables.
  • Used different transformation like Expression, Aggregator, and Source Qualifier, Sequence Generator, Filter, Router, Update strategy and Lookup Transformations.
  • Involved in Unit testing as well as Functional testing, Performance Tuning of Queries.
  • Created staging Tables, Indexes, Sequences, Views and performance tuning like analyzing tables, proper indexing.
  • Identifying and resolving the bottlenecks in source, target, transformations, mappings and sessions to improve performance.
  • Back up restore copy using archmain

Environment: Teradata 14/15, Oracle 9i, Maestro Scheduler, Teradata SQL Assistant, FastLoad, MultiLoad, Teradata Administrator, BTEQ, UNIX, Informatica 9, ERWIN data modelling tool

Confidential, Richardson, TX

Teradata DBA

Responsibilities:

  • Conducted several sessions with key business analysts to get the requirements related Reports, KPIs
  • Performed extensive Data Profiling on the source data by loading the data sample into Database using Database Load Utilities.
  • Worked with Data Modelers to create a star schema model for the above subject areas and made sure that all the requirements can be generated from the models created.
  • Created High level and detail design documents for above data mart projects containing process flows, mapping document, initial and delta load strategies, Surrogate key generation, Type I and Type II dimension loading, Balance and control, Exception processing, Process Dependencies and scheduling.
  • Identified the required dependencies between ETL processes and triggers to schedule the Jobs to populate Data Marts on scheduled basis.
  • Designed and coordinated the backfill process to of the data into Data Marts.
  • Worked with DBA team to ensure implementation of the databases for the physical data models intended for the above data marts. Created proper Teradata Primary Indexes (PI) taking into consideration of both planned access of data and even distribution of data across all the available AMPS. Considering both the business requirements and factors, created appropriate Teradata NUSI for smooth (fast and easy) access of data.
  • Created proper Teradata Primary Indexes (PI) taking into consideration of both planned access of data and even distribution of data across all the available AMPS. Considering both the business requirements and factors, created appropriate Teradata NUSI for smooth (fast and easy) access of data.
  • Extensively used the Teradata utilities like BTEQ, FastLoad, MultiLoad, DDL Commands and DML Commands (SQL).
  • Created several BTEQ scripts involving derived tables and volatile/Global temporary tables for adhoc purpose to extract data for several business users on scheduled basis.
  • Involved in the collection of statistics on important tables to have better plan from Teradata Optimizer.
  • Did the performance tuning of user queries by analyzing the explain plans, recreating the user driver tables by right primary Index, scheduled collection of statistics, secondary or various join indexes.
  • Implemented data level, object level and package level security in framework manager to achieve highly complex security standards.
  • Created Master Detail reports, drill through and custom prompting reports, and Scheduled reports for efficient resource utilization.
  • Created Query Prompts, calculations, Conditions & Filters. Developing Prompt pages and Conditional Variables. Involved in Testing and improving Report Performance.
  • Involved in analysis of Extraction, Transformation and Loading ETL process.
  • Involved in creation of the mappings between sources and target tables.
  • Used different transformation like Expression, Aggregator, and Source Qualifier, Sequence Generator, Filter, Router, Update strategy and Lookup Transformations. creating directory structures in Linux environment for system creating different file structures and assigning them permission
  • Involved in Unit testing as well as Functional testing, Performance Tuning of Queries.
  • Created staging Tables, Indexes, Sequences, Views and performance tuning like analyzing tables, proper indexing.
  • Identifying and resolving the bottlenecks in source, target, transformations, mappings and sessions to improve performance.

Environment: Teradata 14, Oracle 9i, Maestro Scheduler, Teradata SQL Assistant, FastLoad, MultiLoad, Teradata Administrator, BTEQ, UNIX, Informatica 9

Confidential

Teradata DBA

Responsibilities:

  • Managing database space, allocating new space to database, moving space between databases as need basis.
  • Creating roles and profiles as needed basis. Granting privileges to roles, adding users to roles based on requirements.
  • Extensively worked with DBQL data to identify high usage tables and columns.
  • Use of Teradata Manager, BTEQ, FASTLOAD, MULTILOAD, TPUMP, SQL and TASM for workload management.
  • Monitoring bad queries, aborting bad queries using PMON, looking for blocked sessions and working with development teams to resolve blocked sessions.
  • Perform workload management using various tools like Teradata Manager, Fast Load, Multi Load, TPUMP, TPT, SQL Assistant.
  • Used External Loaders like Multi Load, T Pump and Fast Load to load data into Teradata Database. Involved in analysis, development, testing, implementation and deployment.
  • Monitoring the load on different database servers.
  • Investigation and solution of different requests/issues coming through Problem Management Tool (Remedy) from end users.
  • Provide support to Daily, Weekly and Monthly ETL activities during the ETL cycle
  • Evaluate and implement as appropriate Teradata features to improve performance and reduce Teradata resource utilization.
  • Perform query tuning to reduce Teradata resource consumption and shorten response time, including partitioning, index creation and alteration and also performance tuning that is specific to applications - solve spool out and long running query issues
  • Perform data-backup for tables during truncation and then reload the data back to base table after obtaining business approval user access requests to databases for duplication and relevant environments; report findings to business and IBM Teradata System DBAs
  • Designing of database
  • Use of Mload, fastload, for loading data
  • Migration

Environment: Teradata 12, Oracle 9i, Maestro Scheduler, Teradata SQL Assistant, FastLoad, MultiLoad, Teradata Administrator, BTEQ,, UNIX, Informatica 8.5,Teradata Viewpoint,BTEQ.

Confidential

Teradata DBA

Responsibilities:

  • Conducted several sessions with key business analysts to get the requirements related Reports, KPIs
  • Performed extensive Data Profiling on the source data by loading the data sample into Database using Database Load Utilities.
  • Worked with Data Modelers to create a star schema model for the above subject areas and made sure that all the requirements can be generated from the models created.
  • Created High level and detail design documents for above data mart projects containing process flows, mapping document, initial and delta load strategies, Surrogate key generation, Type I and Type II dimension loading, Balance and control, Exception processing, Process Dependencies and scheduling.
  • Identified the required dependencies between ETL processes and triggers to schedule the Jobs to populate Data Marts on scheduled basis.
  • Designed and coordinated the backfill process to load 3 to 5 years of the data into Data Marts.
  • Worked with DBA team to ensure implementation of the databases for the physical data models intended for the above data marts. Created proper Teradata Primary Indexes (PI) taking into consideration of both planned access of data and even distribution of data across all the available AMPS. Considering both the business requirements and factors, created appropriate Teradata NUSI for smooth (fast and easy) access of data.
  • Created proper Teradata Primary Indexes (PI) taking into consideration of both planned access of data and even distribution of data across all the available AMPS. Considering both the business requirements and factors, created appropriate Teradata NUSI for smooth (fast and easy) access of data.
  • Extensively used the Teradata utilities like BTEQ, FastLoad, MultiLoad, DDL Commands and DML Commands (SQL).
  • Created several BTEQ scripts involving derived tables and volatile/Global temporary tables for adhoc purpose to extract data for several business users on scheduled basis.
  • Involved in the collection of statistics on important tables to have better plan from Teradata Optimizer.
  • Did the performance tuning of user queries by analyzing the explain plans, recreating the user driver tables by right primary Index, scheduled collection of statistics, secondary or various join indexes.
  • Implemented data level, object level and package level security in framework manager to achieve highly complex security standards.
  • Created Master Detail reports, drill through and custom prompting reports, and Scheduled reports for efficient resource utilization.
  • Created Query Prompts, calculations, Conditions & Filters. Developing Prompt pages and Conditional Variables. Involved in Testing and improving Report Performance.
  • Involved in analysis of Extraction, Transformation and Loading ETL process.
  • Involved in creation of the mappings between sources and target tables.
  • Used different transformation like Expression, Aggregator, and Source Qualifier, Sequence Generator, Filter, Router, Update strategy and Lookup Transformations.
  • Involved in Unit testing as well as Functional testing, Performance Tuning of Queries.
  • Created staging Tables, Indexes, Sequences, Views and performance tuning like analyzing tables, proper indexing.
  • Identifying and resolving the bottlenecks in source, target, transformations, mappings and sessions to improve performance.

Environment: Teradata V2R5, Oracle 9i, Maestro Scheduler, Teradata SQL Assistant, FastLoad, MultiLoad, Teradata Administrator, BTEQ, UNIX, Informatica 8.5, Teradata Viewpoint, BTEQ

Confidential

Teradata dba

Responsibilities:

  • Managing database space, allocating new space to database, moving space between databases as need basis.
  • Creating roles and profiles as needed basis. Granting privileges to roles, adding users to roles based on requirements.
  • Extensively worked with DBQL data to identify high usage tables and columns.
  • Use of Teradata Manager, BTEQ, FASTLOAD, MULTILOAD, TPUMP, SQL and TASM for workload management.
  • Monitoring bad queries, aborting bad queries using PMON, looking for blocked sessions and working with development teams to resolve blocked sessions.
  • Perform workload management using various tools like Teradata Manager, Fast Load, Multi Load, TPUMP, TPT, SQL Assistant.
  • Used External Loaders like Multi Load, T Pump and Fast Load to load data into Teradata Database. Involved in analysis, development, testing, implementation and deployment.
  • Monitoring the load on different database servers.
  • Investigation and solution of different requests/issues coming through Problem Management Tool (Remedy) from end users.
  • Provide support to Daily, Weekly and Monthly ETL activities during the ETL cycle
  • Evaluate and implement as appropriate Teradata features to improve performance and reduce Teradata resource utilization.
  • Perform query tuning to reduce Teradata resource consumption and shorten response time, including partitioning, index creation and alteration and also performance tuning that is specific to applications - solve spool out and long running query issues
  • Perform data-backup for tables during truncation and then reload the data back to base table after obtaining business approval user access requests to databases for duplication and relevant environments; report findings to business and IBM Teradata System DBAs
  • Designing of database
  • Use of Mload, fastload, for loading data

Environment: Teradata V2R5, Oracle 9i, Maestro Scheduler, Teradata SQL Assistant, FastLoad, MultiLoad, Teradata Administrator, BTEQ, UNIX, Informatica 8.5, Teradata Viewpoint, BTEQ

Confidential

Teradata DBA

Responsibilities:

  • Managing database space, allocating new space to database, moving space between databases as need basis.
  • Creating roles and profiles as needed basis. Granting privileges to roles, adding users to roles based on requirements.
  • Extensively worked with DBQL data to identify high usage tables and columns.
  • Use of Teradata Manager, BTEQ, FASTLOAD, MULTILOAD, TPUMP, SQL and TASM for workload management.
  • Monitoring bad queries, aborting bad queries using PMON, looking for blocked sessions and working with development teams to resolve blocked sessions.
  • Perform workload management using various tools like Teradata Manager, Fast Load, Multi Load, TPUMP, TPT, SQL Assistant.
  • Used External Loaders like Multi Load, T Pump and Fast Load to load data into Teradata Database. Involved in analysis, development, testing, implementation and deployment.
  • Monitoring the load on different database servers.
  • Investigation and solution of different requests/issues coming through Problem Management Tool (Remedy) from end users.
  • Provide support to Daily, Weekly and Monthly ETL activities during the ETL cycle
  • Evaluate and implement as appropriate Teradata features to improve performance and reduce Teradata resource utilization.
  • Perform query tuning to reduce Teradata resource consumption and shorten response time, including partitioning, index creation and alteration and also performance tuning that is specific to applications - solve spool out and long running query issues
  • Perform data-backup for tables during truncation and then reload the data back to base table after obtaining business approval user access requests to databases for duplication and relevant environments; report findings to business and IBM Teradata System DBAs
  • Designing of database
  • Use of Mload, fastload, for loading data

Environment: Teradata V2R5, Oracle 9i, Maestro Scheduler, Teradata SQL Assistant, FastLoad, MultiLoad, Teradata Administrator, BTEQ, UNIX, Informatica 8.5, Teradata Viewpoint, BTEQ

Hire Now