MADHAV I

P HONE: 404-***-****

E- MA I L : M ISQL77@GMAI L.COM

MICROSOFT S QL SERVER PRODUCT ION DATABASE AD M I N ISTRATOR

OBJECT IVE:

H IG HLY S ELF -MOT IVATED T EAM P LAYER W IT H E XCELLENT T ECH N ICAL A ND I N T ERPERSONAL COMMUN ICAT ION

S KILLS S EEK I NG A P ROFESSIONAL P OSI T IO N T HAT W ILL A LLOW M E T O A DD VALUE T O T HE O RGAN I ZAT ION .

P ROFESSIONAL SUMMARY:

● D ATABASE A DM I N ISTRATOR W I T H O VER 7YEARS O F IT E XPER IENCE A ND C URRENTLY WORK ING AS A

SQL DBA N TTDATA, GA.

A T C LIEN T

● E XTENS IVE MS SQL SERVER 2012,

E XPER IENCE IN I NSTALLAT ION OF

2008R2/2008/2005/2000VERSIONS .

● E XPER IENCE SQL SERVER I N -PLACE SI D E -BY-SI D E SQL 2005

ON A ND U PGRADES F ROM S ERVER

SQL 2005, SQL SERVER 2005 T O SQL SERVER 2008 R2.

TO S ERVER

● E XPER IENCE WI N DOWS 2008R2, WI N DOWS 2008, WI N DOWS

I N WORKI NG W I T H S ERVER S ERVER

2003, A ND WI N DOWS 2000 SERVER ’S.

S ERVER

● E XPER IENCE I N MANAGI NG SQL SERVERS O N V M WARE E NV IRONMEN T .

● E XPERT ISE I N P LAN N I NG A ND I M PLEME NT I NG SQL SECUR I TY, DATABASE P ERM ISSIONS, U SERS A ND

R OLES .

● H AVING SQL SERVER AGENT

H ANDS O N E XPER IENCE I N T ROUBLESHOOT I NG I SSUES W I T H A ND

SCHEDULED M A I N TENANCE T ASKS

● M ON I TOR I NG SQL 2005 A ND 2008 SYSTEMS U S I NG D MV S A ND P ROF I LERS .

● E XPER IENCE I N CREAT I NG J OBS, ALERTS, SQL M AIL, DB M AIL, SCHEDULE D TS P ACKAGES

SSIS P ACKAGES

A ND

● E XPER IENCE D ATABASE BACKUP, R ECOVERY D ISASTER R ECOVERY P ROCEDURES .

IN A ND

● E XPER IENCE I N WR IT I NG, D EBUGGI NG, A ND T U N I NG STORED P ROCEDURES T R IGGERS .

A ND

● E XPER IENCE SQL SERVER P ART I T IO N I NG A ND E NCRYPT ION .

I N N EW CONCEPTS L IKE

● E XPER IENCE R EPL ICAT ION SNAPSHOT,

I N I M PLEME NT I NG D I F FEREN T T YPES O F M ODELS L IKE

M ERGE T RANSACT IONAL .

A ND

● E XPER IENCE I N CONF IGURAT IO N, M A I N TENANCE A ND T ROUBLESHOOT I NG O F L OG S H I PP I NG .

● T RANSFORMED BULK COPY

DATA F ROM O NE S ERVER T O O T HER S ERVERS U SI NG T OOLS L IKE

P ROGRAM ( BCP), D ATA T RANSFORMAT IO N SERV ICES ( DTS), SSIS.

A ND

1

MADHAV I

P HONE: 404-***-****

E- MA I L : M ISQL77@GMAI L.COM

● H AVING SQL SERVER

K NOWLEDGE R EGARD I NG M EMORY ARCH I T ECTURE OF A ND T HE IR

R ECOMMENDAT IO NS F OR B ETTER CONF IGURAT IO N .

