SUMMARY

• Extensive 6.9 years of IT experience in Teradata DBA & Performance DBA in Production and Non - Production environments.
• Currently working as Senior Teradata Database Administrator to support the warehouse environment running on TD 15.10 and also worked in TD 14.10, TD 13.10, 13.0, TD12.
• Very strong knowledge on Teradata architecture, and worked on Enterprise 2800/2750 appliance and servers 2650/2690.
• Tuning poorly performing queries of worse Batches and Users, Which affect the system badly.
• Analyzing Explain Plan, DBQL and PDCR information for providing them the tuning solutions.
• Applying hard-cap and Penalty profile enhancement to the business verticals to limit the CPU usage.
• Backup & Archival Disk based, EMC Data Domain De-duplication applianceImplemented in Dev/Production environment.
• Data Labs Implementation on Production environment.
• Monitoring Viewpoint & maintaining TASM (Teradata Active System Management) and having understanding of each and every job running on Teradata box and proficient in identifying performance and resource bottlenecks.
• Generating daily performance scored report to analyze the overall system such as CPU usage, Space usage, AWT usage, Average response time query, finding out top 10 skewed users and batches, High-CPU Users/Batches and Applications.
• Teradata Data Mover for copying data between legacy 2650 to New Teradata appliance 2800 boxes.
• Involved in the Teradata Database Upgrade from version 14.0 to 1 .10 to 15.10 major upgrade and coordinating the regular Production Maintenance.
• Expertise in using View Point in monitoring Teradata system, looking for bad and long running queries, monitor the sessions to identify the blocked sessions, setting TASM rules and to define TASM Workloads, developed TASM exceptions, implemented filters and throttles as need basis.
• Worked on TARA GUI & Created Archive & Restore polices on BAR serves.
• Strong knowledge on DBQL, PDCR, ResUsage tables and making use of the information stored in these tables to generate various performance and system related reports.
• Worked on MVC (Multi value compression), Char to Varchar conversion to reduce the disk space utilization on large tables.
• Monitoring Teradata perm space for availability and monitor Teradata CPU/Load utilization.
• Good experience with Teradata query performance and tuning, DBQL, collect statistics.
• Extensive experience on performance tuning of SQL’s using various tuning methods like analyzing the explain plan, analyzing skews, working with Statistics collection, working with indexes(PI, SI, JI, PPI, MLPPI), to use temp tables like Volatile/Global Temp Tables, applying Compression, etc.
• Strong database experience with BTEQ, Multi load, Fast Load, Fast Export, and TPump on Unix & Mainframe Platforms.
• BAR activities including backup, restore & copy of tables / databases.
• Viewpoint monitoring (session monitoring, locks, system/database health monitoring, alerts) and administration.
• Creating / Modifying Users and databases as per Teradata best practices.
• Creating / Modifying User Roles and Profiles as per Teradata best practices.
• Granting / Revoking Privileges on objects to Users / databases and Roles.
• Database capacity management (space management PERM,SPOOL,TEMP).
• Collecting stats on tables / columns / indexes.
• Using Teradata visual explain, Teradata Index wizard, Teradata Statistics Wizard.
• SYSTEM Utilities like DBS Control, Ferret, Check-Table, Show Locks.
• Identifying Stale stats & poor PI, usage of secondary indexes, join indexes.
• Experience in performing PPI maintenance, multi value compression.
• Handling severity P1 issue in case Batch job failure due to TASM/spool abort, high delay, long running queries, Space issue etc.
• Handling workload management /TASM for sharing the system resources to every business vertical/ad-hoc users.
• Worked on Teradata system emulation (TSET) tool
• Open incident P1/P2/P2 on Teradata team using @TAYS.
• Have good knowledge on Bigdata/Hadoop Architecture and knowledge on Big data tools Hive, Pig, Sqoop and Hadoop MapReduce.

TECHNICAL SKILLS

Databases: Teradata V15.10/V14.10,V13/V12, Oracle 10g/9i, SQLserver2000/2005, MS Access, DB2, Big data (Hadoop, PIG, HIVE), Vertica.

