profile jessica claire montgomery street san francisco ca 94105 555 4321000 resumesampleexamplecom worked 5 years sql server 20082008r2and 2012 database administration expertise database administration production servers server configuration performance tuning maintenance outstanding troubleshooting capabilities expertise tsql writing stored procedures triggers functions adhoc queries strong knowledge schemas administered sql server hadr strategies like log shipping database mirroring expert data transformation services like dtsbcp bulk insert implemented new new sql 2012 mechanisms like data compressions line indexing contained databasessecurity principals always availability group experience using dmv dmf finding long running queries worked extensively clustering server consolidation high availability mainly database mirroring log shippingreplicationclustering always proficiency sql server replicationback uprecoverydisaster recovery planning working configuring sql server security minimum privilege access troubleshoot performance problems finetuning queries index statistics working sql server 2012 migration sql server 20082008r experience troubleshooting production issues raising high availability memory configurations sql 201220082008r windows server experience supporting large database vldb troubleshooting problems experienced documentation follow microsoft recommended best practices capable working pressure able work independently excellent problem solving abilityskill work teamefficient organizing leading technical skills databases ms sql server 201220082008r2 programming tsql java script sql server tools managment studioprofiler query analizer import exportdtassis replication operating system window server 201220082008r2 nt windows third party tools iderasql litespeed professional experience sql dba apex systems meridian id environment sql server 201220082008r2 windows server 201220082008r2clustered always onssistsql others responsibilities monitored environment resources utilizations avoid bottlenecks installed configured sql database engineanalysis integration reporting servicesapply service packshot fixes developed company specific standard operating procedures major activities developed database back recovery strategies implemented hadr solutions using replication mirroring clustering always availability group tuned production server get performance improvement using third party tools profiler database tuning advisor created maintained groups roles managed security based limited access implemented tested point time recovery production databases migrated databases sql server 20082008r22012 2014 creates various jobs various servers set mail necessary informations threshold reached optimized performance queries modifications tsql queries resolve locking blocking issues others concurrency issues use database consistency checks dbcc responsible tuning database troubleshootinguser administrationmemory management running dbccrebuilding indexes fine tuning stored procedures junior dba yoam entertainment city state environment sql server 2008 windows server 2008 performance monitorand back utilities responsibilities monitored databases sql server production development test environment monitored software license usagerequested additional license needed conducted root causes analysis application availability narrow issues related database bottlenecks determined fixed problems related locking blocking migrated tested dts packages sql server 2008 education bachelor arts economics 2013 bahirdar university associate arts computer operator 2005 admas university college pharmacy tech 2015 us career institute