Teradata Database Administrator Resume
Charlotte, NC
SUMMARY
- 11+ years of experience in Teradata Enterprise Data Warehouse (EDW) and Data Mart.
- Experience working with clients of all sizes in the Retail, Financial/ Banking and Healthcare industries.
- Experience in major projects like Teradata upgrades, Tech refreshes and expansions.
- Expert DBA skills in Teradata DBMS Administration, development and production DBA support, use of Teradata Manager, FASTLOAD, MULTILOAD, TSET, TPUMP, SQL, PDCR and ARCMAIN, TASM for workload management.
- Experience in planning and coordinating Disaster recovery solution for Teradata
- Experience in SQL Server database administration and Microsoft SQL Analysis Services (MSAS,MSIS).
- Experience in Oracle database administration (Oracle 10G and 9i)
- Expert in tuning complex Teradata SQL Queries including Joins, Correlated Sub queries, and Scalar Sub queries.
- Good understanding of DataWarehousing concepts such as Third Normal form (3NF) as well as Dimensions Schema.
- Working with BUSINESS OBJECTS/OBIEE team to optimize various report run times by applying various TD performance techniques such as Partitioning, JIs, AJIs, USI and NUSI.
- Existing FT Physical DM is created based on even distribution of tables by defining 10 to 20 column Primary Indexes not taking usage into consideration. Redesigned and Optimized the Finance Transform Physical DM by defining the right PIs and PPIs using ELDM. Also implemented multi - valued compressions.
- Implemented various Teradata recommended best practices while defining Profiles, Roles, Alerts, Multi-Value Compression, TARA GUI, Teradata Data Mover, and NetBackup.
- Created and implemented BAR strategy for the TD application and system databases.
- Created and scheduled various Teradata recommended Performance, Capacity, trending and activity reports such as Space, Usage, Access, security reports.
- Did the Teradata SQL troubleshooting and fine tuning of scripts given by Analysts and developers.
- 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 PPI for some of the monthly and daily tables to have a good performance on range queries with date constraints. Also created NUSI on PI column for the PPI tables have a good performance on queries with PI access.
- Implemented ETL level collection statistics for the Indexes and for some of the columns going to be involved in the constraints or join conditions.
- Defined account IDs, priority scheduler performance groups, and system date and time substitution variables in user and profile definitions.
- Responsible for the design and implementation of the entire DW Dimensional Model architecture using Join Indexes and Partitioned Primary Indexes to achieve and exceed the desired performance.
- Generated a Capacity management reports on analyzing the Spool/CPU/I/O/Usage resources and proactive monitoring to meet performance and growth requirements on PDCR Database.
- Having good experience in SUSE 10 / Linux operating system and command set as well as competence with shell scripting.
- Set up the Teradata Workload Manager with the proper partitions and workloads based on Service Levels. Set up Teradata Query manager to automate many of the DBA tasks such as collection of statistics, monitoring spool space, candidate tables for purge, etc.
- Monitored the production and development systems on a daily basis to catch trouble queries, monitor access violations, and provide capacity planning.
- Modification of views on Databases, Performance Tuning and Workload Management. Maintenance of Access Rights and Role Rights, Priority Scheduling, Dynamic Workload Manager, Database Query Log, Database Administrator, Partitioned Primary Index (PPI), Multi-Value Compression Analysis, Usage Collections and Reporting of ResUsage, AmpUsage, Security Administration Setup etc. and leading a team of developers for workaround with different users for different, complicated and technical issues.
- Implemented different performance features for several Subject Areas by choosing the right Primary Indexes, ETL level statistics collection, Column Compressions. Also implemented Partitioning on the periodic monthly and Daily tables to increase the performance of range queries. Also implemented NUSI on PI for PPI tables to increase the performance on NUPI access.
- Experience in administering Oracle 9i/10G databases
TECHNICAL SKILLS
Database: TD15 VM, Teradata 14.0, Teradata 13.10, Teradata V2R5, V2R6, 13.00.01.19 and V2R12, DB2, Oracle 9i/10g, Vsam, MS SQL SERVER
Reporting Tool: Business Objects XI, OBIEE, MicroStrategy
ETL: Informatica, TD ETL MLoad, FLoad, Xport, Bteq, TPump, Jcl, SQL, PL/SQL, JAVA, MainFrame (TSO, MVS, ISPF).
Operating Systems: Windows 2000, and XP Professional, UNIX: Sun Solaris, HP-UX
Methodologies: Business Process, Relational Data Modeling, Logical Data Modeling, Object Oriented Modeling, SQL Assistant, Object Relational Modeling, and Physical Database Design, Tset, TPT, Visual Explain, Workload Manager, Teradata Priority Scheduler, Teradata Visual Explain, Teradata Manager & Administrator, Net vault, TASM, TD Data Mover, Viewpoint, PDCR, SWS, TVI, BAR, SLES, TARA GUI, TDB, UNITY tool
Backup Technologies: Net vault/NetBackup GUI tools, Bar scripts, Data Mover, Tara
PROFESSIONAL EXPERIENCE
Confidential, Charlotte,NC
Teradata Database Administrator
Responsibilities:
- Monitoring the Teradata systems through viewpoint servers.
- Teradata upgrade to version 15
- Teradata tech alerts review and analyzing the impact.
- Implemented Teradata Virtual machines for development and POC
- Implementation of MSBI (Microsoft SQL Server Business Intelligence) to run reports on Tableau
- Teradata system maintenance activities.
- Space management and statistics management.
- Review of Table designs/models and enforce the standards for better performance.
- Implementation of Compression (MVC and BLC).
- MSAS administration, building cubes on sql server from Teradata and Oracle databases.
- Embarcadero administration and security
- Tableau extracts/reports performance tuning
- Micro strategy reporting queries monitoring and Performance tuning
- Redesign the backup to run efficiently
- Health maintenance activities like check table, scan disk etc.
- Replace of drives on Development and QA Teradata systems.
- ETL process turning
- TASM setup and administration
- Review of all production changes and verifying the impact.
- Creating users and maintaining security as per SOX compliance.
- Reviewing the Teradata incidents and working with Teradata to resolve any issues
- Implementing the database changes to QA and production systems
Environment: Teradata 13.10,Teradata 15, Teradata Virtual Machines, UNIX, Viewpoint, Teradata Administrator& Manager, DBQL, Tivoli (Arcmain Backup Restore, Tara Gui), (Teradata ELT Utilities - Multiload, FastLoad, PDCRDATA, SQL Assistant, PMON, TSET, TASM, Visual Explain, FastExport, BTEQ, TPump), DBA Tools(SWS, TVI, BAR, SLES), ETL, AbInitio, ArcMain, TD SQL, Microsoft Products, Linux, Tableau, Micro Strategy, Embarcadero, MS SQL server, MS SQL Server Analysis server (CUBES).
Confidential, Milwaukee, WI
Teradata Database Administrator (Lead DBA for DW Team)
Responsibilities:
- Monitoring the Teradata systems through viewpoint servers.
- Implementation of Compression (MVC and BLC).
- Statistics enhancement like Summary, using maxintervals etc.
- Aster database administration.
- Backup/restore on Aster databases.
- Teradata Work Load Management on SLES11.
- Reports generation using PDCR reports to analyze the system performance.
- Installation Teradata Tools and Utilities on client and ETL servers.
- Use of Data Dictionary/Directory tables and views to manage the system
- Teradata Administrator - graphical Windows tool to assist in administration
- Teradata Analyst Toolset - Index Wizard, Statistics Wizard, and Teradata SET
- Creating and managing user accounts with appropriate security.
- Prepared shell scripts for monitoring the system.
- Scheduled Monthly Maintenance activities for different Teradata servers.
- Involved in DBA activities such as
- Creating Users, Databases and other objects,
- Creating/maintaining Roles and Profiles and assigning them to users,
- Space management,
- Access management.
- Used TSET for copying the stats and other information and analyze the issue.
- Automated the stats collection process using shell scripts.
- Reviewing the projects in all the phases and Migrating the database objects
- Defined a backup process for DB through TARA
- Active participation in Teradata upgrade activities
- Worked with BI Production Supporting team for production database issues.
Environment: Teradata 14.0, Teradata Aster, Teradata Virtual Machines, UNIX, Viewpoint, Teradata Administrator& Manager, PDCR DATA/INFO, DBQL, NET VAULT/NETBACKUP (Arcmain Backup Restore, Tara Gui, Datamover), (Teradata ELT Utilities - Multiload, FastLoad, PDCRDATA, SQL Assistant, PMON, TSET, TASM, Visual Explain, FastExport, BTEQ, TPump), DBA Tools(SWS, TVI, BAR, SLES), ETL, AbInitio, ArcMain, TD SQL, Microsoft Products, Linux.
Confidential, Jacksonville, FL
Sr. Teradata Database Administrator
Responsibilities:
- Teradata Database Administration through UNITY tool.
- Use of data mover concepts to copy the data among Teradata systems.
- Reports generation using PDCR reports to analyze the system performance.
- Installation Teradata Tools and Utilities on client and ETL servers.
- Monitoring the Teradata systems through viewpoint servers.
- Use of Data Dictionary/Directory tables and views to manage the system
- Teradata Administrator - graphical Windows tool to assist in administration
- Teradata Analyst Toolset - Index Wizard, Statistics Wizard, and Teradata SET
- Creating and managing user accounts with appropriate security.
- Prepared shell scripts for monitoring the system.
- Scheduled Monthly Maintenance activities for different Teradata servers.
- Involved in DBA activities such as
- Creating Users, Databases and other objects,
- Creating/maintaining Roles and Profiles and assigning them to users,
- Space management.
- Access management.
- Package creation through endeavor (earlier used Change Man) and to schedule DBA jobs on Mainframe.
- Manage scheduling of jobs on Mainframe using PODS (Production Online Datacenter Scheduling)
- Proficient in archiving and restoring the data using MVS panels (on Mainframe).
- Acquaintance to Maximo Service Center for Prodex (Production Execution).
- Production Support (ONCALL) for Break Fix and Emergency fixes.
- Automation of Multi-Value compression through Procedure.
- Performance tuning when needed.
- Involved in Performance monitoring the different TD servers using tools like PMON, Dashboard, TD Viewpoint and Teradata Manager.
Environment: Teradata VaR6/12, UNIX, Teradata Manager/ Viewpoint, Teradata Administrator & Manager, PDCR DATA/INFO, DBQL, UNITY Tool, Hadoop Cluster, NETBACKUP (Arcmain Backup Restore, Tara Gui, Datamover), (Teradata ELT Utilities - Multiload, FastLoad, PDCRDATA, SQL Assistant, PMON, TSET, TASM, Visual Explain, FastExport, BTEQ, TPump), DBA Tools (SWS, TVI, BAR, SLES), Mainframe, ETL JCL, MVS, ISPF, TSO, AbInitio, ArcMain, TD SQL, Microsoft Products, Linux.
Confidential
Teradata Database Administrator (Sr. DBA for DW Team)
Responsibilities:
- Use of Data Dictionary/Directory tables and views to manage the system.
- Teradata Administrator - graphical Windows tool to assist in administration.
- Teradata Manager - suite of Windows tools for performance management, etc.
- Teradata Analyst Toolset - Index Wizard, Statistics Wizard, and Teradata SET
- Teradata Database Query Manager - job scheduling facility.
- Creating and managing user accounts with appropriate security.
- Prepared shell scripts for monitoring the system.
- Automated the NetBackup and NetVault for tables and database.
- Refreshed the data by using fast export, multiload, fastload and ARC utilities.
- Used Teradata Administrator and Teradata Manager Tools for monitoring and
- Control the system.
- Assisting developers/users to tune queries.
- Overseeing daily and weekly back-ups.
- Performance monitoring, investigating long running queries and Tuning queries with the analysis of Business objects.
- Maintenance activities like Check Table, Scan disk, Pack disk using Ferret Utilities
- Installed new software db mon on Teradata nodes to monitor the system.
- Installed Teradata utilities 8.1 and upgraded to 8.2.
- Used Teradata Index Wizard to identify the good SI for a query and workload.
- Used Teradata Statistics wizard to identify the missing and extra stats.
- Used TDWM for defining the workloads for ETL’s and Reporting.
- Used TSET for copying the stats and other information and analyze the issue.
- Automated the stats collection process using shell scripts.
- Reviewing the projects in all the phases and Migrating the database objects
- Defined a backup process for DB with ARC utility
- Active participation in Teradata upgrade activities
- Worked with BI Production Supporting team for production database issues.
- Administering Oracle repository databases and implementing the DDL changes.
Environment: Teradata V2R5/V2R6, UNIX, Teradata Manager, Teradata Administrator & Manager, DBQL, NET VAULT/NETBACKUP (Arcmain Backup Restore, Tara Gui), Oracle 9i/10g, (Teradata ELT Utilities - Multiload, FastLoad, SQL Assistant, PMON, TSET, TASM, Visual Explain, FastExport, BTEQ, TPump), DBA Tools (SWS, TVI, BAR, SLES), Ab Initio, ArcMain, TD SQL, Microsoft Products, Linux.