We provide IT Staff Augmentation Services!

Teradata Platform Dba Resume

4.00 Rating

Milpitas, CA

SUMMARY

  • 7+ years of experience in the IT industry, coupled with extensive experience in Data Warehousing, Teradata Administration, Monitoring, Performance Tuning, Capacity Planning and Upgrade/Migration activities.
  • Extensive experience in Teradata Database Design, Application Support, Tuning & Optimization, User & Security Administration, Data Administration and Setting up the Test and Development environment.
  • Solid knowledge in Teradata Architecture and Query Tuning.
  • Good experience in Teradata RDBMS using FASTLOAD, MULTILOAD, TPUMP, FASTEXPORT, Teradata SQL and BTEQ Teradata utilities and MLDM.
  • Expertise in using Secondary indexes, PPI, Join indexes, hash indexes.
  • Expertise in Teradata Parallel Transporter and scripting at Windows/Unix servers.
  • Expert in Coding Teradata SQL, Teradata Stored Procedures, Macros and Triggers.
  • Involved in full lifecycle of various projects, including requirement gathering, system designing, application development, enhancement, deployment, maintenance and support.
  • Expertise in Query Analyzing, performance tuning and testing.
  • Hands on experience in monitoring and managing varying mixed workload of an active data warehouse using various tools like Teradata Workload Analyzer, Teradata Dynamic Workload Manager and Teradata Manager .
  • Proficient in Data Migration from MS SQL server, Oracle, PeopleSoft, My SQL and Progress SQL to Teradata.
  • Comfortable with both technical and functional applications of RDBMS, Data Mapping, Data management, Data transportation and Data Staging.
  • Working experience with CRON TAB scheduling and TWS (Tivoli work scheduler) and expert in creating FDS (functional design spec).
  • Experience in writing UNIX shell scripts to support and automate the ETL process.
  • Experience in different database architectures like Shared Nothing and Shared Everything architectures. Very good understanding of SMP and MPP architectures.
  • Experience in Backup and Restore (BAR) methodologies. Design, implement and co - ordinate all back-up and restore strategies.
  • Involved in Unit Testing, Integration Testing and preparing test cases.
  • Proficient in analyzing business processes requirements and translating them into technical requirements.
  • Experience with Teradata Unity system in the environment.
  • Involved in production support activities 24/7 during on call and resolved database issues.
  • Strong problem solving, analytical, interpersonal skills, communication skills and have the ability to work both independently and as a team.
  • Highly enthusiastic, self-motivated and rapidly assimilate new concepts and technologies.

TECHNICAL SKILLS

OPERATING SYSTEMS: Sun Solaris, AIX 5.1, 5.2, Red Hat/SUSE Linux and Windows XP.

RDBMS: Teradata (V2R6.x/ 12.0/13.0/13.10 ), Oracle

LANGUAGES: SQL, UNIX Shell Scripting.

SOFTWARE / APPLICATIONS/ TOOLS: Teradata SQL Assistant, BTEQ, Fastload, Multiload, Fastexport, Tpump, Teradata Parallel Transporter (TPT), Viewpoint, Teradata Visual Explain, TSET, Teradata Index Wizard, TASM, NetBackUp, TARA.

PROFESSIONAL EXPERIENCE

Confidential, Milpitas, CA

Teradata Platform DBA

