jessica claire montgomery street san francisco ca 94105 555 4321000 resumesampleexamplecom professional summary 6 years experience database administration system analysis design development support ms sql server 201420122008 r220082005 production test development replication cluster server environments expertise database administration production servers server configuration performance tuning maintenance outstanding troubleshooting capabilities experience high availabilitydisaster recovery hadr solutions failover clusters alwayson availability groups replication log shipping mirroring experienced upgrademigration ms sql server 2008 ms sql server 2008r2 sql server 2012 sql server 2014 experience working application team implemented databases per specification lob applications experienced installation configuration maintenance optimization sql server hadr solutions experienced partially contained databases experienced backup recovery query optimization security experienced monitoring health performance sql servers well home grown applications using sql server native tools several third party solutions adept tsql stored procedures tables indexes views functions triggers expert creating dts packages utilize ssis functionalities db dependency resolutions created various ssis ssrs ssas packages serve company needs familiar pci compliance standards required retail industry expert using dtaextended eventsperfmonsql profilerscripts third party tools resolve bottlenecks dead locks slow running queries able benchmark load test new instance builds performance db load simulators responsible securing sql server user management assigning permissions roles good knowledge litespeed diagnostic manager log explorer ms sql server strong system administration background windows linux environments experienced developmenttestproduction qa included documentation processes creation test scenarios execution tests via tsql scripts ensure ui standards met required specifications experienced creating technical documentations process archiving change management experienced working independently well teamoriented environments expert problem solving analysis conflict resolutions experienced supporting maintaining large databases troubleshooting problems excellent analytical communication interpersonal skills work history sql server dba 012016 current nbc universal detroit production l2 support responsible resolving incident tickets escalated l1 support handling critical incidentssev1sev2 high providing sql server implementation changes requested application teams responsible installing configuring maintaining per supported lob applications writing improving sql server tsql queries created necessary tsql scripts stored procedures tables views functions triggers indexes responsible providing sql server problem resolution 24x7 production support server outages responsible disaster recovery high availability solutions large scale database migrations sql server 2005 sql server 2008r2 2012 created migrated partially contained databases within alwayson availability groups created automation day day operations critical sql server alerts repetitive tasks monitored health performance sql server instances home grown applications using extended events sql server profiler perfmon third party tools tested newly built servers performance impact db load simulators setup maintained log shipping various environments developmenttestproduction qa included documentation processes creation test scenarios execution tests via tsql scripts ensure ui standards met required specifications created necessary tsql scripts stored procedures tables views functions triggers indexes operated oversaw database log backups restoration planning backup strategies scheduling backed master system databases restoring necessary optimized indexes addingdeleting necessary better performance verified backups error logs servers troubleshoot failures alert problems open trouble tickets necessary work technicians departments responsible installing configuring maintaining sql failover clustering production environments worked installation configuration creation ssrs deciding whether clustering log shipping mirroring replication etc right fit solve business problem oncall troubleshooting sql server service outages responsible securing sql server user management taking care permissions roles environment microsoft sql server 201420122008r2 enterprise standard editions windows 20122008r2 clustering always mirroring replication sql server management studio sql profiler performance monitor ssis ssrs microsoft visual studio 2012 toad mysql microsoft office 2013 mongodb sql server dba 012013 112015 nbc universal fort lee nj united healthcare serves key markets geographic regions broad range health benefit products services consumers benefit sponsors responsibilities installed configured sqlserver2008 r2sqlserver2008 backup jobs database mail configuration options upgraded sql servers latest service packs migrated sql server databases sql server 2005 sql server 2008 r2 created administered maintained sql server databases production test staging various groups ensured availability database servers configured maintained transnational replication flow data qa dev server replica servers monitored data activities like database status logs space utilization locks long transactions implemented sql standards writing stored procedures triggers views sql functions involved resolving deadlock blocking issues concurrent users worked developers optimize code required minimize duration look indexes used appropriately provided appropriate access users except system databases owners activities refreshed databases pre post data loads supported sql server developers working different projects various requests converted redesigned existing dts packages ssis packages developed ssis packages import export data existing systems upgraded system used database utility programs 3rd party utilities monitor database performance blocking expensive queries memory utilization environment ms sql server 2008r220082005 tsql lite speed sql profiler log shipping replication mirroring clustering windows 20032008 server erwin database adminstrator 052012 2013 l3harris pueblo co orange rock land utilities inc r subsidiary consolidated edison inc electric gas utility along two utility subsidiaries serves approximately 750000 customers spread across seven counties located new york northern new jersey northeastern pennsylvania responsibilities l2 support worked incident tickets escalated l1 support team responsible ms sql server 2005 2008 database administration 24x7 critical production support hundred ten sql servers 75 mission critical production support created database maintenance plans sql backups optimization integrity check tlog backups created checklists properunattended install sql server applied service packs security fix configured maintained transactional snapshot replication 3 environments worked sql disaster recovery processes documentedrevised processes worked capacity planning database sizing monitoring created databases tables indexes stored procedures triggers alerts maintained user permissions involved creating dts packages import export operations sql servers applied monthly patches hot fixes worked application team test successful upgrades maintained operators categories alerts notifications jobs job steps schedules environment ms sql server 20082005 tsql sql profiler log shipping replication mirroring clustering windows 2003 server associate database administrator 042010 022012 array information technology panama city fl teleflora floral wire service company brokers orders local florists deliveryheadquartered los angeles california teleflora llc clearinghouse transmitting processing floral orders customers throughout united states internationally responsibilities created database maintenance plans sql backups optimization integrity check tlog backups responsible ms sql server 2005 2008 database administration worked change requests permission requests refreshes requests created checklists properunattended install sql server applied service packs security fix configured maintained transactional snapshot replication merge replication worked sql disaster recovery processes like log shipping methodologies clustering mirroring worked capacity planning database sizing monitoring created databases tables indexes stored procedures triggers alerts maintained user permissions worked application team test successful upgradesmigrations installations maintained operators categories alerts notifications jobs job steps schedules environment sql server 2005 sql server 2008 tsql oracle plsql windows 20032008 server import export data skills languagestsql plsql html vb net java perl asp php xml rdbms toolssql server 200520082008r220122014 ms access 2003200720102013 oracle 11gr2 mysql sql loader exportimport powershell backup softwaresqlbackup lite speed red gate id era sqlsafe backup exec etl toolsssis bi bidsssdt data modelerssas sql developer data modeler toad data modeler reporting audit toolsssrs report builder ssdt idera sql compliance manager sql secure virtualization vmwareand hyperv third party tools redgate spotlight iderasqlsuitephpmyadmin olass maintenance scripts putty wireshark db query toolsms sql server query analyzer sql profiler etl ssms enterprise manager plsql developer toad sqlmysqloracle operating system windows 78 10 windows nt 200020032008 2012 servers education bachelor science computer science 2012 jntu university india emphasis database management trained sql testing volunteered participated several cultural events 100 percent attendance top class one semester coursework includes sqljavacc