We provide IT Staff Augmentation Services!

Teradata Dba Resume

2.00 Rating

St, LouiS

SUMMARY

  • Around 7 years of experience in Teradata Database Administration, Design, Documentation, Implementation and Maintenance mainly in large scale Data Warehouse Environment.
  • Experience working with clients of all sizes in the Retail, Healthcare, Pharma, Banking and Entertainment industries.
  • Good understanding of Data Warehousing concepts such as Third Normal Form as well as Dimensional Schema.
  • Expert in tuning complex Teradata SQL Queries including Views, Joins and Sub queries.
  • Developed Teradata features such as PPI, Character PPI, Timestamp PPI and Columnar Tables.
  • Having good experience in Teradata Appliance/Enterprise Server, SLES, Viewpoint, BAR, TASM/TDWI and SWS.
  • Expert DBA skills in Teradata DBMS Administration, Development and Production DBA support.
  • Used FASTLOAD, MULTILOAD, TPT, TPUMP, PDCR, ARCMAIN and TASM.
  • Developed views and implemented different types of indexes such as UPI, NUPI, USI and NUSI, PPI, JI and AJI.
  • Developed the DDL’s as per Teradata standards in terms of performance gain.
  • Created and implemented BAR Strategy for the TD application and system database.
  • Plan, schedule and support Teradata migration, upgrades and Teradata Floor Sweeps.
  • Performed Teradata SQL troubleshooting and fine tuning of scripts given by developers.
  • Extensive experience working on Appliance (1x, 2x) and Enterprise (5x, 6x) data mart and data warehouse platforms.
  • Implemented Teradata 14.10 Smart Stats, Auto stats, collection of statistics for the indexes and for some of the columns involved in join conditions.
  • Implemented multi - value compression and BLC on tables for space savings.
  • Managed multi-terabyte, multi-application environments involving multiple workloads.
  • Extensively worked on Teradata View point to monitor the systems, setting the alerts and implemented TASM.
  • Used Teradata PDCR to generate various performance and system related reports for CPU/ IO/DISKSPACE.
  • Performed regular DBA activities like creating databases, users, tables, views, macros, procs, profiles, roles, grant/ revoke permissions, checking the table’s skew, space management (spool, temporary, permanent space) and troubleshooting the failure jobs.
  • Participated in DBA on call rotation to support production system during off hours.
  • Involved in interacting with clients and understanding the business process, requirements analysis, identifying potential usability issues, managing scope, implementing operating standards and maintaining technical documentations.

TECHNICAL SKILLS

ETL Tools: MLOAD, FLOAD, TPUMP, TPT, FAST EXPORT, SSIS, Informatica

Data Modeling: Physical Modelling, Logical Modelling, Relational Modelling, Dimensional Modelling

Databases: Teradata 15.10, 14.10, 13.10, 13.0, Teradata V2R6, V2R12, Oracle 11g/10g/9i

Languages: Teradata SQL, PL/SQL

Operating Systems: Windows, SUSE-Linux

Reporting Tools: Business Objects, SSRS, Tableau

Tools: SQL plus, TARA GUI, TASM, Teradata SQL Assistant, Teradata FastExport, Fastload, Mload, Tpump, Teradata Manager, Teradata Administrator, Workload Manager, Teradata Viewpoint

PROFESSIONAL EXPERIENCE

Confidential, St. Louis

Teradata DBA

Responsibilities:

  • Involved in Complete Software Development Lifecycle Experience (SDLC) from Business Analysis to Development, Testing, Deployment and Documentation.
  • Interacted with clients, Industry data modelers and data analysts to develop the logical to physical design for tables.
  • Involved in the tasks such as creation of users, allocating spool, temporary and permanent space, creation of tables, collecting stats, checking the tables skew.
  • Created users with different profiles and roles to control the access on the system.
  • Experienced in designing database with prominent activities like deciding Primary / Secondary index, creating Join index, creating Partitioned Primary Index.
  • Implemented automatic data protection using Recovery Journals and Fallback protection.
  • Used MVC and BLC for space savings of the database.
  • Manage the Teradata ETL loads using tools like Teradata Parallel Transport (TPT Load, Update and stream operator) traditionally Fast Load, Multi Load, Tpump and Fast Export.
  • Troubleshooting the failure ETL/ELT jobs.
  • Troubleshooting MainFrame JCL Jobs and process adhoc load requests to support UAT and Development efforts.
  • Assist developers to Optimize queries and build complex logic using BTEQ and Store procedures.
  • Optimizing/Tuning complex SQL queries.
  • Use the Teradata temporal data type to design time share analysis requirements
  • Build Shell scripts and call Teradata procedures.
  • Experienced in Viewpoint to create alerts and monitor system/Application activities.
  • Reviewing Explain plan to recommend collect stats, Indexes to improve the performance.
  • Worked on Unix Scripts/JCL to load source data into target tables and for backup data retention.
  • Support Incident Tickets and troubleshoot and resolve database incidents within SLAs.
  • Worked on exporting data to flat files using Teradata FASTEXPORT.
  • Managed multi-terabyte, multi-application environment involving multiple workloads.
  • Addressed day to day application issues such as resetting passwords, skew, Query performance, Data migration and unlocking used id’s and worked on permission issues.
  • Capacity planning and proactive monitoring to meet performance and data growth requirements
  • Experienced with Backup and Recovery using Teradata ARCMAIN and Net backup TARA and mask the restricted data (like PII and ERS)
  • Used Teradata ViewPoint to monitor system and, if necessary, abort long-running or highly-skewed queries.
  • Also used Teradata ViewPoint to change the workload of queries when they are in the penalty box too long.