Responsibilities:

  • Supporting the Teradata Enterprise Data and Analytics platform including mentoring, implementing best practice recommendations, and participating in the DBA day-to-day activities.
  • Producing the Capacity Planning reports for the management and as well doing the Capacity Forecasting in order to plan for the upgrades.
  • Provide exceptional Teradata Database Administration, Monitoring and Maintenance services for the customer’s production environments.
  • Planning, coordinating and executing the System up gradation/Migration activities with ETL/BI teams and Teradata GSC teams.
  • Participating in the Client interactions, meetings, presentations on databases performances in regard to the Teradata platform.
  • User and Access Management: Creation of Databases, Users, Account, Roles, Profiles and Access Rights.
  • Participate in the database change control process.
  • Proficient in installation and troubleshooting the TTUs on client workstations.
  • Proficient on writing and troubleshooting the Teradata utilities (FLOAD, MLOAD, FEXP, TPT, TPUMP) jobs.
  • Involved heavily in writing complex SQL queries based on the given requirements.
  • Heavily involved in System Performance activities such as: Workload management, TASM, Job Scheduling, Priority /Resource allocation, Query Performance Tuning and Optimization.
  • Performed bulk data load from multiple data source (ORACLE, legacy systems) to TERADATA RDBMS using BTEQ, Fastload, Multiload,Tpump.
  • UNIX scripting to support applications and database administration functions.
  • Involved in administering and monitoring the TASM and Viewpoint - Setup, Configuration, setting changes.
  • Defined Database Alerts using tools such as Viewpoint, UNIX scripting to - Define, setup, respond and take appropriate actions.
  • Involved in System Maintenance /Database upgrade - Planning, Scheduling, Co-ordination, Communications, Implementation, and Testing.
  • DataMover jobs performance and Server maintenance.
  • Involved in Backup / Restore - Performing backup, recovering and monitoring, Implemented Online Archive feature for certain databases which had ETL conflicts.
  • Managing database space, allocating new space to database, moving space between databases as need basis.
  • Addressing day to day user’s issues such as resetting passwords, unlocking used id’s, working on permission issues.
  • Responsible for Performance Reports (PDCR) -Daily, Weekly, Monthly and Quarterly reports generation, review and presentation.
  • Single point of contact for leading / coordinating with the offshore DBA team.
  • Raising the Tickets at T@YS / Incidents Managements and coordinating with GSC to implement the fix/patch.

Confidential, Stamford,CT

Teradata DBA

Responsibilities:

  • Created tables, views in Teradata, according to the requirements.
  • Involved in the analysis and implementation of the system.
  • Worked with user groups and developers to define TASM workloads, developed TASM exceptions, implemented filters and throttles as need bases.
  • Involved in monitoring of bad queries, looking for blocked sessions and working with development teams to resolve blocked sessions.
  • Tuning bad queries by analyzing 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.
  • Created and automate the process of loading using Shell Script, Multi load, Teradata volatile tables and complex SQL statements.
  • Involved in User Management tasks like creation and managing users, Roles, Profiles and Accounts.
  • Performed tuning and optimization of complex SQL queries using Teradata Explain.
  • Performed Query monitoring, Space monitoring and health checks of node using the View Point.
  • Created a BTEQ script for pre population of the work tables prior to the main load process.
  • Developed MLOAD scripts to load data from Load Ready Files to Teradata Warehouse.
  • Used FastLoad for loading into the empty tables.
  • Handled security control tasks like logon and logoff rules for users.
  • Involved in allocation of spaces like Permanent Space, Spool Space and Temporary Space.
  • Used volatile table and derived queries for breaking up complex queries into simpler queries.
  • Created an archive process that archives the data files and FTP to the remote server.
  • Created a cleanup process for removing all the Intermediate temp files that were used prior to the loading process.
  • Created a shell script that checks the corruption of data file prior to the load.
  • Created unit test plans to unit test the code prior to the handover process to QA.
  • Involved in troubleshooting the production issues and providing production support.
  • Streamlined the Teradata scripts and shell scripts migration process on the UNIX box.
  • Collected statistics every week on the tables to improve performance.
  • Developed unit test plans and involved in system testing.

Confidential, Houstan, Texas

Teradata DBA

