We provide IT Staff Augmentation Services!

Teradata Lead Dba Resume

AR

SUMMARY:

  • Total 13+ Years of experience in Data Warehousing providing business solutions using Teradata, MS SQL Server, DB2 and Oracle as databases.
  • Over 8+ years of experience Teradata DBA
  • Expertise in Teradata DBA activities like user and database creation / maintenance, Tuning ETL queries / application code, Space management, Releasing the locks, Performance monitoring using PMON, Viewpoint, TDWM, DBQL, PDCR, DBS control settings and development activities like witting or modifying scripts for BTEQ, FastLoad, MultiLoad, Fast Export, Tpump, TPT and SQL as per the business requirements.
  • Extensive experience in Teradata tools and utilities like BTEQ, FastLoad, MultiLoad, Fast Export, Tpump, TPT,OLE DB, TSET, PMON, Teradata Administrator, Manager, View point, Arcmain, Net Vault, Net Backup using TARA GUI, DSA etc., and ETL tools like ODI, Data Stage Server / parallel extender, Informatica with ETL concepts, Toad, Sql Developer.
  • Recently got trained on Hadoop CDHand knowledge in Teradata 15.10 and 16x
  • Experience in dev, support, maintenance projects and handling very large databases for PROD, DEV and TEST environments supporting under either on call or 24x7
  • Implemented TASM Workloads, developed TASM exceptions, filters and throttles as needed basis.
  • Development of SQL Queries for ETL and Semantic structures for DWH by creating Tables in ETL Staging and Semantic layers in EDWH.
  • Design and develop all the staging tables needed to transform and store data from OLTP environment prior to export to data warehouse. Also created dimension, fact tables for DWH.
  • Experience in Design, Implementation and Maintenance of OLTP & OLAP Data Warehouse systems, Data & Technical architecture, ETL processes, Business Intelligence and Enterprise Application integration using tools like ODI, Data Stage, Informatica and replication tools like Golden Gate from source to Staging
  • Performance tuning of Data Warehouse and ETL data load, Documentation of requirements, design, development & testing phases, team management, code review, analysis of existing system, impact analysis, integration testing, defects analysis and fix.
  • Expertise in building Semantic Layer which will provide basis for the analytics and reporting needed for the reporting platform.
  • Experience with physical data modeling forward engineering, reverse engineering, complete compare and database design using Erwin.
  • Experienced working on Performance Tuning, PPI Concepts, Join index, Secondary Indexes, Compression techniques, strategies, Query optimization, Teradata SQL.
  • Creating and implementing an End to End Software / Version upgrade implementation, node addition and hardware relocation activities.
  • Extensively worked on Netvault backup utility like addition of tapes, creating pools, Drive allocation, creating save sets etc.
  • Hands on experience in installing, configuring Hadoop ecosystem components like Hadoop MapReduce, HDFS, HBase, Oozie, Hive, Sqoop and Pig.
  • Assisted in designing, development and architecture of Hadoop eco system.
  • Extensively worked on Mainframes, UNIX Shell scripts.
  • Knowledge in scheduling tools like Control - M, Cron Tab, Autosys, Appworx.
  • Knowledge in Azure infrastructure management (Azure Storage, Azure AD and Office365), migrating on premise to Windows Azure in DR on cloud using Azure Recovery Vault and Azure backups.
  • Following ITIL process for handling incidents, CR, SR, Problem tickets by using tools like BMC Remedy, Jira, Service now etc.
  • Generate, present reports to management about activities performed, issues faced, CR management, high priority incidents and resolution in defined Service level goals and management activities like Resource shift, Shift-Handover, Leaves status, On-call Rotation, monthly highlights, team building by technical trainings & sessions.

TECHNICAL SKILLS:

RDBMS: Teradata V14x, 13x, 12, V2R6, V2R5, Oracle, Netezza

Administrator Tools: Teradata Manager, Administrator, SQL Assistant (Query man), Performance Monitor (PMON), Viewpoint, Studio Express, TSET

Database Utilities: Lockdisp, Showlock, Vprocmanager, Scandisk, Checktable

System utilities: dbscontrol, ferret, TASM

Load/ Unload Utilities: BTEQ, FastExport, FastLoad, MultiLoad, Tpump, TPT, Data Mover

