jessica claire montgomery street san francisco ca 94105 555 4321000 resumesampleexamplecom professional summary enthusiastic microsoft certified professional sql server dba 7 years experience eager contribute team success hard work attention detail organizational skills excellent reputation resolving problems improving customer satisfaction driving overall operational improvements consistently saved costs increasing profits microsoft sql server 2008r 2012 2014 2016 2017 installation upgrade migration patching service pack hadr solution skills backuprestore log shipping replication mirroring clustering always performance tuning sql server profiler sql server tuning advisor execution plan performance monitor activity monitor ssis ssrs remedy ticketing system jira windows 9598ntxpvista windows 200720082010 windows server 20082012r22016 vmware msword msexcel power point ms access visio ms publisher msoutlook methodologies agile scrum testdriven development vmware workstation80100 1410 1552 pro work history sql server dba 102017 current iron mountain fort myers fl performing daytoday dba core responsibilities maintaining supporting highpaced production environment meeting application team clients gather information regarding business requirements changes upgrade promoting daily script changes requested developers meet business requirements planning implementation backup important databases restorations per requirements performed transactional replication setup configuration monitoring creating sql server agent jobs perform overnight maintenance backups copy backups rebuilding indexes migrated onpremises sql server database azure virtual machine generate benchmark data performance needs perform performance tuning azure iaas support availability sets azure create maintain sow statement work document migration gradation using vmware deployed ha drs cluster managing resources migrating virtual machine configuration files virtual disks one data store another data store migration servers p2v v2v using vmware converter plate spin involved customizing vms memory hard disk nic analyzing log files resources utilizing monitoring installed administered fivenode always microsoft windows server 2016 enterprise edition san environment 247 support call provide administrative solutions make sure databases running normal configured maintained sql server 2012 failover clustering alwayson availability group utilized jira handle trouble tickets quickly addressed problem tickets maintained sql system records performed database consistency checks regular intervals 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 environment tsql sql server 20162012 oltp tcpip ssis etl windows 2007 2008 vmware workstation80100 1410 1552 pro sql server database administrator 072015092017 genesis consulting group gaithersburg md migrated sql server 2012 sql server 2014 microsoft windows server 2008 r2 enterprise edition installed administered twonode always microsoft windows server 2016 enterprise edition san environment installed configured sql server integration services ssis sql server reporting services ssrs used dmvs performance dashboard mirroring database snapshots tracking performance counters configured installed routers switches wireless controllers troubleshoot various network issues affect solutions collaborate staff outside vendors resolve complex problems installed configured cisco switches merge voice data network infrastructure rebuildingmonitoring indexes regular intervals better performance recovering databases backup disasters implementing pointintime recovery solutions involved troubleshooting finetuning databases performance concurrency involved source data analysis analysis designing mappings data extraction responsible design development ssis packages load data various databases files performed sql server profiler sql server agent database engine tuning advisor dta implemented snapshot isolation ddl triggers 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 environment sql server 201420122008 enterprise microsoft visio sql server dba 022013 062015 iron mountain newark ca leverage performance tuning optimization using native monitoring troubleshooting tools implementation sql logins roles authentication modes part security policies various categories users rebuilding indexes regular intervals better performance designed implemented comprehensive backup plan disaster recovery strategies implemented identifying bottlenecks caused complex queries using activity monitorsql profiler handling implementing better query execution plans involved troubleshooting finetuning databases performance concurrency monitored modified performance using execution plans index tuning rebuilding indexes regular intervals better performance deploying new code base release uat production environments perform sql server service pack windows service pack upgrades working customers application rollouts server migrations extensively worked enterprise manager managing database troubleshoot performance problems finetuning databases involved index analysis performance tuning migrating sql server 2012 databases sql server 2014 recovering databases backup disasters analyze long running slow queries tune optimize application system performance environment sql server 201420122008 enterprise microsoft visio 2010 sftp master science applied technology 2017 wilmington university new castle de education certifications microsoft database fundamentals mta98364 microsoft administering sql database infrastructure 70764 microsoft provisioning sql databases 70765 additional information microsoft certified professional 7 years administrative experience ms sql server 2016201420122008 r2 2008 2005 systems oltp olap environments hands experience installing ms sql server 2016 2014 2012 2008r2 2008 2005 associated database tools updating latest service packs hot fixes security patches proficient performance tuning installation configuration maintenance upgrade expertise deploying ssis packages development server integration testing qa production server expert using bulk copy program bcp data transformation services dts packages ssis integration services ms sql server 2005200820122014 extensive experience database high availability solutions using mirroring log shipping clustering activepassive cluster replication alwayson availability installed configured administered fivenode alwayson microsoft windows server 2016 enterprise edition san environment