jessica claire 100 montgomery st 10th floor 555 4321000 resumesampleexamplecom summary skilled senior database administrator bringing 6 years experience design administration databases well key skills modeling warehousing data development enterprise architectures strategic collection use business intelligence proficient technical software languages tools learns new strategies quickly collaborative teamoriented firstrate oral written communication complex problemsolving decisionmaking abilities wellversed various programming languages including sql mysql skills guest services inventory control procedures merchandising expertise experience sql server dba 122019 current iron mountain albuquerque nm loss prevention cash register operations product promotions managed database servers development test production environment installed configured managed sql server 2008 r2 2012 2014 2016 development test production environment installed configure maintained ha dr solutions using always replication log shipping strong working experience database backup disaster recovery experienced pointintime recovery restored database backups upgraded migrated sql server 2012 te sql server 2016 applied sp hot fixes sql server instances address security upgraded related issues strong knowledge database monitoring performance tuning scheduled jobs automate different database related activities including backug monitoring database health disk space backup verification monitor sql server error log space usage sql server profiler extended events database engine tuning advisor performance monitor activity monitor execution plan besides native tool used solarwinds thirdparty tool monitoring performance tuning writing tsql functions trigger partition view storedprocedures joins union writing scripts job setup create linked servers sql servers databases assisted database developers optimize sql queries stored procedures export import data excel file fl file csv file sql server database using ssdt creating ssis packages deploved different sources like sql server database flat file csv excel many data sources supports oledb data sources setup jobs ssis packages installed configured administered sql server reporting services ssrs experienced working independently well teamoriented environments environment sql server 2012 2014 2016 iis 2017 vsual studio 2015 windows server 2016 2012 ssas ssrs ssis log shipping always sql server dba 122017 112020 iron mountain batesville sc responsible installation configuration sql server 2008r2 2008 responsible seeuring sql server user management taking care permissiens roles worked performance tuning tweaked sql queries adding indexes better performance configured deployed ssis packages test production environments responsible transactional replication created maintained sql agent scheduling jobs alerts operators created managed indexes constraints keys primarn key foreign key working different data modelling projects including creating scripts er diagram backward forward engineering performing different maintenance plans backups index management fragmentation management cleaning history deleting old files expert problem solving analysis conflict resolutions sql server database administrator 052015 112018 genesis consulting group richmond va configured installed maintained sql server 2012 2014 2016 development test production environment managed security defining roles rights experienced alwayson environment maintained server database security ncluding database encryption tde setup jobis maiutenance plans backups teorganize indexes check server liealth alen notifications manual demand setup jobs database backup design backup strategy monitored database seryet performance nuning long running queries built expertive n database performance tuning applied sp iservice pack sol server 202 2014 monitor server activity error log space usage solving problem needed deployed ssi packages mase data across server move logins load data different data sources education training bs information technology 052018 southern new hampshire university hooksett nh additional information professional experience kill entails configuring managing darahases databane servers using sol server 20172016 205 2012200s 2205000 inctuding installation configutation backup testaratron mpesade migranon apply patches patch managemenit troubiethooting uupporting clienta database performance tuninr database securit data madelling ssis ssrs ha dr solution alwayson avaitability group clestering reptication certifications microsoft certified administering relational databases microsoft azure