Rishabh cv

8
RISHABH SHUKLA                9643818950  [email protected]m Dynamic, result driven, Teradata DBA with 4 years of working experience wit hin the IT Arena, holdi ng deg ree of B. Tech in omput er !cience and "ngin eer ing . #r o$c ien cy in T era dat a Admin , %racl e Admin . &av e goo d experience in T eradata DBA activities like T eradata data'ase installations, data'ase maintenance activities, Archive() ecovery operations, T eradata user and data 'ase cre atio ns. re ating and mana ging user accounts. #r epar ed scripts for monitoring the system. )efreshed the data 'y using TA)A. *sed  T eradata Administrator an d T eradata +anager T ools for monitoring and control the system.  "xperience as a DBA in #roduction support and Development environment. "xtensive knowledge of Teradata Architecture. #roact ively monitor data'ase for 'locking issues, system capacity for #*, I% usage using )es*sage, DB- data Data Archive()estore /B* ( TA)A +anaging daily(0eekly management call and technical discussions with client "xperience in Teradata !-, Teradata *tilities +load, 1astload, 1ast"xport, %leload, Teradata #erformance +onitor, Teradata Administrator  !"ra#a$a 1% &"r$i'"# (r)"ssi*al+ ,racl" 11- &"r$i'"# Asscia$" BA RB/S  T eradata 234.3, 234, 235.3, 236, 26)7, %racle 8i, 9i, 3g A#mi*is$ra$r !ls 2iewpoi nt, T er adata +anager :T+;)< , T er adata Ad ministra tor :0inDDI<, T eradata !- As sistant :ue ryma n<, T erad ata Dyna mic 0orkl oad +ana ger :T D0+< , T er ad ata u er y !c he du le r, T er ad ata #erformance +onitor :#+%/<, T!"T. ("r)rma*c" A*alsis !ls  T eradata 2 isual "xpla in, T eradata !ys tem "mulation  T ool, T!"T, T eradata ! tatistics 0 i=ard, T eradata In dex 0i=ard (r)"ssi*al Summar !"ch*ical *2ir*m"*$

Transcript of Rishabh cv

8/9/2019 Rishabh cv

http://slidepdf.com/reader/full/rishabh-cv 1/8

RISHABH SHUKLA

               9643818950

        [email protected]

Dynamic, result driven, Teradata DBA with 4 years of working experiencewithin the IT Arena, holding degree of B. Tech in omputer !cience and"ngineering. #ro$ciency in Teradata Admin, %racle Admin. &ave goodexperience in Teradata DBA activities like Teradata data'ase installations,data'ase maintenance activities, Archive()ecovery operations, Teradata userand data'ase creations. reating and managing user accounts. #reparedscripts for monitoring the system. )efreshed the data 'y using TA)A. *sed

 Teradata Administrator and Teradata +anager Tools for monitoring and controlthe system. 

"xperience as a DBA in #roduction support and Development environment.

"xtensive knowledge of Teradata Architecture.

#roactively monitor data'ase for 'locking issues, system capacity for #*,

I% usage using )es*sage, DB- data Data Archive()estore /B* ( TA)A

+anaging daily(0eekly management call and technical discussions withclient

"xperience in Teradata !-, Teradata *tilities +load, 1astload, 1ast"xport,

%leload, Teradata #erformance +onitor, Teradata Administrator 

!"ra#a$a 1% &"r$i'"# (r)"ssi*al+ ,racl" 11- &"r$i'"# Asscia$"

BA

RB/S  Teradata 234.3, 234, 235.3,236, 26)7, %racle 8i, 9i, 3gA#mi*is$ra$r !ls 2iewpoint, Teradata +anager :T+;)<, Teradata

Administrator :0inDDI<, Teradata !- Assistant:ueryman<, Teradata Dynamic 0orkload +anager:TD0+<, Teradata uery !cheduler, Teradata#erformance +onitor :#+%/<, T!"T.

("r)rma*c"A*alsis !ls

 Teradata 2isual "xplain, Teradata !ystem "mulation Tool, T!"T, Teradata !tatistics 0i=ard, Teradata Index0i=ard

(r)"ssi*al Summar

!"ch*ical *2ir*m"*$

8/9/2019 Rishabh cv

http://slidepdf.com/reader/full/rishabh-cv 2/8

a$aas" U$ili$i"s  2proc+anager, !candisk and heckta'le

La# a*# U*la#U$ili$i"s

BT", 1ast "xport, 1ast -oad, +ulti -oad, Tpump and Teradata #arallel Transporter

Backu !ls /et2ault, /et'ackup and Teradata A)La*guag"s ,$h"rs !-, , >>, 'asic ?ava, *nix !hell !cripting,

Informatica 9..3,"ra$i*g Ss$"ms +#@)A!, -inux, !olaris, AI, 0indows #(/T(6

ricss* -lal

Duration Dec 634 Till DateDesignation !!I

lient +!D#BI

Industry Telecom

)ole DBA, onsultant

R"s*sil" )r

 Teradata #roduction DBA in a large environment.