Backup Tools: Net vault backup, Net backup, TARA, DSA and Teradata ARC

ETL Tools: ODI, Data stage 7.5/Px, INFORMATICA 8.x

Reporting Tools: Cognos 8.x, Business Objects 6.5, SAS 9.1.3

Modeling Tools: Erwin 7.x, 8.2

Scheduling Tools: Control-M, Cron Tab, Appworx.

Replication Tools: Golden Gate

Domains: Manufacturing, Banking, Automobile, Retail, Telecom

Operating Systems: Windows, UNIX, Mainframes

Trained skills: Where Scape Red Tool, Talend open studio for Big data/ Data integrator, Qlikview, Tableau, Big data with Hadoop components like Hive, Hdfs, CDH etc.,.

PROFESSIONAL EXPERIENCE:

Confidential, AR

Teradata Lead DBA

Responsibilities:

  • Understanding BRD, Data required document and mapping documents.
  • Teradata DBA support to application teams in creating database objects, tuning queries and handling loading jobs.
  • Participate in the meeting with different groups from offshore and onsite to give them knowledge on Teradata whenever they need
  • Catering to Adhoc requests (e.g. Creation of users, Database Objects, Granting privileges to a user/role/profile, resetting the password, release of load locks, space movements.)
  • Creating and executing the DDL’s / DML’s as requested by the developers.
  • Designing, creating and tuning physical database objects (tables, views, indexes) with Users and developer's support.
  • Database maintenance like space management by monitoring, identifying & troubleshooting problems and fixing them by maintaining space by releasing unwanted objects etc.
  • Table design and indexes selection.
  • Providing Teradata solutions to end business users and resolving the Teradata login issues.
  • Data refreshing from production to development and test boxes.
  • Handling the situations when there is stuck-up with Teradata like when the system is in Flow control etc.
  • Proactively monitor database for blocking issues, system capacity for CPU, IO usage using viewpoint.
  • Many queries have been tuned to perform better by fixing the skew, reducing the spool usage etc. resulting in millions of impact CPU savings.
  • Develop Statistics Collection processes. Identify Objects, Columns, and Indexes for Stats Collection using Statistics wizard by defining workloads
  • Co-ordination & Implementation of MVC analysis & Turnover done of a monthly basis for space saving on Production systems.
  • Handle Teradata related failures and provide instant resolution for them (spool outs, perm space requirement etc.).
  • Working on code and application enhancements like modifying the scripts as per the request both in SQL and in UNIX.
  • Tuning the application queries, reporting queries, long running queries and ETL queries using the optimization techniques like SQL code review, secondary indexes (NUSI), Join Indexes (JI’s) and Aggregate Join Indexes (AJI’s)
  • Refreshed the data by fast export, Multiload, fast load and Data Mover utilities.
  • Effectively interacting with the client daily/Weekly call and technical discussions for smooth transition and ensuring timely and defect free delivery within the SLA.
  • Assist developers, ETL, BI team and end users to understand the data model.
  • Used various Teradata utilities like MLOAD, FASTLOAD, BTEQ, Fast Export, TPT
  • Creating incidents and coordinating with Teradata GSC during system unavailability P1/P2 issues like AMP down, node failures, DBS hung and other hardware related failures by collecting necessary information from TSET.
  • Identifying the suitable objects for archiving consulting with business users and writing jobs for Archiving to use the existing space efficiently; this includes the staging and archive data.
  • Use of Data Dictionary/Directory tables and views to manage the system
  • Assisting developers/users to tune queries.
  • Analyse the workloads and configure TDWM rules and throttles using DBQL.
  • Configured Alerting for Database health like session blocking, Space threshold, restart.
  • Preparation of Production support document.
  • Change request management, population of History tables.
  • Implementing the DBQL data collection and using the DBQL (Query logging data) on User Level or Account Level for tuning the code.
  • Reviewing the projects in all the phases, Design, development, testing and migrations.

Environment: Teradata 14x/15x, Oracle, Hadoop, UNIX, Control-M

Confidential, IN

Teradata Lead DBA

