We provide IT Staff Augmentation Services!

Teradata Dba Resume

4.00 Rating

SUMMARY

  • Over 8 years of Information Technology and 6 years in Teradata administration experience, Extensive experience in design, development, and implementations in Data Warehousing solutions building Enterprise Data Warehouses and Data Marts.
  • Able to understand business and technical requirements quickly, Excellent communications skills and work ethics and able to work independently, Experience working with clients of all sizes in the insurance, financial, healthcare and retail industries.
  • Having good experience in Analyzing and worked on ETL side using Informatica Powercenter, and build the ETL applications based on clients requirement.
  • 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)).
  • Analyzed, designed, modeled and migrated multiple data systems from various sources to both OLTP and OLAP (Staging, Data Warehouse, Star Schemas and various Business Intelligence tools)
  • Over 6 years of experience in Teradata Database Administration, used all Teradata tools and utilities (View Point, Mload,Fload, Fexport, Bteq, TD Manager, PMON, Teradata Admin, TASM, SQL Assistant, DBQL, Visual explain, Index wizard, RESUSAGE, Macro’s, DBC. Tables, TPT, Tpump) extensively.
  • Good experience with Teradata query performance and tuning using Resusage data, DBQL, collect statistics and JI's, PPI's, etc.
  • Having good experience in end-to-end Teradata DBA support which includes daily routine DBA activities, project code reviews (DDL and performance checks of ETL code).
  • 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, dBs control etc.), PDCR, DBQL, Capacity Planning and applying Agile (SCRUM) methodologies for BI projects.
  • Creating database objects and maintaining access rights.
  • Experience in capacity planning and maintenance.
  • Proactively monitoring database space, Identifying highly skewed tables and changing the indexing strategies.

PROFESSIONAL EXPERIENCE

Confidential

Teradata DBA

Responsibilities:

  • Creating databases, users in dev, test and production environments.
  • Designed, developed, optimized and maintained database objects like tables, views, indexes, soft RI, common procedure macro etc. Testing and implementation of systems.
  • Creating roles and profiles as needed basis. Granting privileges to roles, adding users to roles based on requirements.
  • Managing database space, allocating new space to database, moving space between databases as needed basis.
  • Proactively monitoring bad queries, aborting bad queries using PMON, looking for blocked sessions and working with development teams to resolve blocked sessions.
  • Proactively monitoring database space, Identifying tables with high skew, working with data modeling team to change the Primary Index on tables with High skew.
  • Worked on moving tables from test to production using fast export and fast load.
  • Extensively worked with DBQL data to identify high usage tables and columns.
  • Implemented secondary indexes on highly used columns to improve performance.
  • Good experience with query performance and tuning. Extensively used explain plans, visual explain to understand optimizer plans, created various NUSI index as needed bases, also used Statistics wizard, QCD, Index Wizard for collecting stats and recommending indexes.
  • Developed various DBQL reports such as top 10 queries with high CPU, Top 10 queries with high.
  • Implemented various Teradata alerts using Alert facility in Teradata Manager. Involved in setting up alters to page DBA for events such as node down, AMP down, too many blocked sessions, high data skew etc.
  • Used Teradata Manager collecting facility to setup AMP usage collection, canary query response, spool usage response etc.
  • Worked on capacity planning, reported disk and CPU usage growth reports using Teradata Manager, DBQL, Resusage.
  • Worked on exporting data to flat files using Teradata FEXPORT.
  • Written several Teradata BTEQ scripts to implement the business logic.
  • Populated data into Teradata tables by using Fast Load utility.
  • Created Teradata complex macros and Views and stored procedures to be used in the reports.

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.
  • Addressing day to day users issues such as resetting passwords, unlocking used id’s, working on permission issues.
  • Monitoring bad queries, aborting bad queries using PMON, looking for blocked sessions and working with development teams to resolve blocked sessions.
  • Tuning bad queries by analysing explain plans, visual explain to understand optimizer plans, created various NUSI index as needed bases, also used Statistics wizard, QCD, Index Wizard for collecting stats and recommending indexes.
  • Extensively worked with DBQL data to identify high usage tables and columns.
  • Redesigning the Logical Data Models, and Physical Data Models.
  • Developed Backup and Recovery procedures for Development, Testing and Production Servers.
  • Supported production processes, user queries, and software upgrade installation.
  • Participated in DBA on call rotation to support production system during off hours.
  • Working with developers to resolve issues with load utilities such as FastLoad, MultiLoad, TPump and BTEQ, Worked on moving tables from test to production using fast export and fast load.

Confidential

Teradata DBA