Responsibilities:

  • Worked on capacity planning, reported disk and CPU usage growth reports using DBQL, and Resusage.
  • Development and maintenance of the DBA essential House Keeping jobs.
  • In charge of quality control and auditing of databases to ensure accurate and appropriate data usage.
  • Identifying tables with high skew, working with data modeling team to change the Primary Index on tables with High skew.
  • Participating in the application architectural review meetings and performing the code review.
  • Configured View Point in setting up alters to page DBA for events such as node down, AMP down, too many blocked sessions, high data skew, database space utilization etc.
  • Setup AMP usage collection, canary query response, spool usage response etc.
  • 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 user’s issues such as resetting passwords, unlocking used id’s, working on permission issues.
  • Generated periodically space utilization reports on prod /test env.
  • Developed the triggers to handle history and audit data for production environment.
  • Providing Spool space, Perm space Jobs wise and User wise usage report whenever required.
  • Generated various system usage reports such as peak CPU/IO usage, CPU parallel efficiency to make sure all AMPS are running parallel, CPU skew, IO skew, CPU ideal etc to management team.
  • Configured TASM to change resource allocation based on priority.
  • Performed bulk data load from multiple data source (ORACLE 8i, legacy systems) to TERADATA RDBMS using BTEQ, Fastload, Multiload and TPump
  • Created a BTEQ script for pre population of the work tables prior to the main load process.
  • Used volatile table and derived queries for breaking up complex queries into simpler queries.
  • Involved heavily in writing complex SQL queries based on the given requirements.
  • Created a cleanup process for removing all the Intermediate temp files that were used prior to the loading process.
  • Created and automate the process of loading using Shell Script, Multi load, Teradata volatile tables and complex SQL statements.
  • Involved in troubleshooting the production issues and providing production support.
  • Created a shell script that checks the corruption of data file prior to the load.
  • Streamlined the Teradata scripts and shell scripts migration process on the UNIX box.
  • Enhancements were done to the existing system as specified by the customer using Cobal, DB2, and JCL.
  • Involved in analysis of end user requirements and business rules based on given documentation and working closely with tech leads and analysts in understanding the current system.
  • Collected statistics every week on the tables to improve performance.

Confidential, Woonsocket, RI

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 analyzing 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, Denver, CO

Teradata DBA

Responsibilities:

  • Created databases, tables, indexes and new users.
  • Assigned permissions to users and Security Management.
  • Unload / load data into Teradata RDBMS using fastload/fastexport/multiload tools.
  • Implemented secondary indexes on highly used columns to improve performance.
  • Implement Partition Primary Index (PPI) strategy for large history tables with monthly snapshots.
  • Addressing day to day users issues such as resetting passwords, unlocking used ids, working on permission issues.
  • Analyzing & Validating the source data, and design source to target mapping, transformation logic, document the approach and scripts, database layout.
  • Developed various Mappings and Transformations using Informatica Designer
  • Expertise in implementing complex Business rules by creating robust mappings, mapplets, and reusable transformations using Informatica Power Center and Power Mart.
  • 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 analyzing 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.
  • Developed various DBQL reports such as top 10 queries with high CPU, Top 10 queries with high.
  • 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.
  • Generated various system usage reports such as peak CPU/IO usage, CPU parallel efficiency to make sure all AMPS are running parallel, CPU skew, IO skew, CPU ideal etc to management team.

Confidential

Teradata Developer

Responsibilities:

  • Played a major role in selection of Teradata load utilities based on the nature of data.
  • Responsible for coding and executing SQL scripts for Oracle data extraction.
  • Participated in meetings with Users, Business analysts in understanding the business requirements and analyzed use cases to develop detailed Test Plan.
  • Worked on different indexes (PI, SI, JI, AJIs, PPI (MLPPI, SLPPI)) and Collect Statistics
  • Wrote Teradata Macros and used various Teradata analytic functions.
  • Solely Responsible for Source data analysis and formulation of extract strategy
  • Contributed in preparation of ETL specifications for partial subject areas by continual interaction with data modeler.
  • Suggested data type and other table modifications to physical and logical GRM model.
  • Created of staging tables and Test base tables for enhancements to the physical model.
  • Created BTEQ scripts with data transformations for loading the base tables.
  • Standardized the ETL scripts catering to error table handling process and load statistics collection as per the organizational IT standards.
  • Documentation of scripts, specifications and other processes.
  • Responsible for testing and fixing all issues arising from data validation process.
  • Loading staging tables on Teradata and further loading target tables on Teradata via views.
  • Creating load process to perform aggregations and load base tables.
  • 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.

We'd love your feedback!