Responsibilities:

  • Understanding BRD, Data required document and mapping documents.
  • Work with Business team, Architect and developer for creating/modify physical data models from Logical model applying business rules and accordance with Database architecture
  • Effectively interacting with the client daily/Weekly call and technical discussions for smooth transition and ensuring timely and defect free delivery within the SLA.
  • Review the data model with functional and technical team
  • Assist developers, ETL, BI team and end users to understand the data model.
  • Co-Ordinate with ETL team for further ETL Jobs development by using various Teradata utilities like MLOAD, FASTLOAD, BTEQ, Fast Export, TPT.
  • Table design and indexes selection.
  • Teradata DBA support to application teams in creating database objects, tuning queries and handling loading jobs.
  • Involved in Tape management like assigning tapes first to the blank pool and then moving those tapes to the new pools by creating new pools, report management etc.
  • Creating incidents and coordinating with Teradata GSC during system unavailability P1/P2 issues like AMP down, node failures, DBS hung and other hardware related failures by collecting necessary information from TSET.
  • Catering to Adhoc requests (e.g. Creation of users, Database Objects, Granting privileges to a user/role/profile, resetting the password, release of load locks, space movements.)
  • Creating and executing the DDL’s / DML’s as requested by the developers.
  • Designing, creating and tuning physical database objects (tables, views, indexes) with Users and developer's support.
  • Database maintenance like space management by monitoring, identifying & troubleshooting problems and fixing them by maintaining space by releasing unwanted objects etc.
  • Generate SQL Scripts, DDL's from Physical Data Model and execute the DDL’s.
  • Develop Generic scripts in Unix to execute BTeq scripts to load the data into Staging Layer and Semantic Layer.
  • Involved in hardware and version up gradation of the systems.
  • Net vault Backup/Restore/Analyze monitoring, job creation/modify, define and schedule backups in assigned window, work on ad-hoc request.
  • Performing Data copy, backup / restore jobs via Netvault, Providing support to Development Team, ETL team for Teradata related queries.
  • Implemented TASM Workloads, developed TASM exceptions, filters and throttles as needed basis.
  • Handling the situations when there is stuck-up with Teradata like when the system is in Flow control etc.
  • Proactively monitor database for blocking issues, system capacity for CPU, IO usage using viewpoint, PMON, and TD Manager
  • Many queries have been tuned to perform better by fixing the skew, reducing the spool usage etc. resulting in millions of impact CPU savings.
  • Develop Statistics Collection processes. Identify Objects, Columns, and Indexes for Stats Collection using Statistics wizard by defining workloads
  • Co-ordination & Implementation of MVC analysis & Turnover done of a monthly basis for space saving on Production systems.
  • Handle Teradata related failures and provide instant resolution for them (spool outs, perm space requirement etc.).
  • Reviewing the export, import and ARCMAIN scripts prepared by the groups.
  • Working on code and application enhancements like modifying the scripts as per the request both in SQL and in UNIX.
  • Tuning the application queries, reporting queries, long running queries and ETL queries using the optimization techniques like SQL code review, secondary indexes (NUSI), Join Indexes (JI’s) and Aggregate Join Indexes (AJI’s)
  • Data Monitoring, production load monitoring by report and handle load errors, data integrity issues.
  • Reconcile the data with the source system extracts to ensure correct DWH load completed.
  • Process and transform the data for the countries as per the mapping rules provided. Each country will be handled separately for processing purposes.
  • Preparing job scheduler list and maintaining the dependency while scheduling the jobs on scheduling tools.
  • Installed Teradata utilities on platforms like Windows, Linux etc.
  • Refreshed the data by ARC, fast export, Multiload, fast load and Data Mover utilities.
  • Identifying the suitable objects for archiving consulting with business users and writing jobs for Archiving to use the existing space efficiently; this includes the staging and archive data.
  • Use of Data Dictionary/Directory tables and views to manage the system
  • Analyse the workloads and configure TDWM rules and throttles using DBQL.
  • Configured Alerting for Database health like session blocking, Space threshold, restart.
  • Preparation of Production support document.
  • Change request management, population of History tables.
  • Implementing the DBQL data collection and using the DBQL (Query logging data) on User Level or Account Level for tuning the code.
  • Reviewing the projects in all the phases, Design, development, testing and migrations.
  • Housekeeping activities like table splitting, DBQL maintenance, taking backup of core loads.
  • Maintenance activities like Check Table, Scandisk, Pack disk using Ferret Utilities to make the sufficient free cylinder to help the System perform optimally
  • Using the amp usage, resusage and DBQL to analyse the resource usage by account and verifying the bottlenecks
  • Working on GoldenGate mapping files to load data from Oracle to Teradata staging.

