jessica claire resumesampleexamplecom 555 4321000 100 montgomery st 10th floor professional summary sql server database professional 7 years experience managing critical databases onprem cloud azure extensive experience administration support next generation sql server databases production test development standalone clustered environments substantial expertise performance tuning maintenance high availability disaster recovery hadr strategies hands experience setting troubleshooting always clustering database mirroring log shipping including replication snapshot transactionalmerge peer peer database backup restorerecovery query optimization security sql server installation configuration standalone clustered environments migrationupgrade applying service packs routineemergency dba operations like database health check index optimization updating statistics clientserver connectivity capacity planning responsible securing sql server user management assigning permissions roles using query store extended events database engine tuning advisor dta sql profiler scripts thirdparty tools resolve bottlenecks deadlocks slow running queries database security configuring dynamic data masking experienced active directory ad objects user permissions skills sql server installation implementation migration database security backup recovery performance tuning capacity monitoring hadr configurations log shipping mirroring clustering transactional replications alwayson availability groups standbyfailover administration etl processes ssis ssrs ssas sql server tools ssms sql profiler perfmon sqlcmd database tuning wizard sql server upgrade advisor monitoring tools solarwinds redgate sql monitor tsql database maintenance cloud migration using azure powershell work history rr donnelley sons sql server database administrator nashville tn 062019 current develop create stored procedures advanced queries triggers views indexes functions databases provisioning databases configuring appropriate hadr strategy based rtorpo objectives organization manage 1100 databases vldb across multiple data centers enhance database performance perform system backup restores implement recovery procedures conduct regular health checks carry performance tuning tasks regular basis issues ranging query tuning index optimization tempdb issues 10 high cpu usage severe blocking long running query etc collaborating cross functional teams making technical decisions capacity planning upgrading sql servers business requirements configuring maintaining troubleshooting log shipping mirroring alwayson availability groups replication sql server failover cluster high availability disaster recovery solutions configuring dr solution transaction replication distribution server multiple update table subscriptions migration sql server premises azure sql database largescale database migrations various versions sql server schedule monitor daily weekly monthly quarterly maintenance task ensuring successful resolves issues fails performs database consistency checks dbcc defrag index tuning monitored error logs using etl packages data warehousing weekly patching standalone cluster instances education university lagos bachelor arts linguistics certifications certificate completion sql server database administration complete computers jul 2014 certificate completion azure fundamentals tekypro may 2020 microsoft certified solution associate mcsa sql database administration 2016 server md101 microsoft modern desktop admin az104 microsoft certified azure fundamentals dp300 microsoft certified azure database administration associate performs physical logical data modelling databases varied sizes including vldbs configure dr solution transaction replication distribution server multiple update table subscriptions manage products development databases including performing tuning capacity sql server clustering database security configuration database continuity manages permissions security performs security tasks like grant revoke permissions security tasks provides oncall support mission critical environments expert using dbcc trace flags handling blocking deadlock situations use tools like solarwinds fog light red gate monitoring environment rr donnelley sons sql server database administrator san antonio tx 112014 062019 installed configured edition sql server 20052008 like enterprise edition successfully migrated sql server2005 sql server 2008 development testing environment migrated new database structures tables indexes stored procedures development production environment monitored database system details within database including stored procedures execution time implement efficiency improvements development automated daily weekly monthly system maintenance tasks database backup replication verification mirroring database integrity verification indexing statistics updates designed new reports customized existing reports older version new version implemented transactional replication enhance failover capabilities increased database manageability improved performance implementing different development test server instances application development team coordinate development testing environments keep updated daily support troubleshooting monitoring optimization tuning server sql server environments creating logins roles appropriate permissions responsible resolving blocking locking issues successfully implemented database mirroring primary server mirror server implemented log shipping standby mode support dr servers provided 24 x 7 dedicated supports sql server production server