SUMMARY

• Having 8+ years of experience in IT industry, with 7+ years of experience in Administering Teradata databases in Production and Non - Production environments and 1 year of exp in development of web based enterprise applications using Java.
• Provided 24X7 support services to all Teradata RDBMS customers across the world.
• Experienced working with a complex system of size more than 1 PetaByte having 57 nodes with 1482 AMP’s.
• 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, AJI, PPI, MLPPI), to use temp tables like Volatile/Global Temp Tables, applying Compression, etc
• Implemented various Teradata recommended best practices in Optimization & Performance Tuning.
• Extensive knowledge in Teradata Architecture, Design, Development and Optimization of applications.
• Extensive knowledge in Teradata Utilities: Multi Load, Fast Load, TPT, Fast Export, TPUMP, BTEQ and Teradata SQL Assistant.
• Proficient in using Teradata Administrator for managing Databases, Users, Tables, Indexes, statistics, managing permissions( Roles & Profiles), addressing the user issues such as resetting passwords, unlocking user ID’s etc.
• Hands on working with Teradata Viewpoint as a part of eyes on glass activity monitoring and aborting bad queries, looking for blocked sessions and working with development teams to resolve blocked sessions.
• Work with Developers & DM on troubleshooting and fine tuning of scripts.
• Worked with DM team to review the Data models and finalize the objects.
• Worked on PDCR to generate performance related reports.
• Knowledge on Data Modeling tool Erwin7.
• Have good knowledge on Bigdata/Hadoop Architecture and knowledge on Bigdata tools Hive, Pig, Sqoop and Hadoop MapReduce.
• Migration of database objects across different environments.
• Worked Extensively in Query Processing, Query Tuning and Administration activities of Teradata.
• Worked on BAR (Backup, Archive and Recovery) Activities using the TARA GUI and VERITAS Net backup.
• Experienced working as on-call/production support DBA.
• Good Experience in Creating and managing user accounts.
• Proficient in Server tools Teradata Manager, Teradata Administrator, PMON.
• Good communication skills, combined with Confidential ce and determination to troubleshoot complex multi-system issues

TECHNICAL SKILLS

Operating Systems: Unix, Windows 95/98/NT/2000/XP

Programming languages: C, C++, java

Query languages: SQL, PL/SQL, Teratata SQL

Databases: TD14/TD13.10/TD 12/V2R6, Oracle 9i/8i, SQL Server 2005/2008

Backup tools: VERITAS Net Backup, ARC, TARA GUI

Teradata Utilities: BTEQ, Fast Load, Multi Load, TPT, FEXP, TPUMP

Query tools: SQL Assistant, Toad

Modeling tools: Erwin 7

System monitoring: View Point, Performance Monitor(PMON), Teradata Manager

Database Administration: Teradata Administrator, Teradata manager, DBQL, PDCR

Web Servers: Weblogic Server 8.1, Tomcat Server 6.x

PROFESSIONAL EXPERIENCE

Confidential, Columbus (OH)

Sr. Teradata DBA

Responsibilities:

• Building up ICDW environment with integrating different Line of Business data.
• Working with different development teams for the migration of data from existing DB2 database to Teradata database.
• Very good knowledge in Data mover, Load/Unload Utilities like Mload, Fast load, FastExport, TPT
• Monitoring of all systems using Viewpoint and addressing the issues with application teams
• Teradata Administrator - graphical Windows tool to assist in administration
• Having good exposure in PDCR
• Managing the Backup/Restore through TARA application
• Performance tuning of issued queries.
• Working on Data refreshes through Data mover.
• Working on various ticketing tools (i.e. EURC, Peregrine and ITSM)
• User administration by creating and managing privileges of user
• Creating and managing databases.
• Setting up roles and profiles.
• Object migrations.
• Space Management.
• Resolving spool & Perm space issues.
• Reviewing code before migration to higher environments.
• Performing peer review & sign-off from the DBA side for any changes getting implemented on the warehouse.
• Did performance tuning, analyzing explain plan, DBQL/PDCR data and recommending additional statistics.
• Recommendation of Primary Indexes for better distribution during migration
• Perform Compression Analysis on Database Objects and provide Recommendations on Multivalue compression Values.
• Performance monitoring, investigating long running queries and Tuning them.
• Generating PDCR reports and analyzing system metrics.
• UAT issues using PEREGRINE system.

ENVIRONMENT: TD 14, Teradata Viewpoint, TARA, Teradata Administrator, Teradata Index wizard, Teradata SQL Assistant, Data mover, Control-m scheduler and Teradata utilities like Bteq, Fastexport, Fastload, Mload, Arcmain, TPT, etc.

Confidential, Columbus, OH

Sr. Teradata DBA

Responsibilities:

• Responsible for day to day administration of Teradata database.
• Monitoring bad queries, aborting bad queries using Teradata Viewpoint, looking for blocked sessions and working with development teams to resolve blocked sessions.
• Worked extensively on Performance Optimization of various database applications.
• Created Users, database structures, established Roles, Profiles as per the Requirement.
• Worked extensively with DM team to implement the Primary Indexes while creating the tables.
• Used Teradata Load utilities FLOAD, MLOAD, TPUMP, and BTEQ to load data from flat files to Staging.
• Monitoring database, Identifying highly skewed tables, managing space.
• Creating and managing databases.
• Setting up roles and profiles.
• Object migrations.
• Space Management.
• Resolving spool & Perm space issues.
• Documented the best practices to be followed in Teradata Administration.
• Redesigning the Logical Data Models, and Physical Data Models.
• Generating PDCR reports and analyzing system metrics.
• Moved the DDL from DEV to QA as per the Service Requests and QA to PROD as per The Change Management Process.
• Did performance tuning, analyzing explain plan, DBQL/PDCR data and recommending additional statistics.
• Recommendation of Primary Indexes for better distribution during migration
• Perform Compression Analysis on Database Objects and provide Recommendations on Multivalue compression Values.