● E XPER IENCE P ERFORMANCE T U N I NG, Q UERY O PT I M I ZAT ION, CL IE NT /SERVER CON NECT I V I TY,

IN

D ATABASE D BCC U T I L I T I ES .

CONSISTENCY C HECKS U SI NG

● U SING P ERFORMANCE M ON I TOR /PROF I LER T O SOLVE D EAD L OCKS/L ONG R UN N I NG Q UER IES .

● E XPERT ISE W I T H T ABLE D ESIGN, I N DEX D ESIGN A ND P ERFORMANCE T U N I NG .

● I NVOLVED I N O PT I M I Z I NG CODE A ND I MPROV I NG E FF IC I ENCY I N DATABASES I NCLUD I NG RE-

I N DEX I NG, U PDAT I NG S TATIST ICS, R ECOMP I L I NG S TORED P ROCEDURES A ND P ERFORM I NG O T HER

M A I N TENANCE T ASKS .

● E XPER IENCE SSRS.

I N I NSTALLAT ION A ND CONF IGURAT IO N O F

● E XPER IENCE I N U SI NG T OOLS L IKE P ROF I LER A ND P ERFMON .

T ECHN ICAL SKILLS:

● O PERAT I NG SYSTEMS :WI N DOWS SERVER 2000/2003,2008,2008R2, WI N DOWS N T

4.0

W I N DOWS X P/98/95.

● L ANGUAGES :T-SQL, OSQL, C#, VB

● R DBMS :M S SQL SERVER 2008R2,2008,2005, 2000

● O LAP T OOLS :M S OLAP SERV ICES M ANAGER

● D ATA M ODELL I NG T OOLS :E RWIN

● SQL SERVER T OOLS : E N TERPR ISE M ANAGER, SSMS, P ROF I LER, Q UERY ANALYZER,

B IDS

E XPORT & I MPORT ( DTS), SSIS, R EPL ICAT ION,

SSRS

E DUCAT ION:

● B .T ECH . COMPUTER SCIENCE E NG I NEER I NG, J NT U N I VERSI TY, I N D IA

C ERT I F ICAT IO NS:

2

MADHAV I

P HONE: 404-***-****

E- MA I L : M ISQL77@GMAI L.COM

● M ICROSOFT CERT IF I ED T ECHNOLOGY SPEC IAL IST SQL 2008 – I MPLEMENTAT IO N &

IN S ERVER

M AI N TENANCE .

E MPLOYMENT H ISTORY:

CL IE NT : N TTDATA AT LANTA GA

J AN 2012- T I LL DATE

T ECH N ICAL R OLE : SQL SERVER P RODUCT ION D BA

N TTDATA I S O NE O F T HE T OP S OLUT ION P ROVI DER COMPAN I ES I N T HE COUNTRY A ND P ROV I DES

S OF TWARE

SOLUT IONS T O VARIOUS C L IENTS O F D I F FEREN T D OMA I NS ACROSS T HE WORLD .

R ESPONSIB IL I T I ES:

● T EST I NG A ND A NALYZ I NG T HE P ERFORMANCE O F S ERVERS T O F I N D T HE BASEL I NE O F W HEN

T HE S ERVERS W ILL G ET D EGRADED W IT H T HE I NCREASE I N T HE H I G H V OLUME O F DATA O R T HE

A DD I T IO N O F N EWER APPL ICAT ION T O T HE E X IST I NG V OLUME O F DATA O N F EWER DATABASES .

● TO SQL

A NALYZE T HE P ERFORMANCE O F S LOW R UN N I NG Q UER I ES U SI NG P ERFMON A ND

P ROF I LER .

● TO A NALYZE T HE E XECUT IO N P LANS O F S LOW R UN N I NG Q UER I ES T O F I N D T HE R OOT CAUSE O F

I TS S LOWNESS A ND CORRECT T HE I SSUE AS P ER T HE R ESULTS /REPORT O BTAI NED F ROM T HE

