professional summary jessica claire montgomery street san francisco ca 94105 555 4321000 resumesampleexamplecom proven success deployment effective roadmaps processes procedures including setting high availability disaster recovery solutions sql always availability groups log shipping mirroring replication traditional fail clustering significant expertise sql server upgrade database migration well azure databases elastic pools managed instance new instances installation highly analytical resultsdriven professional 5 years working experience sql server database administration microsoft security backup restore hyperv vm ware tsql laas saas core systems administration self stater qualifications critical thinking able thinking beyond measures pressure excellent listener strong listening skills experience sql server database administrator silvergate capital corporation city state united states 052022 072022 developed updated tables stored procedures views indexes userdefined functions triggers accordance sql server environments completed tasks prior deadline involving sql installation automation setting azure sql databases manage instances sql azure vms site recovery backup ensure optimal performance disaster recovery database migrate databases azure sql using database migration service replication backup restore install configure microsoft sql server 2008 insert 2019 following best practices upgrade sql server sql server 2008 2016 using inplace sidebyside upgrade provide dba support technical expertise multiple applications development test qa production environments interacting clients application team project managers design implement support solutions meet client needs provide guidance expertise database performance tuning performance query optimization using sql server inbuilt thirdparty tools query store extended event sql server profiler sql server turning advisor manage develop longterm strategies data storage capacity planning create manage database backup restore strategy following companys sla refresh databases test dev environment manage users permissions active directory set manage disaster recovery high availability solution alwayson availability groups ag log shipping database mirroring traditional failover clustering replication apply sql server windows patches upgrade migrate databases sql server 2008 sql server 2016 using inplace side byside migration well backup restore detach attach enhancing performance creating table partition files file groups table compression creating managing logins users following principal list privileges creating managing users active directory building configuring vms hyperv environment maintained achieved high availability database via coordinating infrastructure teams allocate system resources database migrating databases onprem azure azure sql database azure sql manage instance sql azure vms install configure sql server ssis ssrs packages sco server database administrator silvergate capital corporation city state managed 112 databases 012018 032021 planning installation microsoft sql server sql upgrade migration coordinate vendors end users apply windows sql patches define implement backup recovery strategies capacity planning per company recovery point objective rpo recovery time objective rto sla retention policy implement data security creating users assigning permissions per principle least privilege implement data security operations like always encrypted transparent data encryption tde dynamic data masking ddm secure clients sensitive data leverage inbuilt software ssms sql server profiler performance monitor extended events dmvs database integrity checks ensure database integrity stability system availability third party software like idera solarwinds database performance analyzer monitor system health security configure high availability ha disaster recovery dr solutions productions systems using clustering always traditional failover clustering windows server failover cluster wsfc database mirroring replication peertopeer replication merger replication transactional replication log shipping provide endtoend support problem resolution sql server databases multiple product lifecycle environments development testing missioncritical production systems create update database documentation company standard procedures technology features production issue troubleshooting creating monitoring maintenance plans agent jobs take backups defragment indexes query performance troubleshooting sql server service outages occur including providing call support afterhours weekends control establish appropriate database user access control levels provisioning users based upon company policy control access segment databases develops database security guidelines performs audits jucior sql server database administrator credit union cameroon city state greatly contributed increase performance 082016 112017 drive end end availability performance monitoring capacity planning microsoft sql architecture support sql server application environments established multiple projects deadlines fastpaced environment independently managed 100 database performance issues help ensure security compliance across database systems established day day administration database maintenance monitor optimize sql server performance hardware upgrades server configuration changes indexquery changes collaborate architecture development teams providing design recommendations manage production operations readiness plans documents education bachelor arts university buea buea cameroon 072015