jessica claire 100 montgomery st 10th floor 555 4321000 resumesampleexamplecom summary certified microsoft sql server database administrator dba five years professional experience sustains develops different business systems using microsoft technologies versatile engagements development testing production environment overwhelming successes accomplishing individual team projects seeking database administrator position skills backuprestore tsql scripting powershell cmd database performance tuning cloud computing azure iaas design implement sql jobs create databases database objects database refresh installupgrademigration sql server database high availability managing database security login user sqlserver 2008 20122014 2016 2017 2019 reporting tools excel 2007 ssrs 20082012 integration services ssis 200820122016 operating systems windows server 2008 2012 2016 linux programming languages tsql powershell powershell thirdparty tools idera jirasalesforce service ad scripts automation scripting backup shipping capacity planning sla clustering mssql database sql databases sql server designing sqlserver disaster recovery statistics documentation tsql experience sql database administrator 102020 current accenture contractor jobs havre de grace md email troubleshoot email troubleshooting features upgrade linux validation managing meetings access excel windows window migration network os operating systems dba db processes programming reporting servers ensure database performing within expected performance baselines monitor schedule database backups per operational guidelines proactively monitor action db alerts configured maintain database high availability features failover clustering replication always availability group designing building maintenance cloud environments azure utilize iaas pass saas cloud service model microsoft azure assist team migration onpremises azure iaas managing sql server databases onprem azure using iaas production environment collaborate architecture teams ie applications network database infrastructure security etc perform adhoc backups restores sanitize data handing temporary restores restore backups production systems periodically validate rpo rto slas met maintain administer db access users applications revoke unused access periodically monitor db growth pattern provide inputs capacity planning excellent performance tuning including monitoring troubleshooting optimizing performance databases well high availability service 24 x 7 production database call support sql database administrator 112016 102020 accenture contractor jobs hines il every day checks os events logs sql server logs unusual events verifying scheduled jobs run successfully regularly monitor identify blocking issues disk space usage created sql server alerts notify potential problems sent email operators regularly restoring backups test server order verify restore performed always high availability group window failover cluster failover window mssql server used dbcc check manage database consistency index fragmentation statistics wrote tsql storedprocedures functions triggers work vendors evaluating implementing new technologies maintain sql servers clustered environment including initial installation assisted sql developers optimize sql queries create stored procedures triggers created managed users roles schemas security objects level automated database tasks created jobs alerts schedules database maintenance tasks deployed databases test dev production environment participate oncall rotation attended daily weekly release planning meetings identified bottlenecks related database query server performance issues slow running resolve deadlocks blockinglocking conflicts stemming high resource utilization troubleshoot application connectivity issues availability groups database administrator 042015 102016 northstar financial services group llc bothell wa configured maintained log shipping follow microsoft best practices configuring operating sql server properly maintain backup recovery methods support sql database operational developers business users configured maintain high availability ha disaster recovery dr options mssql server implementing automation reoccurring dba tasks good communication documentation skills processes procedures knowledgeable performance tuning server sql server database query level provide database production support critical systems including backup recovery designed developed sql scripts validate data prepared test data various validation rules check extensively used sql test backend functionality troubleshooting various problems arise day day work fix issue monitoring sql server error logs checking email alerts education training bachelor information technology 2011 bit maryam university certifications mcsa microsoft certified solution associate microsoft certified azure administrator trainings training database high availability training database performance tuning training azure platform