R ESEARCH .

● TO Q UER IES BY R EMOVI NG BOOKMARK /KEY L OOKUPS A ND R ID

F I NE T UNE L OOKUPS A ND T O

R EDUCE T HE COST O F T HE U T I L I ZAT IO N O F S YSTEM R ESOURCES .

● M ON I TOR I NG SQL 2005 A ND 2008 SYSTEMS U SI NG D MV S, P ROF I LERS A ND P ERFMONS .

● I NSTALLED A ND CONF IGURED SQL SERVER 2005 A ND 2008 D ATABASE, I N TEGRAT ION A ND

SERV ICES .

R EPORT I NG

● E XPER I ENCE I N SQL V M WARE E NV IRON ME NT .

M ANAGI NG S ERVERS O N

3

MADHAV I

P HONE: 404-***-****

E- MA I L : M ISQL77@GMAI L.COM

● M IGRAT ION O F DATABASES (SQL U PGRADE - S IDE BY S IDE M IGRAT ION ) F ROM SQL SERVER

2000 T O 2008 V ERSIONS

F ROM

● APPL I ED P OL ICY BASE M ANAGEMENT CONCEPT TO M A I NTAI N C ENTRAL I ZE S ERVER TO

M O N I TOR COMPANY S TANDARDS

● M OVI NG O F U SER A ND S YSTEM DATABASE F OR D ISK M A I N TENANCES A ND F OR O T HER P LAN NED

R ELOCAT IONS .

● T O SETUP CLUSTER E NV IRON ME NT T O T HE C URRENT E X IST I NG STANDALONE SQL I NSTANCES.

● D OCUMENTED D ISASTER R ECOVERY A ND H IG H AVAILABI L I TY P LANS.

● APPL I ED E NCRYPT ION O N SENSI T IVE DATABASES A ND D OCUMEN TED T HE P ROCESS F OR

DATABASE R EFRESHES

● M IGRAT ION D TS SSIS. T U NE D SSIS

OF PACKAGES T O E X IST I NG PACKAGES F OR B ETTER

P ERFORMANCE .

● WORKED W I T H E ND C L IENTS I N CAPACI TY P LAN N I NG F OR D ES IGN I NG N EW E NV IRONMENTS

● COMMU N ICATE W IT H I N TERNAL APPL ICAT ION T EAMS T O F IX A NY DATABASE R ELATED I SSUES .

● T ROUBLESHOOT I NG I SSUES R ELATED T O T OOLS, M ANAGEMENT ST UD IO /SEM, SQL AGENT –

SCHEDULED T ASKS, M AI NTENANCE P LANS, I MPORT / E XPORT WI ZARD, M IGRAT ION ADV ISOR

● T ROUBLESHOOT I NG S ECUR I TY A ND P ERM ISSION R ELATED I SSUES .

● T ROUBLESHOOT I NG ( L IKE : O UT O F M EMORY E RROR )

A LL T YPE O F M EMORY R ELATED I SSUES

A ND I SSUES R ELATED T O BASIC CONNECT IV I TY A ND F ULL T EXT S EARCH .

● T OOK CARE OF A LL P ERFORMANCE E SCALAT ION I SSUES L IKE I N DEX M ANAGEMEN T A ND

S TATIST ICS R ELATED I SSUES .

● I NVOLVED M I RROR I NG .

I N T HE CONF IGURAT IO N A ND A DM I N ISTRAT ION O F

E NV IRONMEN T : M S SQL SERVER 2000, MS SQL SERVER 2005, MS SQL SERVER 2008, WI N DOWS

2003 SERVER, WI N DOWS 2008 SERVER, SSRS, SSIS, B I, T-SQL, DTS, SSIS

CL IE NT : M ED ASSURANT, MD

J UL 2009-D EC 2011

T ECH N ICAL R OLE : SQL SERVER P RODUCT ION D ATABASE ADM I N ISTRATOR