Teradata Utilities/Tools: BTEQ, Fastload, Multi Load, Fast Export, TPump, Teradata Studio 15, Teradata Query Manager, Teradata Administrator and Teradata SQL Assistance, TSET, Teradata visual explain 13.1 & PMON, Unity Data Mover, Viewpoint, NetBackup DSA Solution.

ETL Tools: Informatica ETL Tool 7.1, PowerCenter 8.x/7.x/6.x/5.x Data Stage 7.5/8.0

Scheduling Tool: APPWORX, TWS Scheduler, AutoSys

Big Data: Hadoop, MapReduce, Hive, HBase, PIG

Languages: SQL, PL/SQL, C, C++, C#, Java, UNIX Shell Scripting, PERL

Modeling Tools: Erwin (Dimensions, Star schema and Snow flake)

Operating Systems: HP-UX, Sun Solaris, Red Hat Linux, Windows2003/2000/XP/NT, IBM AIX

PROFESSIONAL EXPERIENCE

Confidential, St. Louis, MO

Senior Teradata DBA

Environment: Teradata 15.10/14.10

Responsibilities:

• Leading the team of 3 resources in database mgmt. and administration project.
• Allocating the resources properly in 24*7 support project. Hosting weekly DBA Meeting to track, resolve and escalate outstanding issue and open tickets.
• Attending daily performance meeting with BI team to improve the overall system performance.
• Generating daily performance scorecard reports to analyze the overall system such as CPU Usage, Space Usage, Suspected query report, Avg response time query, AWT usage, PE and finding out top 10 skewed users and batches, High-CPU Users/Batches & Applications.
• Maintaining the production STATS jobs (Daily/Weekly/Monthly) to keeps Stats updated.
• Collecting/Dropping statistics based on requirement.
• Involved in the Teradata Database Upgrade from version 14.0 to 1 .10 to 15.10 major upgrade and coordinating the regular Production Maintenance and customer specific Efix.
• Handling workload management /TASM for sharing the system resources to every business vertical/ad-hoc users.
• Copying data on New Teradata appliance from legacy box using Data mover tool.
• Worked on Teradata system emulation (TSET) tool
• Open incident P1/P2/P2 to Teradata team using @TAYS.
• Expertise in using View Point in monitoring Teradata system, looking for bad and long running queries monitor the sessions to identify the blocked sessions, setting TASM rules and to define TASM Workloads, developed TASM exceptions, implemented filters and throttles as need basis.
• Working on TARA GUI & Created Archive & Restore polices on BAR serves.
• Strong working knowledge on DBQL, PDCR,ResUsage tables and making use of the information stored in these tables to generate various performance and system related reports.
• Good experience in using Teradata Security features, like LDAP mechanism, Database views, Roles, Users, Password restriction using profiles and access rights.
• Proficiency in appropriate usage of CNS utilities, Checktable, Packdisk, Scandisk, QuerySession, DBScontrol, Teradata Application and Database Administration, load & unload utilities namely SQL Assistant, Administrator, PMON, Viewpoint, Teradata Manager, TASM, TSET, Priority Scheduler, Multiload, Fastload, FastExport.
• Performance tuning and databases maintenance.
• Working on Teradata viewpoint (Alert setup, workload management, query monitor etc.)

Confidential

Senior Teradata DBA

Environment: Teradata 14.10

Responsibilities:

• Having through knowledge of Teradata Architecture.
• Moving data between different environments using Data Mover tool.
• Implement Data Labs in production environment.
• Open incident P1/P2/P2 on Teradata team using @TAYS.
• System Health Reporting using DBQL Data & PDCR history data.
• Application Performance Monitoring- Monitor and respond to Teradata viewpoint Performance alerts.
• Performance tuning of bad performing queries putting high impact on the system.
• Executed Archive/Copy/Copy/Restoration of database using Arc main.
• Generating PDCR reports and analyzing system metrics.
• BAR activities including backup, restore & copy of tables / databases.
• Granting / Revoking Privileges on objects to Users / databases and Roles.
• Extensive knowledge in Teradata utilities like SQL Assistance, PMON, BTEQ, Multiload, FastLoad, Tump, Fastexport and Teradata manager, have good command on SQL, and Explain Plan Analyzing and collecting the statistics and Indexes.
• Experienced in TASM expertise to analyze the existing workloads using Teradata workload analyzer, designing, adjusting & monitoring the workloads using Workload Designer and Workload Monitor port lets.
• Expertise in handling the major, minor upgrades and establishing the DR plans and implementation.
• DDL Review and deployment into various environments
• Implementation of MVC
• Expertise in using Teradata Tools and Utilities (SQL Assistant, TD Administrator, BTEQ, Fast load, Multi-load, TPUMP and TPT etc.).