ENVIRONMENT: TD 13/13.10, Teradata Viewpoint, TARA, Teradata Administrator, Teradata SQL Assistant, Data mover, Control-m scheduler and Teradata utilities like Bteq, Fastexport, Fastload, Mload, Arcmain, TPT, etc.

Confidential

Teradata DBA

Responsibilities:

• Managing database space, allocating new space to database, moving space between databases as need basis.
• Monitor workloads and suggest best practices
• Worked on Teradata administrator for creating users and also did cleanup activities through the tools.
• Interpret Explain Plans and collect statistics to improve performance of long running queries
• Usage of DBQL and PDCR for qry logs access and see how the query performed historically
• Recommendation on collect statistics to make the optimizer confident
• Made recommendations to make sure the PPI's get used when reports are designed
• Got involved and made recommendations at the design level to avoid last minute tuning or surprises on the database
• Identifying the data for Purging and Archiving on regular basis.
• Validate PI/UPI/USI and also check whether they are used in frequent join columns.
• Have hands on experience in generating SQL scripts from the model using Erwin.
• Worked on 'Complete Compare' to compare the Logical and Physical models and generating the reports in different formats.
• Have worked on creating reports using Report builder.
• Worked on reverse engineering a model from Physical Database.
• Prepared the SQL scripts for SIT, UAT and Prod changes.

ENVIRONMENT: Teradata 12, TD Admin, Teradata Manager, PMON, Teradata ViewpointTeradata SQL Assistant, Multiload, FastLoad, FastExport, BTEQ, DBQL, Eriwn 7.

Confidential

Teradata DBA

Responsibilities:

• 24*7 Production support.
• Monitoring database using Viewpoint.
• User administration by creating and managing privileges for user
• Creating and managing databases.
• Data refresh across environments.
• Managing and allocating space for the databases.
• Managing Backups/Recovery by Teradata application TARAGUI
• Code Reviews and Migrations across different environments.
• Resolving spool & Perm space issues.
• Roles and Profiles Management
• Perform Compression Analysis on Database objects and provide recommendations on Multivalue compression values.
• Good understanding in analysis of locks, indexing.
• Archiving and Purging of Tables.
• Tuning the queries having performance issues.
• Advice structural changes and gives STATS collection recommendations wherever required.
• All DBA related activities through SQL ASSISTANT, Teradata Administrator and Viewpoint.
• Sending the Daily DBA reports (Node Usage, user query count, Production space, Memory Utilization...etc.).
• Generating reports like: long running queries report, high CPU impact queries report, high spool consuming queries report.

ENVIRONMENT: Teradata 12, TD Admin, Teradata Manager, PMON, Teradata ViewpointTeradata SQL Assistant, Multiload, FastLoad, FastExport, BTEQ, DBQL.

Confidential

Teradata DBA

Responsibilities:

• Actively participated in Data migration from V2R6 to TD12.
• Recommendation of Primary Indexes for better distribution during migration project
• Monitoring the system using PMON
• Creating and managing databases.
• Creating and managing user accounts with appropriate security.
• DBQL Analysis to get more performance impacted queries.
• Run and schedule the Teradata scripts through JCL and check whether data has been migrated or not.
• Doing space management while the migration is under process to avoid the failure of jobs.
• Sending the reports of completed databases for archiving.
• Involve in weekly meetings to give updates on the status and to discuss the issues.
• Maintaining the issue logs for future reference and to easy the process further.
• Maintain Knowledge Repository with current training materials and other documents

ENVIRONMENT: Teradata 12, TD Admin, Teradata Manager, PMON, Teradata SQL Assistant, Multiload, FastLoad, FastExport, BTEQ, DBQL.

Confidential

Teradata Developer

Responsibilities:

• Extensively worked in Data Extraction, Transformation and loading from source to target system using Bteq, Fastload, and Tpump.
• Involved in writing scripts for loading data to target data warehouse for Bteq, Fastload, TPUMP
• Mainly did error handling in ET, UV and Work tables.
• Did error handling and performance tuning in Teradata queries and utilities
• Did data reconciliation in various source and in Teradata
• Scheduling the jobs using Dollar universe.
• Conducted Unit testing.

ENVIRONMENT: Teradata 12, Teradata SQL Assistant, Multiload, FastLoad, BTEQ, FastExport, DBQL.

Confidential

Java Developer

Responsibilities:

• Design and development of application layer
• Unit testing and deployment.
• Coded JSPs and Java Classes (Service and Database Interaction classes)
• Developed Action classes and Form beans in Struts framework
• Developed DAO (Data Access Objects) to access the applications databases (Oracle) and retrieve the result sets using JDBC
• Involved in Support & Enhancement for all Modules.

ENVIRONMENT: Servlets, JSP, Struts, Oracle.