4

MADHAV I

P HONE: 404-***-****

E- MA I L : M ISQL77@GMAI L.COM

M ED ASSURANT I S A H EALT HCARE T ECHNOLOGY COMPANY T HAT COMB I NES A DVANCED D ATA

A NALYT ICS W I T H H I G HLY T ARGETED I N TERVENT IO NS T O ACH IEVE M EAN I NGFUL I MPACT I N C L I N ICAL

O UTCOMES A ND F I NANCIAL P ERFORMANCE ACROSS T HE H EALT HCARE L ANDSCAPE .

R ESPONSIB IL I T I ES:

● I NSTALLED SQL SERVER 2008/2008R2 2008 CLUSTERS

I NSTALLAT ION O N W I NDOWS

● I NSTALLED SQL SERVER R EPORT I NG SERV ICES .

A ND CONF IGURED

● M IGRATED SQL SERVER 2000 T O 2008 V ERSIONS

F ROM

● SQL SERVER I N -P LACE SQL SERVER 2005 T O SQL SERVER 2008

U PGRADED F ROM

● APPL I ED PART I T IO N I NG ON F EW H UGE DATABASES F OR B ETTER M A I N TENANCE A ND

P ERFORMANCE

● APPL I ED E NCRYPT ION ON S ENSI T IVE DATABASES A ND D OCUMEN TED T HE P ROCESS F OR

DATABASE R EFRESHES

● D ESIGNED SSIS PACKAGES T O AUTOMATE T HE M A I N TENANCE P ROCESS

● T U NE D E X IST I NG SSIS PACKAGES T O P ERFORM B ETTER

● E N HANCED T HE DATABASE D ISASTER R ECOVERY M ANAGEMENT A ND P ERFORMED D R I LLS T O F I L L

U P A NY GAPS .

● E XPER I ENCE SQL V M WARE E NV IRON ME NT .

I N M ANAGI NG S ERVERS O N

● WORKED W I T H E ND C L IENTS I N CAPACI TY P LAN N I NG F OR D ES IGN I NG N EW E NV IRONMENTS

● T RAI NED D ATABASE

T HE T EAM T O E XPERT ISE I N M A I N TENANCE A ND CORRUPT IO N I SSUES

● P ERFORMED SQL D BCC

H EALT H C HECK U S I NG COMMANDS

● 24/7 S UPPORT O FFSHORE COORD I NAT IO N .

P ROVI DED W I T H

● U SED R EMEDY SAP

A ND AS T ICKET I NG T OOLS

● COMMU N ICATE W IT H CORPORATE C USTOMERS V IA T ELEP HONE, WRIT TEN CORRESPONDENCE, O R

M ICROSOFT SQL SERVER

E LECTRON IC S ERVICE R EGARD I NG P ROBLEMS I D E NT I F I ED IN

S OFTWARE .

● T ROUBLESHOOT I NG I SSUES R ELATED T O T OOLS, M ANAGEMENT ST UD IO /SEM, SQL AGENT –

SCHEDULED T ASKS, M AI NTENANCE P LANS, I MPORT / E XPORT WI ZARD, M IGRAT ION ADV ISOR

● T ROUBLESHOOT I NG S ECUR I TY A ND P ERM ISSION R ELATED I SSUES .

● T ROUBLESHOOT I NG ( L IKE : O UT O F M EMORY E RROR )

A LL T YPE O F M EMORY R ELATED I SSUES

A ND I SSUES R ELATED T O BASIC CONNECT IV I TY A ND F ULL T EXT S EARCH .

5

MADHAV I

P HONE: 404-***-****

E- MA I L : M ISQL77@GMAI L.COM

● T OOK CARE OF A LL P ERFORMANCE E SCALAT ION I SSUES L IKE I N DEX M ANAGEMEN T A ND

S TATIST ICS R ELATED I SSUES