Confidential

Informatica Developer

Responsibilities:

  • Understanding the requirements and performing the development scope analysis.
  • Involved in Analysis, Documentation and Testing of workflows.
  • Performed extensive data analysis to determine trends and patterns as well as identify root causes for data discrepancies
  • Used ETL to extract and load data from Oracle, Flat Files to Oracle DWH.
  • Developed Informatica Mappings to capture data changes from operational sources systems into data warehouse and data marts (SCD mappings).
  • Created various complex transformations such as Update Strategy, Look up, Filter and Router Transformations.
  • Converted all Oracle ETL Packages to Informatica Mappings and created workflows/Sessions
  • Created basic and aggregate level of Fact table mapping and optimized them for incremental Extraction and Aggregation using Parameters and variables to pass values during workflow execution.
  • Handling structured and unstructured data and applying ETL processes.
  • Created Workflows/ Worklets and scheduled them using workflow manager.
  • Developed Mappings to load data in slowly changing dimensions.
  • Ensuring proper Dependences and proper running of loads.
  • Performance tuning of sessions and mappings.

Confidential

Teradata Database Application Administrator

Responsibilities:

  • Support incident tickets and troubleshoot and resolve database incidents within SLAs.
  • Redesigned and optimized the existing Physical DM by defining the right PIs.
  • Implemented Multi Valued Compression and Block Level Compression using Ferret Utility on cold data.
  • Performance Tuning to reduce CPU, IO and spool utilization thus reduce the Impact CPU, CPU Skew, IO Skew on the box.
  • Created users, roles and profiles in accordance with Enterprise security standards.
  • Extensively worked in identifying the highly skewed tables and analyzed and redefined the index.
  • Executed Teradata SQL Scripts for multiple purposes such as creating Databases, Tables, Views, Joins, Primary and Secondary Indices, STJI, MTJI, AJI, Macros and Stored Procedures.
  • Collected Stats and regularly updated the stats of the tables to eliminate stale stats.
  • Created PPI for some of the tables to have a good performance on range queries with date constraints.
  • Move Data between environments using Data Mover.
  • Performed tasks such as tables skew, monitoring spool space, determining candidate tables for purge, etc.
  • Reviewing Explain plan to recommend collect stats and indexes to improve the performance.
  • Handled USER management requests such as creating new users, profiles and roles.
  • Used Teradata Viewpoint to monitor the system performance when it is in load.
  • Debugged & tuned complex queries for better performance.
  • Handled Space Management me.e. Perm, Temp and Spool Space.
  • Monitor storage capacity and consumption, trend long term usage and proactively work on capacity expansion.
  • Disaster Recovery Planning / Strategy formulation.
  • Plan, schedule and support for Teradata patch upgrades.
  • Created alert policies for monitoring Sessions, Filters, Throttles, and Exceptions in ViewPoint.
  • Set up of backup jobs such as Daily/Weekly/Monthly, and Full/Online backup.
  • Analyze peak and non-peak window workload and adjust the workload priorities, filters and throttles.

Confidential

Jr. Teradata DBA

Responsibilities:

  • Participated actively in user meetings and collected requirements from users.
  • Interacted with Clients and Data Modelers to develop the Logical and Physical Design for tables.
  • Created different environments.
  • Create different databases for different purposes.
  • Defined usi, nusi and ppi for the tables depending on their frequency of access.
  • Created views for all the tables.
  • Worked on loading of data and rectifying error loads from several flat files sources to Staging using Teradata TPUMP, MLOAD, FLOAD and BTEQ.
  • Moved data between different databases and environments.
  • Created users with different roles and profiles to control the access on the system.
  • Used Explain Plan to fine tune queries for better performance and to eliminate spool errors.
  • Used ARCMAIN to archive and restore data.
  • Supported incident tickets and resolved the incidents within the SLAs.
  • Extensively worked on the Fine Tuning of SQL Queries.
  • Collected stats for better performance and implemented MVC for space savings.
  • Extensively used FEXP utility to export and load data to flat files.
  • Worked exclusively with the Teradata SQL Assistant to interface with the Teradata.
  • Experienced in Teradata Manager, Priority Scheduler and DBQL Query Log to define workloads create alerts and monitor the system performance.
  • Involved in documentation of requirements and technical design.

We'd love your feedback!