Environment: Teradata 14x, Oracle, Netezza, UNIX, Appworx, Netvault, Golden Gate, Erwin

Confidential

Senior Teradata Developer

Responsibilities:

  • Understanding BRD, Data required document and mapping documents.
  • Work closely with six Confidential local market teams like management, application dba, BI to Identify root cause and provide solution for any critical job failure, response on escalation.
  • Effectively interacting with the client daily/Weekly call and technical discussions for smooth transition and ensuring timely and defect free delivery within the SLA.
  • Participate in the meeting with different groups from offshore and onsite to give them knowledge on Teradata whenever they need
  • Involved in Tape management like assigning tapes first to the blank pool and then moving those tapes to the new pools by creating new pools, report management etc.
  • Creating incidents and coordinating with Teradata GSC during system unavailability P1/P2 issues like AMP down, node failures, DBS hung and other hardware related failures by collecting necessary information from TSET.
  • Catering to Adhoc requests (e.g. Creation of users, Database Objects, Granting privileges to a user/role/profile, resetting the password, release of load locks, space movements.)
  • Creating and executing the DDL’s / DML’s as requested by the developers.
  • Designing, creating and tuning physical database objects (tables, views, indexes) with Users and developer's support.
  • Database maintenance like space management by monitoring, identifying & troubleshooting problems and fixing them by maintaining space by releasing unwanted objects etc.
  • Involved in hardware and version up gradation of the systems.
  • Net vault Backup/Restore/Analyze monitoring, job creation/modify, define and schedule backups in assigned window, work on ad-hoc request.
  • Performing Data copy, backup / restore jobs via Netvault, Providing support to Development Team, ETL team for Teradata related queries.
  • Table design and indexes selection.
  • Providing Teradata solutions to end business users and resolving the Teradata login issues.
  • Data refreshing from production to development and test boxes.
  • Handling the situations when there is stuck-up with Teradata like when the system is in Flow control etc.
  • Many queries have been tuned to perform better by fixing the skew, reducing the spool usage etc. resulting in millions of impact CPU savings.
  • Develop Statistics Collection processes. Identify Objects, Columns, and Indexes for Stats Collection using Statistics wizard by defining workloads
  • Co-ordination & Implementation of MVC analysis & Turnover done of a monthly basis for space saving on Production systems.
  • Handle Teradata related failures and provide instant resolution for them (spool outs, perm space requirement etc.).
  • Working on code and application enhancements like modifying the scripts as per the request both in SQL and in UNIX.
  • Refreshed the data by ARC, fast export, Multiload, fast load and Data Mover utilities.
  • Identifying the suitable objects for archiving consulting with business users and writing jobs for Archiving to use the existing space efficiently; this includes the staging and archive data.
  • Use of Data Dictionary/Directory tables and views to manage the system
  • Assisting developers/users to tune queries.
  • Overseeing daily and weekly back-ups.
  • Preparation of Production support document.
  • Change request management, population of History tables.

Environment: Teradata 14x, 13x, Windows, UNIX, Netvault

Confidential, TX

Senior Teradata DBA