Responsibilities:

  • Multiload, BTEQ, created & modified databases, performed capacity planning, allocated space, granted rights for all objects within databases, etc.
  • Used Teradata Administrator and Teradata Manager Tools for monitoring and control the system.
  • Designed, developed, optimized and maintained database objects like tables, views, indexes, soft RI, common procedure macro etc. Testing and implementation of systems.
  • Creating roles and profiles as needed basis. Granting privileges to roles, adding users to roles based on requirements.
  • 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, Fast load, Multiload, TPump, DDL Commands and DML Commands (SQL). Created various Teradata Macros in SQL Assistant for to serve the analysts.
  • Assist developers, DBAs in designing, architecture, development and tuning queries of the project. This included modification of queries, Index selection, and refresh statistic collection.
  • Worked on moving tables from test to production using fast export and fast load.
  • Extensively worked with DBQL data to identify high usage tables and columns.
  • Implemented secondary indexes on highly used columns to improve performance
  • Developed various DBQL reports such as top 10 queries with high CPU, Top 10 queries with high
  • Worked on exporting data to flat files using Teradata FEXPORT.
  • Written several Teradata BTEQ scripts to implement the business logic.
  • Populated data into Teradata tables by using Fast Load utility.
  • Created Teradata complex macros and Views and stored procedures to be used in the reports.

Confidential

Teradata DBA

Responsibilities:

  • Creating roles and profiles as needed basis. Granting privileges to roles, adding users to roles based on requirements.
  • Tune Query from business users to make their reports reach them sooner.
  • Creating Users and Databases.
  • Complete TASM expertise in analyzing the existing workloads using Teradata workload analyzer, designing, adjusting & monitoring the workloads using Workload Designer and Workload Monitor port lets.
  • Proficiency in appropriate usage of CNS utilities, Checktable, Packdisk, Scandisk, rcvmanager, qrysession, DBScontrol, Teradata Application and Database Administration, load & unload utilities namely SQL Assistant, Administrator/Winddi, PMON, Viewpoint, Teradata Manager, TASM, TSET, Priority Scheduler, Multiload, Fastload, FastExport.
  • Good experience in using Teradata Security features, like LDAP mechanism, Database views, Roles, Users, Password restriction using profiles and access rights.
  • Designing, creating and tuning physical database objects (tables, views, indexes) to support normalized and dimensional models. Maintain and enhance database performance using Teradata Manager, Performance Monitor, and TASM.
  • Assist developers in tuning SQL and maintains appropriate Priority Scheduler profiles, allocation groups, and workloads.
  • Work with ETL leads to formulate ETL approach and appropriate use of Teradata Tools and Utilities including Fastload, Multiload, TPump, and SQL Assistant.
  • Responsible for runtime optimization, capacity management and planning, security, configuration, scheduling, and execution of maintenance utilities.
  • BAR activities (Backup and Recovery) using NetBackup (TD12) and TaraGUI.
  • Managed and implemented database objects (tables, indexes, statistics) resulting in efficient and successful database implementations as Teradata Database Administrator.
  • Configured and implemented the Teradata TASM product, working in a team setting, to implement load balancing which improved database performance and throughput.

Confidential

ETL Informatica Developer

Responsibilities:

  • Involved in Joint Application Development (JAD) sessions with Business Analysts, System Analysts, ETL and BI Developers for performing data analysis and gathering business requirements.
  • Developed technical specification documents TSD for developers to easily understand the ETL process flow.
  • Designed the Source - Target mappings and involved in designing the selection criteria document.
  • Extensively used ETL to load data from Oracle and Flat files.
  • Used Informatica Power Center 8x,9x to create mappings, sessions and workflows for populating the data into dimension, fact, and lookup tables from various source systems like DB2, Oracle, Flat files etc..
  • Created mappings using various Transformations like Source Qualifier, Aggregator, Expression, Filter, Router, Joiner, Stored Procedure, Lookup, Update Strategy, Sequence Generator and Normalizer.
  • Extensively used Mapping Variables, Mapping Parameters to execute complex business logic.
  • Designing the dimensional model and data load process using SCD Type II for the quarterly membership reporting purposes.
  • Done source system analysis and end to end coding with ETL Mapping / Source to Target mapping, BTEQ scripts, Fast Export, shell scripting as per the Business requirements.
  • Strong hands on experience using Teradata utilities (SQL, B-TEQ, Fast Load, MultiLoad, FastExport, Tpump, Visual Explain, Query man, TPT).
  • Loaded the data into the Teradata database using Load utilities like (Fast Export, Fast Load, MultiLoad, and TPT).
  • Used debugger in identifying bugs in existing mappings by analyzing data flow.
  • Responsible for Unit Testing, System Integration Testing and validation of data for all the reports that are generated using Cognos.
  • Worked closely with System Admins for User/Developer Access, etc.
  • Installation and configuration of Informatica Power Center Server, Power Center Client on Oracle Linux and Windows servers/desktops in non-Prod environments.
  • Implemented various levels of email notifications including successful completion, failure, etc., using Control-M scheduler.

Environment: Informatica Power center 8.5, Oracle 10g, Unix, Windows, Cognos,Teradata.

We'd love your feedback!