Confidential, Alpharetta, GA

Senior Teradata DBA

Environment: Teradata 13.10

Responsibilities:

• Expertise in using View Point in monitoring Teradata system, looking for bad and long running queries, monitor the sessions to identify the blocked sessions, setting TASM rules and to define TASM Workloads, developed TASM exceptions, implemented filters and throttles as need basis.
• User management (Login creation, user creation, granting and revoking permissions).
• Monitoring memory Usage and CPU Usage.
• Deploying DDLs into PROD/DEV/QA.
• Generating performance reports using PDCR.
• Scheduling Backups, Database Maintenance activities.
• Support 24/7 On-Call/backup responsibilities as part of a scheduled rotation with other team members and solving p1/p2/p3/p4 tickets before they get breached.
• Worked on Teradata system emulation (TSET) tool.
• Execute Diagnostic Help stats for session for queries to find missing stats on tables.
• Granting & Revoking of Object Rights, System Rights on Databases / Users / Roles.
• Set up Workload management rules and enabled the same from TASM Portlet.
• Modified based on the business requirements and health of the system to control the batch jobs and meet the SLAs.
• Using the DBQL and Access Log to monitor the database log.
• Having good working knowledge of TASM,Viewpoint, Teradata console utilities.
• BAR responsibility (NetBackup, TeraGUI) for daily and weekly Teradata backups.

Confidential

Teradata DBA

Environment: Teradata 12

Responsibilities:

• Appropriate Stats collection and scheduling.
• Executed Archive/Copy/Copy/Restoration of database using Arc main.
• Generating PDCR reports and analyzing system metrics.
• Creating / Modifying Users and databases as per Teradata best practices.
• Creating / Modifying User Roles and Profiles as per Teradata best practices.
• Granting / Revoking Privileges on objects to Users / databases and Roles.
• Database capacity management (space management PERM,SPOOL,TEMP).
• Collecting stats on tables / columns / indexes.
• Using Teradata visual explain, Teradata Index wizard, Teradata Statistics Wizard.
• Managing database space, allocating new space to database, moving space between databases as needed basis.
• Monitor Database / Table Space Usage &Skewness Confidential Database / Table / Vproc level.
• Monitor and Abort Sessions for blocked, high CPU consuming, highly skewed and long running queries.
• Performed the validations of the deployments.
• Used PDCR and CPPT tools for collecting facility to setup AMP usage collection, canary query response, spool usage response etc.

Confidential

Oracle/Teradata Developer

Environment: Teradata V2R5

Responsibilities:

• Having through knowledge of Teradata Architecture.
• Experience with Oracle, Teradata, BTEQ, Multi load, Fast Load, Fast Export, and TPump on Unix Platforms.
• Automation of day to day task by Shell Script.
• Strong knowledge in Teradata architecture, BTEQ, Writing Macros and Stored Procedure, Dealing with complex multi table queries, Extensive exposure to different types of loader (MLOAD, FASTLOAD, TPUMP).
• Executed SQL queries to verify data flow on UNIX platform.
• Developed Teradata FLOAD and MLOAD for populating new and already existing Teradata tables.
• Modifying PL/SQL programs using procedures, packages, triggers, functions.
• Loading data from various data sources and legacy systems into Teradata production and development warehouse using BTEQ, FASTEXPORT, MULTI LOAD, FASTLOAD and Informatica.
• Preparing weekly status report.