Responsibilities:

  • Understanding BRD, Data required document and mapping documents.
  • Providing support to Development ETL team for Teradata related queries
  • Table design and indexes selection.
  • Providing Teradata solutions to end business users
  • Creating and managing user accounts, databases and data with appropriate security.
  • Creating and executing the DDL’s / DML’s as requested by the developers.
  • Database / Application Tuning like performance tuning.
  • Database maintenance like space management, identifying and releasing unwanted objects
  • Performing backup and restore activities using TARA.
  • Reviewing the export, import and ARCMAIN scripts prepared by the groups.
  • Data refreshing from production to development and test boxes
  • Monitoring the system using PMON,TD Manager, Viewpoint
  • Handling the situations when there is stuck-up with Teradata.
  • Developing scripts for loading and unload utilities like Fast load, Multiload, Fast Export, BTeq.
  • Handle Teradata related failures and provide instant resolution for them (spool outs, perm space requirement etc.).
  • Reviewing the export, import and ARCMAIN scripts prepared by the groups.
  • Working on code and application enhancements like modifying the scripts as per the request both in SQL and in UNIX.
  • Tuning the application queries, reporting queries, long running queries and ETL queries using the optimization techniques like SQL code review, secondary indexes (NUSI), Join Indexes (JI’s) and Aggregate Join Indexes (AJI’s)
  • Data Monitoring, production load monitoring by report and handle load errors, data integrity issues.
  • Reconcile the data with the source system extracts to ensure correct DWH load completed.
  • Process and transform the data for the countries as per the mapping rules provided. Each country will be handled separately for processing purposes.
  • Preparing job scheduler list and maintaining the dependency while scheduling the jobs on scheduling tools.
  • Installed Teradata utilities on platforms like Windows, Linux etc.
  • Refreshed the data by ARC, fast export, Multiload, fast load and Data Mover utilities.
  • Identifying the suitable objects for archiving consulting with business users and writing jobs for Archiving to use the existing space efficiently; this includes the staging and archive data.
  • Use of Data Dictionary/Directory tables and views to manage the system
  • Assisting developers/users to tune queries.
  • Overseeing daily and weekly back-ups.
  • Analyse the workloads and configure TDWM rules and throttles using DBQL.
  • Configured Alerting for Database health like session blocking, Space threshold, restart.

Environment: Teradata14x,13x, Windows, UNIX, Mainframes

Confidential

Senior Teradata DBA

Responsibilities:

  • Understanding BRD, Data required document and mapping documents.
  • Providing support to Development ETL team for Teradata related queries
  • Table design and indexes selection
  • Providing Teradata solutions to end business users Effectively interacting with the client daily/Weekly call and technical discussions for smooth transition and ensuring timely and defect free delivery within the SLA.
  • Participate in the meeting with different groups from offshore and onsite to give them knowledge on Teradata whenever they need
  • Involved in Tape management like assigning tapes first to the blank pool and then moving those tapes to the new pools by creating new pools, report management etc.
  • Creating incidents and coordinating with Teradata GSC during system unavailability P1/P2 issues like AMP down, node failures, DBS hung and other hardware related failures by collecting necessary information from TSET.
  • Catering to Adhoc requests (e.g. Creation of users, Database Objects, Granting privileges to a user/role/profile, resetting the password, release of load locks, space movements.)
  • Creating and executing the DDL’s / DML’s as requested by the developers.
  • Database maintenance like space management by monitoring, identifying & troubleshooting problems and fixing them by maintaining space by releasing unwanted objects etc.
  • Involved in hardware and version up gradation of the systems.

Environment: Teradata13x, Oracle, Windows, UNIX

Confidential

Senior Teradata DBA

Responsibilities:

  • Understanding BRD, Data required document and mapping documents.
  • Work with Business team, Architect and developer for creating/modify physical data models from Logical model applying business rules and accordance with Database architecture
  • Create SQL Scripts from Physical Data Model.
  • Generate scripts/ schema and reports from data model.
  • Review the data model with functional and technical team
  • Maintain change log for each data model.
  • Done reverse engineering, forward engineering.
  • Check to see data models or databases are in synch by using complete compare between different environments.
  • Review the data model with functional and technical team
  • Assist developers, ETL, BI team and end users to understand the data model.
  • Responsible for the entire data model related sign offs.
  • Co-Ordinate with ETL team for further ETL Jobs development.
  • Teradata DBA support to application teams in creating database objects, tuning queries and handling loading jobs.
  • Generate SQL Scripts, DDL's from Physical Data Model
  • Assist developers, ETL, BI team and end users to understand the data model.
  • Responsible for the entire data model related sign offs.
  • Co-Ordinate with ETL team for further ETL Jobs development.
  • Providing support to Development ETL team for Teradata related queries
  • Table design and indexes selection
  • Providing Teradata solutions to end business users

Environment: Erwin 7.x, 8.2, Teradata 12, Oracle, Windows, UNIX

Confidential

Teradata DBA

