jessica claire resumesampleexamplecom 555 4321000 montgomery street san francisco ca 94105 professional summary microsoft certified database administrator experience administering supporting sql server production development test environments strong interpersonal skills ability work independently well team environment highly skilled problem solving expert ms sql server installation configuration upgrading microsoft sql servertm 20122014201620172019 experience regularly patching upgrading evaluating database technology security updates hot fixes version releases ensure architecture stability ensured disaster recovery using backup log shipping mirroring replication alwayson high availability using log shipping mirroring failover clustering alwayson high availability groups proficient tsql programming writing stored procedures functions triggers run automate maintenance tasks backups integrity checks index rebuild reorganization using sql job agent ola script skills technical skills database microsoft sql server cloud computing microsoft azure azure data factory aws scripting sql powershell sql performance monitoring redgate sql profile query store idera activity monitor solarwind power bi ssrs education university phoenix tempe az 082016 bachelor science database administrator technology work history ally senior database administrator dayton oh 082019 current managed database access performance tuning database systems capacity planning vmware environment use optimization tools sql profiler dynamic management views dmvs windows performance monitor monitoring tuning sql server performance global content environment automate tasks powershell managing database infrastructure monitor maintenance jobs automated backups index optimization statistics update database integrity check sql server desis database objects queries required optimize performance scalability experience working servicenow solarwinds sql sentry resolve tickets making technical decisions business requirements interaction ba client team development team capacity planning resolve sql server issues including sql server architecture connectivity replication security continuous improvement conformance slas support reporting services ssrs integration services ssis analysis services ssas tpicap group database support engineer paris txplano tx 122016 082019 deployed changes rolled back changes production performed weekly patching standalone cluster instances migrated upgraded sql server legacy 2014 2016 2017 performed regular health checks across servers using powershell scripts fixed database space issues resolving log growth issue normalization dbs monitored daily weekly monthly quarterly maintenance tasks troubleshooting necessary configured transparent data encryption tde using advanced encryption standard aes 256 secure secure db backup files increased server availability time optimum level database recoverability incorporating differential backup tlog backup carried performance tuning tasks regular basis issues ranging query tuning index optimization temp db issues high cpu usage blocking long running queries mirroring logshipping alwayson sync provisioned databases configured appropriate hadr strategy based rtorpo business division setup windows server failover cluster wsfc configured installed alwayson high availability group 7 replicas performed sql server inplace upgrade lower versions sql server higher versions built clusters 2node 3 nodes active passive configured maintained troubleshot logshipping mirroring alwayson availability groups replication fci multiple subnets executed disaster recovery dr exercises dr servers active network database administrator remote nh 062015 122016 configured hadr strategies alwayson failover clustering mirroring logshipping replication resolved performance bottlenecks via tuning query optimization using stored procedures redgate created sql objects tables views stored procedures constraints user defined functions migrated physical servers vms databases onprem azure using azure migratedma maintained high level data security ensure sox hipaa compliance migrated upgraded applied sps routine dba operations like db health checks index optimization statistics update server connectivity capacity planning performed db idb consistency checks dbcc defrag index tuning monitored error logs performed backup restore disaster recovery ms sql server environments migrated sql server 2008 several editions sql server 20122014 2017 installed administered 3node cluster activepassive 2012 san environment migrated ssis packages sql server 2008 r2 2012 migrated database onprem aws cloud managedinstance worked development team optimize schema performance created reports sql queries using ssrs business intelligence development studio bids used indexes enhance performance individual queries fast efficient reporting accomplishments ms certified azure database administrator associate ms azure solutions architect expert