jessica claire 100 montgomery st 10th floor 555 4321000 resumesampleexamplecom summary detailoriented database administrator 6 years experience overseeing mission critical production vldb databases talented understanding business needs creating custom infrastructures expert technical troubleshooting maintaining servers skills microsoft sql server solarwinds sql server tuning database design projects migrate server onprem azure ssisssas ssrs createmanage troubleshoot sql profiler event viewer sql diagnostic manager database engine tuning advisor servicenow ticketing database experimentation assistant dea data conversion migration microsoft powershell idera monitoring tool sql sentry database deployment foglight database auditing microsoft net framework database administration presentations root cause analysis experience sql server dba 082021 012022 nbc universal beverly hills ca managed 300 databases 20 production vldb across multiple data centers maintained two different databases readonly reporting database disaster recovery database implemented disaster prevention recovery strategies supported high availability features like clustering always log shipping database mirroring replication produced highstandard database solutions meet stability reliability performance metrics resolved sql server problems conformance slas involves indepth knowledge sql server architecture connectivity replication backuprestore security continuous improvement developed custom database objects stored procedures delivered application support maintained security assigning log ins server permissions database roles performed database consistency checks dbcc defrag index tuning monitored error logs created optimal technical solutions user needs research indepth system analysis wrote maintained technical functional specifications document database intentions requirements planned implemented database backuprestore disaster recovery sql server dba 042018 082021 nbc universal installation maintenance sql server 2017201620142012 test development production environments standalone clustered servers administration maintenance 150 sql server instances hosting 600 databases devuatproddr environments installed patchedupgradedmigrated sql server 2005 2008r2 sql server 2012 2014 multiple devuatproddr servers strong experience working large databases vldb 50 tb oltp strong experience supporting maintaining sql server 20122014 two node cluster activepassive activeactive architecture worked closely development team database performance tuning code reviews provided vital inputs terms index optimization schema structures data changes work team 6 dbas designing implementing new sql server 2017 concepts like always availability groups hadr use secondary replica offload critical application read onlyreporting workload hence improving performance primary replica production databases supported daily database task like creating logins users fixed orphan user issues creating new databases disk space check consistency checks looking slowlong running queries hung jobs resolving end users database issues tickets experience designing implementing sql server backup recovery solutions full differential translog backups using sql server native tools using third party tools backup like veeam sql lite commvault experience implementing maintaining sql server hadr technologies like log shipping mirroring always fci troubleshooting related configurations issues implemented disaster recovery planning testing analyzing continuous update documentation involves change review meetings review analyze effect changes must made critical production databases worked upgrading cloning migrating sql databases sql server 20122008r220082005 experience using bcp exported imported data data sources like flat files using importexport dts ssis responsible monitoring making recommendations performance improvement hosted databases involved index creation index removal index modification file group modifications adding scheduled jobs reindex update statistics databases involved optimization performance tuning sql server using sql profiler performance monitor extended events dmvs activity monitor resource monitor thirdparty tools experience troubleshooting resolving application blocking locking deadlock issues using sp who2 sp active etc experience detaching attaching cloning sql server database database server dev test developer test codes experience setting sql server jobs monitoring notifications alerts database mail make sure jobs run successfully revert sql server errors windows event find root cause failed jobs expertise installing configuring sql server reporting services ssrs design develop different reports performance metrics checking database health using dbcc commands dmvs performed database integrity checks updated database statistics performed reindexing created managed schema objects tables views clusters indexes procedures triggers maintained referential integrity implementation sql logins roles authentication modes part security policies ensure backup recoverability enterprise sql server databases using native sql veeam sql lite backups created databases azure sql server paas iaas setup migrated databases onpremises datacenter azure using different techniques like azure data sync azure database copy bacpac files bcp import export experience writing editing tsql scripts database backup jobs dailyweekly jobs automated process work server infrastructure implemented capacity planning different server database servers migrate sql databases data sources relational cloudbased azure platform paas performed data partitioning efficient management database tables indexes maintaining database consistency dbcc regular intervals monitored modified performance using execution plans index tuning working clientserver tools like sql server enterprise manager query analyzer administer sql server experience applying service packs database os level experienced working agile environment using jira working company security governance team keep cooperated databases sox iso27001 hippa compliance support database disaster recovery efforts coordinate application owners ensure database recovery supports recovery times stipulated contingency plans managed specific systems technical analysis code review implementation 24 x 7production support used tfs source control managing development via tasksbugs design configures modify enhance applications necessary biweekly oncall support production environment environment sql server 201920172016201201420122008r2 windows 2008 2008 r2 2012 servers azure adonet red gate ms visio microsoft sql server visual studio 20052008 tsql ms business intelligence development studio 2008 fog lite sql lite speed nagios jira service desk idea diagnostic manager sql server dba 012016042018 nbc universal il expertise experience installing new instances sql server 2008 r2 2012 2014 microsoft windows server 2012 r2 following best practices monitored administered sql instances standalone servers cluster environment highly experience handling vldb ranging 500gb 3t different vms added total 50t uat dev prod environments installed administered 2 node cluster microsoft windows server 2012 r2 enterprise edition san storage strong experience database optimization tuning backuprestore troubleshooting data importexport expertise designing implementing processes standards database systems recovery backup checks well user performance data security updated database systems reviewing planning testing installing database security patches service packs expertise troubleshooting sql server agent jobs error logs windows logs resolve failure job component extensive experience monitoring making recommendations performance improvement hosted databases involved index creation index removal index modification file group modifications adding scheduled jobs reindex update statistics strong experience using dmvs dbccs sps sql server 2008r2 2014 checking database health performance expertise monitoring performance using sql profiler activity monitor perfmon find locking blocking deadlock issues expertise planning managing sdlc projects patching hot fixes service pack upgrades migrations experienced sql server migrations various versions planneddesigned migrated 7 prod database servers 6 dev db servers 5 uat db severs sql server 2008 sql server 2014 used place place upgrades experience dealing itops change review meetings changes approve implementations prod environment experienced recovering databases disasters implemented pointintime recovery solution analyzed defined capacity planning maintenance different database backups restore scenarios participated designing testing implementing enterprise disaster recovery plan set linked servers troubleshooting issues related odbc connectivity automated daily tasks including backup restore tools using sql server 20082008r220122014 native ssms tools experienced work coordination different teams like network team windows admins storage admins application teams well stakeholders customers experienced high availability solution always cluster mirroring log shipping experienced rewriting restructuring store procedures views tsql expertise writing technical reports management production support provided 24x7 production support sql server databases clustered servers sizes ranging 1 2 terabytes achieve maximum performance uptime production environment nvironment ms sql server 201420122008r2 tsql ssis asana redgate lightspeed sql profiler performance monitor bcp log shipping mirroring clustering windows server 2012r2 net framework cnet javascript ms tfs msaccess sharepoint 2010 oracle 10g iis 6575 80 solarwinds pal tool bachelor science biocemistry 082008 university maiduguri bornong education training