● CONF IGURED ADM I N ISTERED R EPL ICAT ION, S H I PP I NG, M I RROR I NG

A ND L OG A ND

CLUSTER I NG .

● P ERFORMED BACKUPS, R ESTORES .

R EGULAR D UT IES L IKE

● CREATED SQL J OBS, M AI NTENANCE P LANS A ND SCHEDULED T HE M AS R EQU I RED .

● CONF IGURED D B M A IL S ETUP A ND N OT IF I ED STAKE H OL DERS O F A NY J OB FAILURES .

● R ESOLVED SQL CONNECT I V I TY A ND S ECUR I TY I SSUES F OR T ECH N ICAL A ND N ON -TECH N ICAL

S TAFF .

E NV IRONMEN T : M S SQL SERVER 2000, MS SQL SERVER 2005, MS SQL SERVER 2008, WI N DOWS

2003 SERVER, WI N DOWS 2008 SERVER, SSRS, SSIS, BUSI NESS I N TELL IGENCE, T-SQL, DTS,

P ATROL, BMC I MPACT M ANAGER, SAP-CRM.

E MPLOYEE : V IS ION SYSTEMS GROUP I NC J U NE .

2006-J U NE 2009

T ECH N ICAL R OLE : SQL D ATABASE ADM I N ISTRATOR

V IS ION SYSTEMS GROUP, I NC I S A S ERV ICE A ND S OLUT IO N P ROVI DER COMPANY . T H IS P ROJECT I S T O

D BA S UPPORT T O I TS R ESPECT IVE V ENDOR ’S /CL IE N TS .

P ROVI DE

R ESPONSIB IL I T I ES:

● I NSTALLED M S SQL SERVER D ATABASES R &D, SYSTEM T EST,

A ND M A I NTAI NED OF

ACCEPTANCE T EST P RODUCT ION SERVER .

A ND

● M AI NTAI N I NG R EPL ICAT ION

T HE T RANSACT IONAL S ERVER A ND L OGSH IPP I NG

● CREATED SCR IPTS T O M O N I TOR T HE S ERVERS

● D ESIGNED SCRIPTS T O AUTOMATE T HE M A I N TENANCE T ASKS

● WORKED O N D EADLOCKS I SSUES A ND M I N I M I ZE D T HE OCCURRENCE O F T HESE S ITUAT IONS

● WORKED O N VARIOUS P ERFORMANCE I SSUES .

● P ERFORMED Q UERY P LANS A ND M ADE S URE E ACH A ND E VERY Q UERY I S U SI NG APPROPRIATE

I N DEXES

6

MADHAV I

P HONE: 404-***-****

E- MA I L : M ISQL77@GMAI L.COM

● I NSTALLED SQL 2005 I NSTANCES WI N DOWS 2003 CLUSTERS

S ERVER ON

● M IGRATED SQL SERVER 2000 T O SQL SERVER 2005

● I NVOLVED M S ACCESS M S SQL SERVER 2000

I N T HE M IGRAT ION O F DATABASES T O

● SCHEDULED BACKUPS A ND P ERFORMED R ESTORE O PERAT IO NS F OR S YSTEM T EST D ATA

D EPENDS O N T ESTERS ’ R EQU I REME NT .

● CREATED L OG I NS A ND M A I NTAI NE D U SER P ERM ISS IO NS A PPROPR IATELY .

● M IGRAT ION O F SYBASE S TORED M S SQL SQL

P ROCEDURES TO DATABASES U S I NG

S TANDARDS .

● T ROUBLESHOOT L I NKED SERVER I SSUES

E NV IRONMEN T : M S SQL SERVER 2000, MS SQL SERVER 2005, WI N DOWS 2003 SERVER,

SSRS, SSIS, M S V ISUAL 2005, T-SQL, DTS, P OWER BU I L DER, C#.

S TUD IO

7

Contact this candidate