jessica claire 100 montgomery st 10th floor 555 4321000 resumesampleexamplecom professional summary continuous integration testing automation proactively used tuning advisory query optimization plan query execution plan order address database locking deadlocking blocking issue experience creating maintaining backup restore strategy replication logshipping strategy part disaster recovery excellent capacity planning storage management experience supporting troubleshooting huge databases performance well security problems expert installing different software cluster non clustered environment experience security auditing managing performance monitoring tools experienced developing implementing project plans ms project worked independently well teamoriented environments excellent analytical communication skills 247 rotated support experience create manage logins users roles add groups windows sql server monitoring database growth activities take proactive steps avoid transaction log space issues responsible monitor troubleshooting log shipping technical skills rdms skills ms sql server 2008r2xxx2xxx4xxx6 ms access xxx3 xxx6 programming sql tsql c c java java script cobol asp html operating systemsserver windows 2008xxx0 workstation windows ntxpvista98 applications ms office ms visio cute ftp ws ftp paint shoppro tools litespeed backup tools diagnostic manager idera compliance manager idera sql native monitoring tools nt performance monitorsystem monitor tsql erwin sql profiler sql query analyzer department justice active public trust microsoft visual cnet linux operating system database development work history sql server dba 01xxx7 current qsronlinecom llc corpus christi tx installed configured maintained sql server xxx9 xxx6 xxx4 xxx2 development test production environment configured maintained failover clustering using sql server xxx2 installed configured sql server reporting services ssrs developed deployed different types reports using different data sources like sql server excel csv files delivered reports users variety formats like report server web based excel pdf html excel csv formats worked fastpaced dynamic team environment provide basic administration microsoft sharepoint enterpriselevel content management portals manage organizational content meet needs across multiple project teams experience working azure cloud extensive handson experience implementing scalable solutions using azure services azure sql dbdw azure storage maintain azure database migrate database azure azure backup restore databases configured maintained replications log shipping mirroring high availability upgradedmigrated sql server instancesdatabases older version sql server new version sql server like 2008 r2 xxx2 migrated ms access databases ms sql server xxx2 xxx4xxx6 applied sp service pack hot fixes sql server instances address security upgraded related issues performed database sqltsql performance tuning wrote sqltsql queries storedprocedures functions triggers scheduled many jobs automate different database related activities including backup monitoring database health disk space backup verification developed different maintenance plans database monitoring setup jobs maintenance plans backups rebuilding indexes check server health alert notifications create managed different types indexes clusternoncluster constraints uniquecheck worked data modeling projects backward engineering developed er diagram used multiple tools like erwin toad data modeler sql server data diagram developed ssis packages different sources like sql server database flat file csv excel many data sources supports odbc ole db data sources deployed ssis packages move data across server move logins load data different data sources used impexp tool export import data different sources like sql server database flat file csv excel many data sources supports odbc ole db data sources manual demand setup jobs database backup design backup strategy deployed restored database including point time recovery monitor server activity error log space usage solving problem needed produced highstandard database solutions meet stability reliability performance metrics analyzed business reports prompt communication followup ongoing support sql server dba 08xxx6 12xxx7 qsronlinecom llc corpus christi tx upgrade install support sql servers including production test developing servers installed configure sql server 200520082008r2xxx2xxx4 standalone machine well cluster environment installed reviewed sql server patches well service packs design configure database tables indexes store procedures functions triggers troubleshoot database status performance replication logshipping always availability well various errors production development uat servers configured deployed reporting service create maintenance plan backup restore performance tune involved setting backup strategy production test development experienced pointintime restoring databases production development servers export import dtsssis packages source serve destination server environments monitoring sql servers performance proactively support customer application deployment round clock manage maintain database security access create documents deployment troubleshot issue references configured database mailing notification services sql server dba 02xxx5 06xxx6 qsronlinecom llc corpus christi tx 1s level support responsibility act production support upgrade dba maintained 36 sql servers including production test development servers participate upgradingpatching sql server 2005 servers sql 2008 upgrade sql server 2005 2008 installed sql server 2005 20082008r2 applied service packs security fix servers installed windows 2003 2008r2 servers installed configured ms sql fail clustering production servers involved setting backup strategy production test development experienced pointintime restoring databases production development servers configured deployed reporting service configured log shipping production environment create backup server experienced sql disaster recovery processes documented processes configured sql maildb mail send email alerts operators created maintenance plan database optimization integrity checks experienced monitoringcapturing sql server performance issue using windows performance monitor task managersql native monitor sql profiler experienced improving databases performance using execution plan index tuning wizards sql profilers analyze sql server deadlocking locking blocking troubleshoot root issue experienced securing sql servers assign permissions sql server users actively involve participate team meetings author howto documents knowledge base articles various database related tasks sql server dba 01xxx2 10xxx4 qsronlinecom llc corpus christi tx worked active passive cluster environment used log shipping synchronization databases sql server 2005 database administration handle migration sql server 2005 sql server 2008 responsible monitor troubleshooting log shipping update statistics database integrity check backup operation wrote debugged stored procedures triggers functions per client requirements daily tasks developerdba like space issues production test servers handling maintenance jobs handling users permissions designed implemented comprehensive backup plan disaster recovery worked extensively query analyzer profiler tuning queries performed performance tuning stored procedures experience trouble shooting database issues monitoring sql server performance using profiler find performance deadlocks bachelor information science azure administrator associate education certifications scrum master certified comptia security certification microsoft sqlserver20082008r2xxx2xxx4xxx6administration training microsoft additional information experienced database designing implementation system administration using microsoft sql server 20082008r2xxx2xxx4 xxx6xxx9 strong experiences installingupgradingpatching memory configuration security management microsoft azure cloud azure sql database including installation configuration backuprestore security ad groups managing resource groups storage blobs experience sql clustering different version windows servers experience monitoring sql server capturing performance problem improve performance tuning databases