"xperience with TD 36. and TD35.3 !ystems.

!ession monitoring to ensure throughput and session eCciency. "xperience using Teradata +anager, Teradata Administrator

2iewpoint to monitor and manage Teradata Data'ase.

reating Teradata o'Eects like Data'ases, *sers, #ro$les, )oles,

 Ta'les, etc.

+odifying Data'ases, *sers, )oles #ro$les.

Dropping Data'ases ( *sers.

;ranting )evoking of %'Eect )ights, !ystem )ights on Data'ases (

*sers ( )oles.

!ession +onitoring, A'orting sessions.

)eallocating Disk !pace +ove !pace. +onitoring Data'ase ( Ta'le !pace *sage.

+onitoring !kewness at Data'ase ( Ta'le ( 2proc level.

)eleasing *tility -ocks of 1astload ( +ultiload

Investigating !pace *sage +onitoring the growth of the data'ases.

opying o'Eects from one data'ase to another data'ase

Data movement from #roduction system to Development system.

"xecuting change reFuests for DD- D+- statements from the users

(r)"ssi*al 7"ri"*c"

8/9/2019 Rishabh cv

http://slidepdf.com/reader/full/rishabh-cv 3/8

+onitoring and Administering Backups.

ollecting !tatistics. Implementing #I )evision of ta'les, #artitioned #rimary Index

;ood DBA skills in Teradata )DB+!, production DBA support, use of 

1A!T-%AD, +*-TI-%AD, 1A!T"#%)T, Teradata !- and BT"

 Teradata utilities.

reation of data'ase and data'ase o'Eects like schemas, ta'les,

ta'le spaces.

)efresh the data across data'ases.

#erformance monitoring, analysing and creating reports.

+onitoring the system proactively to trace potential pro'lems and

take corrective measures. Implement and maintain Data'ase !ecurity :maintain users, roles,

assign privileges, pro$les<.

Documentation )eport()eview !ite Documents, !ystem !tudy,

Backup #olicy, Activity )eport, Incident )eport, +onthly !ervice

)eport etc.

H&L!"ch*lgi"s

Duration 1e' 634 /ov 634

Designation !enior !oftware "ngineer

lient Dixons )etail *.G.

Industry )etail and 1inance

)ole DBA, onsultant

 

R"s*sil" )r

 Teradata #roduction DBA in a environment of si=e 5.3 TB

"xperience with TD 26)7 !ystems.

!ession monitoring to ensure throughput and session eCciency.

"xperience using Teradata +anager, Teradata Administrator

2iewpoint to monitor and manage Teradata Data'ase.

reating Teradata o'Eects like Data'ases, *sers, #ro$les, )oles,

 Ta'les, etc.

8/9/2019 Rishabh cv

http://slidepdf.com/reader/full/rishabh-cv 4/8

+odifying Data'ases, *sers, )oles #ro$les.

Dropping Data'ases ( *sers. ;ranting )evoking of %'Eect )ights, !ystem )ights on Data'ases (

*sers ( )oles.

!ession +onitoring, A'orting sessions.

)eallocating Disk !pace +ove !pace.

+onitoring Data'ase ( Ta'le !pace *sage.

+onitoring !kewness at Data'ase ( Ta'le ( 2proc level.

)eleasing *tility -ocks of 1astload ( +ultiload

Investigating !pace *sage +onitoring the growth of the data'ases.

opying o'Eects from one data'ase to another data'ase

Data movement from #roduction system to Development system.

"xecuting change reFuests for DD- D+- statements from the users

+onitoring and Administering Backups.

ollecting !tatistics.

Implementing #I )evision of ta'les, #artitioned #rimary Index

;ood DBA skills in Teradata )DB+!, production DBA support, use of 

1A!T-%AD, +*-TI-%AD, 1A!T"#%)T, Teradata !- and BT"

 Teradata utilities.

reation of data'ase and data'ase o'Eects like schemas, ta'les,

ta'le spaces.

)efresh the data across data'ases.

#erformance monitoring, analysing and creating reports.

+onitoring the system proactively to trace potential pro'lems and

take corrective measures.

Implement and maintain Data'ase !ecurity :maintain users, roles,

assign privileges, pro$les<.

Documentation )eport()eview !ite Documents, !ystem !tudy,

Backup #olicy, Activity )eport, Incident )eport, +onthly !ervice

)eport etc.

  !"ra#a$a I*#ia (2$ L$#.

Duration Dec 636 1e' 634

Designation Associate Technical onsultant

lient ?+ 1amily *!A, Alcatel -ucent

8/9/2019 Rishabh cv

http://slidepdf.com/reader/full/rishabh-cv 5/8

Industry )etail and 1inance , Telecom

)ole DBA, onsultant

  R"s*sil" )r

 Teradata #roduction DBA in a large environment.

"xperience with TD 36. and TD35.3 !ystems.

!ession monitoring to ensure throughput and session eCciency.

"xperience using Teradata +anager, Teradata Administrator

2iewpoint to monitor and manage Teradata Data'ase.

