jessica claire 100 montgomery st 10th floor 555 4321000 resumesampleexamplecom summary 5 years experience sql server environments worked ms sql server 2008 2019 diverse environments like test qualityassurance development production allrounder highly motivated selfstarter strong interpersonal excellent communication skills oral written outstanding problem solver analytical skills hands experience installation configuration sql server data migration security performance tuning high availability disaster recovery backup restore database refresh sql server upgrades os patches skills guest services inventory control procedures merchandising expertise sql server database administrator 092019 current rr donnelley sons laurel md loss prevention cash register operations product promotions experience highly analytical resultsdriven professional working databases responsible daily maintenance prod test dev environments charge managing large environments managed users creating logins passwords assigning privileges users following principle least privilege enhanced database performance implemented recovery procedures achieved 999 uptime sql servers increased efficiency providing optimum database performance efficient disaster recovery solutions backup restore processes generated prompt responses tickets resolved user requests based priority ensured database configuration maintenance configuration repository strong experience sql server 2008 2019 administrating standalone cluster environments production level support onsite offshore call 247 environment high availability solution always log shipping traditional failover clustering mirroring experience using sql server features query store data importexport extended events tuning advisor interacts clients application team project managers design implement support solutions meet client needs evaluate implement new technologies service improvement perform daytoday aspects ms sql database administration installation configuration upgrades security user management logins performance tuning monitoring database availability backup recovery troubleshooting problem resolution working entire team work development team resolve bug fixes assist relevant testing various environments provide solutions database issues including capacity redundancy replication performance involved ensuring data recovery maintenance data integrity space requirements physical database creating modifying tables stored procedures views indexes userdefined functions triggers etc requirements sql server environments planning implementation database disaster recovery backup restore snapshots sql server profiler extended events query store database engine tuning advisor dta performance configured supported replication log shipping sql 2008 2012 automation dba tasks monitoring using sql inbuilt tools thirdparty tools respond promptly user complaints regarding access database perform automated jobs run resolve database issues configured supported replication snapshottransactionalmerge log shipping sql 2014 2016 servers high availability solution clustering alwayson database mirroring traditional failover clustering sql server database administrator 082017 102019 rr donnelley sons sacramento ca planning installation microsoft sql server 2012 2016 building designing configuration upgrade migration application windows sql patching scheduled database downtimes hours ensure databases date virtualized environments implementation definition vigorous backup recovery strategies capacity planning following companys recovery point objective rpo recovery time objective rto retention policy recommending implementing data security creating users assigning permissions based minimum level database access user would need tools like always encrypted transparent data encryption tde dynamic data masking ddm secure clients sensitive data using inbuilt tools sql server profiler performance monitor extended events dmvs database integrity checks ensure database integrity stability system managing providing end end support problem resolution sql server databases multiple product lifecycle environments development testing missioncritical production systems configured high availability ha disaster recovery dr solutions productions systems using clustering always log shipping make sure databases always available participating disaster recovery testing analyze solve correct issues realtime provide endtoend problem resolutions hardware software purchases server configuration changes assisting developers queryindex tuning partitioning compression statistics enhance speed maximize system performance creating monitoring maintenance plans agent jobs take backups defragment indexes query performance create update database documentation company standard procedures technology features production issue troubleshooting review scripts submitted development team work teams like systems analysts developers business analysts project teams determine capacity planning required create maintain databases handson database tuning troubleshooting sql server service outages occur including providing oncall support afterhours weekends providing scheduled maintenance supporting application deployment hardwaresoftware upgrades hours 24 x 7 support control establish appropriate database user access control levels provisioning deprovisioning users based upon company policy control access segment databases develops database security guidelines performs audits sql database administrator 022016 052017 chicago public schools chicago il responsible taking maintaining data backup recovery event disaster database security upgraded sql server 2005 servers sql server 2008 inplace side side upgrade support new applications company handled sql server installation configuration security maintenance following best practices reliability maintaining database using sql server profiler extended events database engine tuning advisor dta performance thirdparty monitoring tools cooperate developers writing complex queries schema refinement maintain database response times 24x7 production environments developing automated alert jobs work according policies regulations prioritizing responding executing tasks highpressure environment designing configuration upgrade ms sql supporting production systems migration application windows sql patching scheduled database downtimes hours ensure databases date designing implementing backup recovery strategies capacity planning following companys recovery point objective rpo recovery time objective rto retention policy sql database architecture technical support directory learn emerging technologies operating systems federal regulations system support information technology work according company policies collaborating entire team employees bachelors degree computer science 012014 university mancosa sa microsoft certified technology associate mta education training certifications