Responsibilities:

  • Understanding BRD, Data required document and mapping documents.
  • Creating and managing user accounts, databases and data with appropriate security.
  • Creating and executing the DDL’s / DML’s as requested by the developers.
  • Database / Application Tuning like performance tuning.
  • Database maintenance like space management, identifying and releasing unwanted objects
  • Performing backup and restore activities using TARA.
  • Reviewing the export, import and ARCMAIN scripts prepared by the groups.
  • Data refreshing from production to dev and test boxes
  • Monitoring the system using PMON,TD Manager, Viewpoint
  • Developing scripts for loading and unloading utilities like Fast load, Multiload, Fast Export, BTeq.
  • Handling the situations when there is stuck-up with Teradata.
  • Developing scripts for loading and unloading utilities like Fast load, Multiload, Fast Export, BTeq.
  • Developing jobs for loading and unloading by using ODI Designer and Data stage Px Designer.
  • Preparing models, interfaces and packages in ODI to load data.
  • Generating scenarios for the packages and interfaces.
  • SQL code review for performance tuning
  • Provided support to Development ETL team and Production team for Teradata related queries.
  • Working on code and application enhancements like modifying the scripts as per the request both in SQL and in UNIX.
  • Reconcile the data with the source system extracts to ensure correct DWH load completed.
  • Process and transform the data as per the mapping rules provided.
  • Report and handle load errors.
  • Preparing job scheduler list.
  • Involved in unit testing.

Environment: ODI, Abinitio, Cognos8.4, Oracle 9i, Teradata 6x, UNIX, and Windows

Confidential

Teradata Developer

Responsibilities:

  • Understanding BRD, Data required document and mapping documents.
  • Database Administration tasks such as creating users, Roles and Profiles
  • Creating and executing the DDL’s / DML’s as requested by the developers.
  • Database / Application Tuning like performance tuning.
  • Database Maintenance - monitoring & troubleshooting problems and fixing them by maintaining space, etc.
  • Performing backup and restore activities.
  • Developing scripts for loading and unloading utilities like Fast load, Multiload, Fast Export, BTeq.
  • Reviewing the export, import and ARCMAIN scripts prepared by the groups.
  • Handling the situations when there is stuck-up with Teradata.
  • Data Monitoring and Production load monitoring.
  • Daily Load analysis and Data Validation with major operation support.
  • Solving Priority 1 cases.
  • Working on code and application enhancements.
  • Maintaining and supporting the production.
  • Deploying enhancements into production.
  • Participating in meetings with client.
  • Effectively handling the batch failures in daily, month end and year end activities for reaching 100 percent SLAs.
  • Actively participated in performance tuning of queries.
  • Given internal sessions on Teradata to the application support and duty teams.
  • Participated in conference calls with onsite coordinators.
  • Ensuring timely and defect free delivery

Environment: Informatic, Oracle 9i, Teradata 6x, UNIX, Windows.

Confidential

Data Stage ETL Developer

Responsibilities:

  • Understanding BRD, Data required document and mapping documents.
  • Involved in extracting, discussing about requirements from users and team members of source owners.
  • The data is extracted from different sources like Flat files, Oracle loaded to target staging to Final Warehouse i.e. Teradata database by using the Data Stage.
  • Involved in development of creating server jobs using Data Stage Client Tool i.e. Designer.
  • Involved to prepare ETL Specification for developing jobs
  • To perform the aggregation operations on the extracted input data and filtering the data Using Built in Active Stages like AGGREGATOR, SORT STAGE and TRANSFORMER.
  • By using the local and shared containers for simplifying the complex designing.
  • Done Performance tuning in Data Stage.
  • Used Job Control and Job Sequencer to run the job by using parameters.
  • Involved in compiling, validating, running, Monitoring and scheduling jobs.
  • Involved in reprocessing of incoming aggregates data from mediation cdr to aggregated mcdr.
  • Involvement in implementation of BTEQ Scripts and Bulk load jobs.
  • Population of History tables.
  • Loading data for end users using fast load and multi load utilities and exporting data to flat files using fast export.
  • Resolve and work on issues across multiple functional areas.
  • Effectively monitor and take action to ensure coordination and effectiveness of all components and activities and decide on issues requiring escalation.
  • Involvement in optimization.
  • Administration of Teradata database in development and production like user, space and session management.
  • Monitoring ETL jobs until production jobs are stabilized.

Environment: Oracle 9i, Teradata V2R5/6, Data Stage 7x, BO 6x, UNIX, Windows.

Hire Now