reating Teradata o'Eects like Data'ases, *sers, #ro$les, )oles,

 Ta'les, etc. +odifying Data'ases, *sers, )oles #ro$les.

Dropping Data'ases ( *sers.

;ranting )evoking of %'Eect )ights, !ystem )ights on Data'ases (

*sers ( )oles.

!ession +onitoring, A'orting sessions.

)eallocating Disk !pace +ove !pace.

+onitoring Data'ase ( Ta'le !pace *sage.

+onitoring !kewness at Data'ase ( Ta'le ( 2proc level.

)eleasing *tility -ocks of 1astload ( +ultiload

Investigating !pace *sage +onitoring the growth of the data'ases. opying o'Eects from one data'ase to another data'ase

Data movement from #roduction system to Development system.

"xecuting change reFuests for DD- D+- statements from the users

+onitoring and Administering Backups.

ollecting !tatistics.

Implementing #I )evision of ta'les, #artitioned #rimary Index

;ood DBA skills in Teradata )DB+!, production DBA support, use of 

1A!T-%AD, +*-TI-%AD, 1A!T"#%)T, Teradata !- and BT"

 Teradata utilities.

reation of data'ase and data'ase o'Eects like schemas, ta'les,ta'le spaces.

)efresh the data across data'ases.

#erformance monitoring, analysing and creating reports.

+onitoring the system proactively to trace potential pro'lems and

take corrective measures.

Implement and maintain Data'ase !ecurity :maintain users, roles,

assign privileges, pro$les<.

8/9/2019 Rishabh cv

http://slidepdf.com/reader/full/rishabh-cv 6/8

Documentation )eport()eview !ite Documents, !ystem !tudy,

Backup #olicy, Activity )eport, Incident )eport, +onthly !ervice)eport etc.

Am#cs I*#ia (2$ L$#.

Duration +ay 63 ?uly 636

Designation !u'Eect +atter "xpert

Industry )etail and 1inance , Telecom

)ole %racle Teradata DBA

 Amdocs India Pvt Ltd is a leading global Telecom company, ofering their own

 products to provide Billing Solutions and other value added services to their 

enviable list o clients The global company uni!uely combines a mar"et#

leading BSS, $SS and networ" control product portolio with value#driven

 proessional services and managed services operations %ith revenue o 

appro&imately '() billion in *scal )+, Amdocs and its over -,+++

employees serve customers in more than .+ countries

(r"c$s Actively involved in various proEects such as ATT, )ogers, !print,2odafone, Telestra etc.

&*$riu$i*

As ,racl" BA

"xpertise in installing diHerent versions of %racle on */I platforms.

!trong hands on experience in applying #atches, #atchsets,

*pgradation.

on$guration, installation and management of )A /on@)A#roduction, Development and Test data'ase in 64J environments.

&ands on experience in data'ase migration cloning using )+A/ and

Datagaurd.

reating Ta'lespace, ta'le and managing !pace and *ndo !egments.

reating users, roles, pro$les, assigning roles and pro$les to users and

oncurrent +anager Administration.

8/9/2019 Rishabh cv

http://slidepdf.com/reader/full/rishabh-cv 7/8

Implementation of )ecovery +anager *tility :)+A/< for recovery and

periodic 'ack up. Developing, testing, continuously monitoring and updating the Backup

and )ecovery strategies for -ogical, old and &ot Backups.

Data'ase cloning from production to development server using hot

'ackup.

!trong conceptual skills in various methodologies in Data'ase

management systems and %racle Architecture.

As !"ra#a$a BA

0orking as a Teradata #roduction DBA in a large environment. &as experience with TD 36. and TD35.3 !ystems.

!ession monitoring to ensure throughput and session eCciency.

"xperience using Teradata +anager, Teradata Administrator

2iewpoint to monitor and manage Teradata Data'ase.

reating Teradata o'Eects like Data'ases, *sers, #ro$les, )oles,

 Ta'les, etc.

+odifying Data'ases, *sers, )oles #ro$les.

Dropping Data'ases ( *sers.

;ranting )evoking of %'Eect )ights, !ystem )ights on Data'ases (

*sers ( )oles. !ession +onitoring, A'orting sessions.

)eallocating Disk !pace +ove !pace.

+onitoring Data'ase ( Ta'le !pace *sage.

+onitoring !kewness at Data'ase ( Ta'le ( 2proc level.

Investigating !pace *sage +onitoring the growth of the data'ases.

opying o'Eects from one data'ase to another data'ase

Data movement from #roduction system to Development system.

"xecuting change reFuests for DD- D+- statements from the users

+onitoring and Administering Backups.

 

Bachelor of Technology : B. Tech.< in omputer !cience and

"ngineering in 69

o .

#uca$i*al uali'ca$i*

(RS,:AL !AILS

8/9/2019 Rishabh cv

http://slidepdf.com/reader/full/rishabh-cv 8/8

 Date of Birth 5 April 3988

  #ermanent Address !taH olony, *. #. !tate !pinning +ill,

  !omaiya /agar, Bara'anki, *. #., India @ 66K365

+arital !tatus !ingle