Name: M.A.

Haneef Khan Mobile: 91- 8124525115

E-Mail: hkhan.it@gmail.com

!ofe""ional #$mma!%
Having 3.6 years of experience in IT industry, with strong skills as M#-#&'
#e!(e! )ataba"e A*mini"t!ato!.
Ke% +e",on"ibilitie" a" a #&' #e!(e! )-A
Database d!inistration with proficiency in "#$ "erver %&&' ( %&&) *roduction
+nviron!ent.
*roviding day,to,day "upport and -aintenance for "#$ "erver databases.
Involved in Installation and configuration of -","#$ "erver %&&', %&&), %&.% in
/indows environ!ent.
0esponsible for -igrating databases fro! "#$ server %&&' to "#$ "erver %&&).
d!inistering high availability solutions like replication, !irroring and clustering.
"etting up !irroring and replication in newly deployed production servers.
*erfor!ing and !aintaining all types of Database backups and recovery
operations.
*erfor!ing !aintenance tasks like rebuilding1reorgani2ing indexes and update
statistics.
0esolving space !anage!ent issues like Data and log file space issues.
Identifying and resolving 3locking by using ctivity -onitor, "yste! stored
procedures and *rofiler.
Identifying and resolving frag!entation and index,statistics issues.
4oordinating with user to resolve login failures.
*erfor!ing !irror failover of databases which involves in !irroring and
replication.
*erfor!ing 4luster failover during windows patching activity.
Troubleshooting per!ission issues faced by users.
0efreshing databases fro! prod to test and prod to develop!ent environ!ent.
0eleasing table level changes in production servers during the change window.
*atching the s5l server instances by applying 4u!ulative updates and
coordinating the downti!e with windows and application tea!s.
0esolving tran log full alerts.
4learing blockings by finding the lead blocker and providing the details to user to
tune the 5uery.
Troubleshooting the long running 5ueries and asking developers to tune the
5uery.
!ofe""ional E.,e!ience
4urrently working as "pecialist with H/' 0echnologie" 't*., /hennai.
E*$cational &$alification
3.T+4H in Infor!ation Technology fro! 6aya *rakash 7arayan college of
+ngineering, affiliated to 1N02 2ni(e!"it%3 H%*e!aba*.
0echnical /e!tification"
45-462: M/0#,Mic!o"oft /e!tifie* 0echnolog% #,eciali"t fo! #&' #e!(e!
2558 7m,lementation an* Maintenance.
45-455: +8 -)e"igning3 8,timi9ing3 an* Maintaining a )ataba"e
A*mini"t!ati(e #ol$tion 2"ing Mic!o"oft #&' #e!(e! 2558.
0echnical #kill"
8,e!ating #%"tem" : /indows %&&&, %&&3 ( %&&).
'ang$age" : 4, 488.
+)-M# : -","#$ "erver %&&&1&'1&) ( %&.%
#&' #e!(e! 0ool" : ""-", #uery naly2er, *rofiler, DT
Net:o!king : 447, -4"+
/$!!ent !o;ect )etail"
*ro9ect 7a!e : -icron.
4lient : -icron Technology, Inc. ;".
Tea! "i2e : %<.
+nviron!ent : "#$ "erver %&&&1%&&'1%&&), /indows "erver %&&31%&&)10%.
3ackup tool : Data protection !anager =D*->
-onitoring Tools : 3-4 *atrol.
Ticketing "yste! : 0e!edy.
0ole : "#$ "erver Database d!inistrator.
)e"c!i,tion:
Mic!on 0echnolog%3 7nc. is an !erican !ultinational corporation based in 3oise,
Idaho, ;", best known for producing !any for!s of se!iconductor devices. This
includes D0-, "D0-, flash !e!ory, ""D and 4-?" i!age sensing chips. Its
consu!er products are !arketed under the brands 4rucial Technology and $exar -edia.
-icron and Intel together created I- @lash Technologies, which produces 77D flash
!e!ory.

+e",on"ibilitie":
-onitoring !ore than <&&&8 databases. -any of the! support high availability
=-I00?0I7A /ITH 0+*$I4TI?7>.
Installation and building new "#$ servers.
Taking backups regularly through 9obs.
4hecking the status of 3ackup, troubleshooting the failed backups.
3ackup ( restoration of databases using D*-.
-onitoring D3 space -anage!ent issues and allocating the re5uired space to
databases.
-onitoring 3-4 re!edy incidents, service re5uests and creating 0@4s for
production release.
4oordinating with service owner, application tea! in getting the production
change window approved by creating 0@4.
-onitoring !aintenance 9obs, troubleshooting on failure and addressing alerts.
Installing and !icroni2ing the "#$ server %&&' , %&&) , %&.% and applying the
service packs.
-onitoring the te!pdb full and transactional log full issues.
I!port1+xport data fro! different databases.
ssigning user per!issions like Arant, Deny and revoke per!issions using ID-
Tool.
Daily checking of backup failure in D*-, failed logins and resolving the issues.
4onfiguring, !aintain !irroring and troubleshooting the !irroring issues.
4reating ( !aintaining Database files, Transaction log files.
pplying "#$ "erver patch and Hot fix.
-anaging Data and $og file growth.
Troubleshooting blocking issues.
Aot training in -","#$ "+0B+0 %&.%, i!ple!ented $/C"?7 on 3 node
windows failover cluster during training.
Installed and deployed "#$ server %&.% in production with huge database si2e of
.<&&A3.
High A(ailabilit% Acti(itie":
4onfiguration and rebuilding !irroring, worked on troubleshooting issues with
!irroring.
-aintained databases that support !irroring along with replication.
*erfor!ed @ailover of databases which are !irrored cu! published to the standby
node by setting up aliases in distributor using powershell script and -atrix tool.
4onfiguration and Troubleshooting issues in Transactional 0eplication.
/orked in reducing replication delay =latency> between *ublisher and "ubscriber
servers.
I!provised the "#$ server by perfor!ing proper defrag!entation of data and
update statistics.
Troubleshooting high 4*;, !e!ory ;tili2ation.
/orked on "#$ "erver !igration fro! %&&& to %&&'1%&&) and %&&' to %&&) and
fro! old hardware to new hardware.
e!"onal )etail"
7a!e : -. Haneef Dhan
-arital "tatus : "ingle
7ationality : Indian
$anguages known : +nglish, Hindi and Telugu.
*referred location : H%*e!aba*<-angalo!e.