jessica claire 100 montgomery st 10th floor 555 4321000 resumesampleexamplecom summary selfmotivated production sql server database administrator possesses strong analytical problemsolving skills experience includes sql server 2005 2008 2012 2014 2016 ssis well clustering mirroring high availability solutions oltp oracle environments proficient database backup recovery performance tuning maintenance tasks security consolidation team player creative vibrant optimistic mentality able work minimum supervision effective critical thinking organizational planning experience strong work ethic demonstrated success teamwork individual situations skills sql server installation implementation disaster recovery performance tuning database security backup restore replication high availability data migration database maintenance database upgrade patches strategic planning tsql ssis ssrs powershell solarwinds experience database administrator 052021 current two95 international inc texas tx dba activities like analysis space availability backups transaction log complete scheduled jobs used sql profiler troubleshooting monitoring optimization sql server sql code performed various data migration tasks mission critical databases worked team 6 manage 2000 databases ranging 350gb 23tb worked powershell performance enhancement security audits updating service packs security patches servers create reevaluate indexes made needed modifications better performance creating reviewing security features servers documentation server builds specifications security features participating process application database audits revise improve current monitoring strategies entire database enterprise introduced setup solarwinds sql sentry perform proactive maintenance mission critical databases small large supported developers use importance sql server index tuning wizard sql server profiler maintained proper use storage space requirements well adding new storage space disk drives appropriate responsible importing well exporting data sql server using bcp dts ssis establish standards schedules database backups making sure backup schedules meet recovery requirements daily weekly well monthly basis used restore verify option creating backups work team member dbas ensure 24x7 day week support corporate databases database administrator 052016 022021 two95 international inc new york ny part team 5 dbas supporting client inhouse sql server database systems various infrastructure projects improving service level agreements reducing time deliver database solutions business interfacing developers clients help understand needs based budget licensing cost upgrading client rdbms sql server 2008r2 sql server 2012 engaged strategic planning implemented supported high availability ha disaster recovery dr solutions via log shipping database mirroring along proper backup strategies across multiple sql server instances design implement administer high availability solutions clustering log shipping mirroring replication database administration including installation configuration upgrades performance tuning backup recovery managing clusters sql servers worked powershell automation performance enhancements security audits designing implementing maintaining database schema entity relationship diagrams data modeling tables stored procedures constraints indexes functions views rules defaults complex sql statements responsible maintenance backup recovery testing alerts job failures etc database integrity checks used scripts sql agent jobs automate database maintenance tasks setting managing transactional replication mirroring log shipping configure install windows server 2016 clusters sql server 2016 clusters configure install windows server 2008r2 clusters sql server 2008r2 clusters serving technical expert sql server technologies participating sql server database systems design operations created database objects like tables views indexes storedprocedures triggers cursors using sql assisting resolution complex problems support production including call support ensuring detailed physical design database data structures comply data policies standards principles meets established level service agreementsgoals system using native thirdparty monitoring troubleshooting tools demonstrating experience working root cause analysis sql server database issues flexible adaptable able manage multiple tasks dynamic environment proactively monitoring database systems ensure secure services minimum downtime provide call support rotating basis database administrator 022014 052016 two95 international inc chicago il lead efforts database team improving cpu consumption critical production database servers tuning queries databases instances etc thereby reducing cpu workload steady 90 10 resulting 300 increase transaction processing support sql server databases including database performance tuning installing upgrading sql server databases clustering monitoring database health coordinating storage teams capacity planning storage distribution backing restoring databases maintenance database users security database development data transfer replication mirroring server diagnostics analysis building new clusters handle missioncritical databases automated process monitoring entire inventory sql servers ensure good backups servers using tsql scripts worked primary dba several projects including high availability dr project tied companys active directory structure accessed companys employees create new database logins users required applying necessary sql server database patches installing service packs also provide 24x7 oncall support production databases developed optimized stored procedures triggers ssis packages troubleshoot disk network memory cpu related performance issues high volume oltp servers set always availability groups sql server 2012 databases designed backup recovery strategies sql server databases meet customer sla requirements maintaining environments prod uat qc test training dev performing frequent health checks backups missioncritical production databases creating analyzing daily reports missioncritical databases monitoring servers using sql sentry third party tools extends across platforms data centers establish escalation policies database team revise improve current monitoring strategies entire database enterprise introduced setup solarwinds sql sentry standardize processes db team creating documentations installations migrations upgrades backups restores index maintenance etc revised current dr ha strategies improving thereby reducing downtime event failure participating oncall rotation team ensured availability instance databases via clustering mirroring create reports ran daily jobs running sql server agent education training bachelor science computer software systems engineering thames valley university university west london london technical skills sql server 2005 sql server 2008r2 well sql server 2012 sql server 2014 windows server 2005 2008 2008r2 2012 2012r2 strong knowledge backups restores recovery models dbcc commands clustering log shipping mirroring replication experience troubleshooting resolving performance issues blocking deadlocking issues database integrity issues security issues log shipping issues database administration including installation configuration upgrades capacity planning performance tuning backup recovery managing clusters sql servers installation upgrade maintenance tuning sql server 2005 2008 2008r2 2012 2016 tables partitioning knowledge high availability database servers using sql server 2012 always knowledge experience solarwinds sql sentry one develop modify stored procedures queries triggers views indexes functions experienced monitoring troubleshooting 24x7 operations experience network connection tuning using sql server 2008r2 good understanding disk server configuration sql server proficient performance sql server software new installation upgrades proficient backuprecovery strategies implementation experience setup administration sql server database security environments using profiles database privileges roles responsible troubleshooting problem solving sql database servers ability ensure technical integrity corporate databases protecting loss misuse information designing backuprecovery strategies experience managing multiple ms sql 2008 2008r2 2012 rdbms webbased transactions experience windows environment vm index maintenance tuning databases provide sql server database physical model creation implementation data type indexing table design experience working transactional snapshot replication experience sql server 2005 2008 2008r2 2012 windows nt server 2005 2008 2008r2 2012 proficient use tools like sql server profiler windows performance monitor development database support tsql tuning application tuning etc proficient sql server 2005 2008 2008r2 database cloning experience monitoring performance tools sql sentry solarwinds sp whoisactive etc extensive knowledge microsoft sql server databases well ssis dts packages tsql performance tuning database design data warehousing