jessica claire montgomery street san francisco ca 94105 555 4321000 resumesampleexamplecom summary sql dba professional summary 6 years experience sql server database administration using ms sql server versions 2012 2014 2016 2017 2019 strong experience designing implementing backup disaster recovery strategies per rpo rto values experience configuring maintaining full backup transactional log backup differential backup creating maintenance plans index rebuild index reorganize based fragmentation strong experience identifying troubleshooting database health integrity checks fixing experience microsoft reporting service ssrs report authoring report management report delivery report security created reports sub reports charts tablix matrix hyperlink reports created jobs alerts run ssas ssrs packages periodically created automated processes activities database backup processes ssas ssrs packages run sequentially using sql server agent job experienced setting high availability dr options like log shipping mirroring replication transactional snapshot always availability groups proficient sql server disaster recovery backuprestore creating business continuity planning experience database migration migrated sql server 2008r2 2012 2016 proven experience creating implementing database objects like stored procedures triggers views user defined functions well experienced query optimization clientserver connectivity performance tuning database consistency checks using dbcc utilities dmvs hands experience creating maintenance plans scheduling sql server jobs automated administrative tasks configuring database mail experienced using joins subqueries simplification complex queries including one tables experience implementing sql server security managing permission database database roles creating users logins experience writing tuning tsql transactsql dmlddldcl queries handson experience maintaining sql server clustering active activeactivepassive experience etl extract transform load using ssis sql server integration services sql server 2012 importexport data bulk insert solid experience troubleshooting performance tuning using activity monitor performance monitor dbcc dmvs dmfs thirdparty tools spotlight idera monitoring experienced working production servers 24 x 7 oncall environments applied service packs security updates sql server instances azure api management security cloud tocloud integration public private created migration plan moving onpremises data cloud including identifying security compliance risks azure designed azure active directory integration onpremises directories using aad connect dirsync excellent verbal written communication skills combined interpersonal conflict resolution skills possesses strong analytical skills well flexibility learn advancements industry core technical skills skills windows sql server 20122022 tsql awsrds awsec2 idera sql diagnostic manager sql safe 60 redgate sql compare 10 ssdt azure ssis ssrs ssms dta jira raid mysql litespeed azure vm azure managed instance mulesoft salesforce api experience sql server dba 122019 current provident credit union redwood city ca installed configured maintained sql server 2019 20172016 multiple database environments installed configured sql server standalone clustered environment handled performance tuning optimization slow running queries detected resolved cpu memory io disk space resource contention issues migrated sql server 2017 sql server 2019 resolved security related issues logins users application roles linked servers created sql server agent jobs maintenance plans automate tasks run index maintenance index defragmentation rebuild update statistics capturing deadlocks using trace flags performed database consistency checks dbcc scheduling scripts run daily weekly depending need performing routine tasks like disk space check consistency checks looking slowlong running queries hung jobs performed sql server postinstallation activities configuration changes best practices improve overall server database performance performed service packs update security updates hotfixes clustered standalone servers diagnose system problems evaluate alternative solutions take initiative solve problems monitored index usage tuned appropriate experts database refresh prod lower environment per business requirements automated quarterlymonthly database refresh managed involved sql performance tuning identifying locking blocking issues using native thirdparty tools enhance boost performance sql dbs managed implemented ola hallengrens industries best sql server maintenance plan created schedule environments managed sql server logins database users roles involved daily user maintenance created database maintenance jobs perform full transaction log backups scheduled sql server agent job scheduler providing weekly status information projects project manager wrote debugged stored procedures ddldml triggers functions per client requirements logical physical design database projects basis user requirements using erwin reporting weekly basis project manager extensively worked troubleshooting finetuning databases optimal performance worked performance tuningquery tuning execution plans trace flags sql profiler installation service packs environments used log shipping synchronization databases designed developed etl process using ssis load data various sources like ms access sql server 2014 oracle database expert data extraction transformation loading etl using sql server integration services ssis experience migrating sql server 2012 2014 sql server 2019 always availability good understanding database data warehousing concepts oltp olap used ssis create etl packages validate extract transform load data data warehouse databases environment sql server windows server spotlight sharepoint 2003 servicenow ssis ssrs management studio sql profiler database engine tuning advisor sql server dba 042018 112019 provident credit union san jose ca installed configured maintained ms sql server clustered standalone production servers staging development environment optimized slow running queries stored procedures excellent experience configuring maintaining replication like merge transactional snapshot replication implemented high availability disaster recovery solutions sql server db mirroring log shipping failover clustering activepassive activeactive experience sql joins sub queries tracing usage table variables temp tables etc created database server level audit specification using sql server audit feature analyzed audit results rebuildingreorganize indexes reduce fragmentation enhance sql server performance created triggers views stored procedures implemented database maintenance plans scheduled automated sql server jobs created alerts operators notifications configured database mail hands experience monitoring performance tuning using tuning advisor sql server profiler activity monitor windows performance monitor dbcc dmvs stored procedures working resource governor control allocate cpu memory resources depending priority applications configured managed database high availability replication database mirroring log shipping failover clustering always availability group created sql batch job maintained optimal needs used new features like row page compression mechanism data compression backup compression worked closely development team performance enhancements code reviews provided vital inputs terms index optimization schema structures data changes managed capacity planning primary assigned servers ensure adequate cpu disk space memory environment sql server tsql windows server sql server dba profiler 012017 032018 ethiopian airlines city state installed configured sql server 2012r2 2014 created updated databases tables stored procedures triggers functions views configured administered troubleshoot multiple databases production staging environments clustered standalone environments prepared documentation disaster recovery plan involved installing failover clustering multiple nodes implemented database mirroring log shipping planned backup strategies scheduled backups performed restore operations managed security sql server databases creating logins creating database users creating roles assigning proper permissions creating server database audits worked creating reorganizing rebuilding indexes worked database space management performance monitoring alert management planned location files increased size number files performed tasks query optimization troubleshooting clientserver connectivity issues performance tuning monitored troubleshoot database server performance systemwide scale effectively identify network databases memory cpu disk space io related bottlenecks transferred data several servers using bcp dts providing resolution assigned tickets jira team track service desk per severity meet deadline sla due environment windows sql server 2012 2014 sql server 20122014 ssms extended events performance raid education training associate degree information technology networking new england institute technology