jessica claire montgomery street san francisco ca 94105 555 4321000 resumesampleexamplecom summary professional 6 years experience working complex database environments focus sql server key strengths performance tuning capacity planning high availability solution disaster recovery planning managing complex addons sql server 20002017 migrationupgrade applying service packs routine dba activities like database health check index optimization updating statistics clientserver connectivity capacity planning database backup restorerecovery query optimization sql server installation configuration standalone multiple instances non clustered environments etc highly motivated professional 6 years strong experience mssql server 2000 2017 administration good experience field database technology experience designing developing implementing databases good documentation experience working agile environment experience translating business requirements conceptual logical physical data models experience administering managing configuring rdbms database design performance tuning optimization disaster recovery planning execution testing backup automation backup capacity planning consulting encryption disaster recovery dml firewall managing mail processes quality reporting servers scripts tables skills tsql troubleshooting upgrade agile methodology high availability solution disaster recovery planning managing complex addons sql server 20002017 migrationupgrade index optimization updating statistics clientserver connectivity capacity planning database backup restorerecovery query optimization sql server installation configuration standalone multiple instances non clustered environments etc experience sql server database administrator 082018 current genesis consulting group washington dc experience using sql server tools like importexport wizard ssms sql profiler extended events sql query analyzer database engine tuning advisor dta redgate servicenow etc production support 247 environment project support achieved 999 uptime sql servers interacts clients application team project managers design implement support solutions meet client needs installed configured sql 2008 2012 2014 2016 2017 standalone clustered environment availability groups performed different sql server version upgrade standalone cluster instances complex database environments production test development environments provides support appteam bi team security team ops team execute production implementations deployments install configure ssrs reporting create database mail notifications alerts settings job failures resource deficiencies sql server profiler extended events query store database engine tuning advisor dta performance create logins server level users database level also create database roles groups users configured alwayson availability group disaster recovery trouble shoot complex issues always availability group provide stable environment availability group replicas databases frequent failovers system monitoring proper allocation resources troubleshooting client connectivity deadlock resolution sql server performance dashboard reports monitoring performance baselining manage indexes improve performance schedule jobs using sql server agent developed routine jobs data integrity check managing server database security identity provide support volumetric encryption security database vulnerability check databases security configured maintained contained databases task automation implementation snapshot isolation dml triggers stable replication topology planning implementation database backuprestore disaster recovery upgrade sql server 2012 2014 2016 sql server 2017 maintained database response times 24x7 production environments developing sql scripts maintaining administration tasks capacity planning resource allocation monitoring standby databases ensure high availability sql server database administrator 032016 072018 genesis consulting group lincoln ne sql server profiler extended events query store database engine tuning advisor dta performance create logins server level users database level configured supported replication configured alwayson availability group disaster recovery system monitoring proper allocation resources created managed table compression partitions troubleshooting client connectivity deadlock resolution sql server performance dashboard reports monitoring performance baselining manage indexes improve performance schedule jobs using sql server agent developed routine jobs data integrity check managing server database security identity managing firewall rule trigger temporal tables change data capture cdc configured transparent database encryption tde security configured maintained contained databases task automation indexes maintenance stabilized performance implementation snapshot isolation dml triggers stable replication topology planning implementation database backuprestore disaster recovery upgrade sql server 2008r2 servers sql server 2014 maintained database response times 24x7 production environments developing sql scripts maintaining administration tasks capacity planning resource allocation monitoring standby databases ensure high availability sql server database administrator 062014 032016 jacobs engineering group inc wallops island va nigeria sql server profiler extended events query store database engine tuning advisor dta performance create logins server level users database level configured supported replication configured always availability group disaster recovery system monitoring proper allocation resources created managed table compression partitions troubleshooting client connectivity deadlock resolution sql server performance dashboard reports monitoring performance baselining manage indexes improve performance schedule jobs using sql server agent developed routine jobs data integrity check managing server database security identity managing firewall rule trigger temporal tables change data capture cdc configured transparent database encryption tde security configured maintained contained databases task automation indexes maintenance stabilized performance implementation snapshot isolation dml triggers stable replication topology planning implementation database backuprestore disaster recovery upgrade sql server 2008r2 servers sql server 2014 maintained database response times 24x7 production environments developing sql scripts maintaining administration tasks capacity planning resource allocation monitoring standby databases ensure high availability role jr sql server database administrator installed sql server 2012 advanced servers applied security fixes maintain overall database integrity quality including routine data improvement create logins server level users database level documented processes installations upgrade maintained database response times 247 production environments proactively generated performance reports automation dba tasks monitoring planning implementation database backuprestore disaster recovery database mail operator tables design views stored procedures function etc capacity planning resource allocation monitoring standby databases ensure high availability maintained sql server database ensured accuracy information automated numerous functions fine tuning database objects server ensure efficient data retrieval monitor optimize system performance using sql profiler database engine tuning advisor schedule jobs using sql server agent education training bachelor science public administration 122008 enugu state university science technology enugu state nigeria msca inview certified scrum master certified software tester activities honors certifications