Manager Management

EXPERIENCE

. Vinay Shet is an experienced IT professional and has 3 years of

experience in Information Technology out of which 2 years are as Teradata

DBA

. He is a Teradata Certified Professional (V2R5).

Experience on Teradata Database management tools like

KEY SKILLS Performance Monitor, Teradata Administrator, SQL Assistant etc.

and Performance management tools like Teradata Statistics

Wizard, Teradata Index Wizard, and Visual Explain etc.

Performance tuning at query level. Identifying suspect queries &

working towards solutions.

Code review of SQL's and suggesting improvement of Code in

various environments before it is deployed to Production.

Have extensive knowledge of Teradata and its utilities like

MLOAD, BTEQ, FASTLOAD and FASTEXPORT

TERADATA - Tools SQL Assistant, BTEQ, Fast Load, MultiLoad, Fast Export, Teradata

& Utilities Manager, Teradata Administrator, Teradata Statistics Wizard,

Teradata Index Wizard.

RDBMS Teradata V2R6, Teradata 12

CLIENT COMPANY : Teradata India Pvt. Ltd

ENGAGEMENTS CLIENT : WellPoint, Inc.

Duration : JAN 2011 till date

Environment: 4 Production servers having >300 Terabytes of

Production space.

Role : Teradata Application support Database

Administrator

Responsible for:

Creating Test and Development environments and granting

PREVIOUS access/privileges based on requirement without impacting the

EXPERIENCE Security policies.

Having regular meetings with the developers, Data Architects and

the project DBAs for the SDLC reviews and for query tuning

assignments

.

Performing QA checks on the DDLs for the newly introduced tables

in an LDM.

Performing Data copy jobs to maintain enough data in the SIT and

UAT region for

proper testing of codes.

Solving the tickets being assigned to the Teradata team.

Implementation of new codes in Production after proper testing

in the SIT and UAT environments.

Solving ad hoc requests for data backup, query tuning, space

management etc as per the user requirement.

Approving and Implementing Change Requests (RFC) according to

the standards specified by WellPoint.

Monitoring UAT/IR system using TD manager and notifying users

for any discrepancies

Suggesting Improvements in Release code by using Stats Wizard

and Index wizard and recommending stats and index required .

Using DBQL to identify bad running queries and suggesting

improvements in code.

COMPANY : Accenture Services Pvt Ltd

Client Name : SFR telecom, France

Project Name : SFR AO DWH BA09

Duration : June 2008 - Dec 2010, 30 Months

ROLE : Teradata APPS DBA & Developer

Worked in this projected Majorly as TERADATA APPS DBA and minor

role of Developer

Experienced in database management activities like performance

tuning, database objects creation, space management.

User Management (Creating users, assigning profiles, roles

depending on user's specification according to the

organizational policies and granting access/privileges)

Space management. Assignment/Movement of perm space in

development environment.

Writing COLLECT STATS scripts based on the existing as well as

adhoc queries and ETL loading scripts

Providing Spool space, Perm space Jobs wise and User wise usage

report provide whenever required.

BAR activities using VERITAS Net Backup

Teradata tools and utilities like PMon, Teradata Administrator,

Teradata SQL Assistant, BTEQ, knowledge on DBQL.

Creating Test and Development environments and based on

requirement without impacting the Security policies.

Creating views on tables in different database to avoid base

table access.

Identify Compression Opportunities and implementing them after

proper Approvals.

Hands on experience in Performance tuning of Teradata SQL

queries by verifying joins, statistics, index and other

performance related factors.

Involved in end to end DW development life cycle using Teradata

utilities. Loaded data into Teradata warehouse using Fastload,

BTEQ, and MultiLoad. Used Fast export and Bteq to send data to

external SSA(receivers)

Developed Unix Korn Shell scripts based on Load and Extract

Specifications using BTEQ, FASTLOAD, MLOAD & FASTEXPORT

utilities

Create and execute test plans for Unit, Integration, and System

test phases

Supported the production implementation of the Teradata data

warehouse, monitored jobs & fixed failed scripts

MEMBERSHIPS & Teradata certified professional (V2R5).

CERTIFICATIONS Teradata SQL V2R5

PUBLICATIONS & Own and maintain the following Teradata sites

OTHER ACTIVITIES: - www.teradatahelp.com

This site has around 300 unique visitors per day and 40,000 Site

visits since launch

www.teradata-interview-questions.blogspot.com

This site completely dedicated to All interview related

materials

WORK HISTORY Teradata India Pvt. Ltd. since Jan/2011 to till date

Accenture Service Pvt. Ltd, Since July/2008 till Dec/2010

EDUCATION B.E in Computer science from BMSCE, Bangalore.

Contact this candidate