jessica claire montgomery street san francisco ca 94105 555 4321000 resumesampleexamplecom professional summary talented database administrator 12 years diverse experience database design administration data modeling data warehousing extensive technical skills advanced understanding sql server oracle postgres administration strong collaborator team player excellent communication skills expertise analytical problemsolving skills multiple databases sql server oracle postgres relational database management systems administration communications ms office implementing security measures running backups problem resolution work history sql server database administrator 122017 current genesis consulting group new carrollton md client name farmers insurance group duration nov 2017 till date location woodland hills ca client name united states automobile association duration feb 2017 nov 2017 location san antonio texas responsibilities sql server worked sql server 2016 2012 migration sql server 20082005 using backuprestore detachattach drivemount point mirroring worked sql server importexport moving data higher version lower version implementation sql logins roles authentication modes part security policies expertise designing databases capacity planning implemented merge replication cisco databases expertise alwayson availability groups aag hadr troubleshooting expertise database administration production servers server configuration performance tuning maintenance outstanding troubleshooting capabilities strong technical background along ability perform business analysis write effective documentation specifications handling database space issues administering sql server high availability disaster recovery strategies experience using dmv dynamic management functions finding long running queries worked extensively clustering server consolidation troubleshooting production issues raising high availability proficiency expertise sql server replication backuprecovery disaster recovery planning hands experience dr processes including log shipping database mirroring troubleshoot performance problems implemented alwayson aag sql server 2016 sp1 4 node configuration implemented alwayson aag sql server 2012 sp2 cu5 2 node configuration expertise alwayson availability groups aag hadr setup configuration recovering databases backup disasters implementing pointintime recovery solutions involved trouble shooting finetuning databases performance concurrency responsibilities oracle logging server setting environment creating users granting access creating schemas roles created db link per users request performing importexport schema level per users request executing scripts oracle databases spooling output scripts looking active sessions checking queries running longer checking database status rac using srvctl commands checking tablespace details increasing space required responsibilities postgres installing postgres linux server creating database connecting database creating users granting required access creating tables per application requirements taking backup restoring database using pgadmin tool stopping starting postgres instance creating schemas creating tables schema executing scripts postgres database using pgadmin tool sql server database administrator 062013 022017 genesis consulting group fort worth tx client name united states automobile association duration jun 2013 feb 2017 responsibilities worked sql server 2016 2012 migration sql server 20082005 using backuprestore detachattach drivemount point mirroring implementation sql logins roles authentication modes part security policies expertise designing databases capacity planning created silent install scripts installing sql server 2012 2016 without manual interruption expertise alwayson availability groups aag hadr troubleshooting expertise database administration production servers server configuration performance tuning maintenance outstanding troubleshooting capabilities strong technical background along ability perform business analysis write effective documentation specifications handling database space issues administering sql server high availability disaster recovery strategies experience using dmv dynamic management functions finding long running queries worked extensively clustering server consolidation troubleshooting production issues raising high availability proficiency expertise sql server replication backuprecovery disaster recovery planning hands experience dr processes including log shipping database mirroring troubleshoot performance problems implemented alwayson aag sql server 2016 sp1 4 node configuration implemented alwayson aag sql server 2012 sp2 cu5 2 node configuration strong experience mentoring team members writing documentation expertise alwayson availability groups aag hadr setup configuration rebuilding monitoring indexes regular intervals better performance recovering databases backup disasters implementing pointintime recovery solutions involved trouble shooting finetuning databases performance concurrency experience using sql server profiler sql server agent sql server database administrator 052011 062013 genesis consulting group boise id client name travelers insurance company duration may 2011 june 2013 responsibilities troubleshooting backup failure master rebuilt creating rcas migration databases lower version higher versions creating logins granting access users handling tlog space issue working clustering standalone sql servers failover clustering restoration dbs prod preprod dev etc creating logins providing access installing sql server 2005 2008 creating secondary data log files case space issues standalone clusters table refresh instances using import export creating databases table level restore install upgrade sql server production servers troubleshooting space issue creating scheduling change sql server database administrator 042007 052011 genesis consulting group columbia md client name microsoft duration june 2007 dec 2009 client name nike duration jan 2010 oct 2010 client name nestle duration nov 2010 may 2011 responsibilities troubleshooting backup failure migration databases lower version higher versions creating logins granting access users handling tlog space issue working clustering mirroring replication database mirroring failover clustering restoration dbs prod preprod dev etc creating logins providing access installing sql server 2005 creating secondary data log files case space issues standalone clusters creating maintenance plans scheduling jobs configuring replication adding article publications troubleshooting transactional replication issues table refresh instances using import export creating databases table refresh two servers using dts adding removing iis servers whenever needed install upgrade sql server production servers troubleshooting space issue moving system dbs another location master model msdb tempdb taking backups encryption key executing scripts users request patching sql server monitoring sql machines iis machines using sitescope tool checking sql replication ebis db metropolis db checking terminal servers delprof users facing issues bachelor science computer application 042006 bharathidasan university tiruchirappalli tamilnaduindia education certifications microsoft certified technology specialist mcts sql server 2005 certified hardware networking iiht indian institute hardware technology itil foundation service management