jessica claire 100 montgomery st 10th floor 555 4321000 resumesampleexamplecom professional summary 7 years experience database administration large complex databases sql server 201920172016 2014 2012 2008 2005 performed daytoday aspects ms sql database administration responsibilities include database design installation configuration upgrades security managing users logins performance monitoring tuning database availability backup recovery troubleshooting problem resolution configured high availability solution clustering always database mirroring log shipping involved ensuring data recovery maintenance data integrity space requirements physical database creating modifying tables stored procedures views indexes userdefined functions triggers requirement sql server environments planning implementation database backuprestore disaster recovery installed sql server 20052019 following microsoft best practices applied patches security fixes sql server profiler extended events query store database engine tuning advisor dta performance configured supported replication log shipping sql 2008 2012 maintained database response times 247 production environments monitoring standby databases ensure high availability automation dba tasks using powershell scripts monitoring configured managed contained database managed provisioned azure sql databases services configured supported replication log shipping sql 2008 2012 managed reduced cost effectively monitoring databases elastic pool performed database migration onpremises sql environment azure database cloud installed configured ms sql server vm azure database skills microsoft sql server 2005 2012 2014 2016 2017 2019 windows server 2008 2012 2012 12 2016 2019 microsoft office suite word excel power point office 365 windows remote desktop service manager service active directory windows 7810 hyperv vmware workstation solarwinds jira sql server tools ssms enterprise manager profiler query analyzer export import dts ssis ssrs ssasrdbms ms sql server 200520082012 ms access etl dts ssis work history 012020 current ms sql server dba edge link city state planning installation microsoft sql server 2005sp4 2008r2 2012 2014 2016 2017 2019 building designing configuration upgrade migration application windows sql patches scheduled database non production hours ensure databases date virtualized environments implement define vigorous backup recovery strategy capacity planning following companys sla recovery point objective rpo recovery time objectiverto retention policy recommend implement data security creating users assigning permissions based principle least privileges also technologies always encrypted transparent data encryption tde dynamic data masking ddm secure clients sensitive data using sql server inbuilt tools sql server profiler extended events activity monitor monitor performance system health database integrity checks ensure database integrity stability system availability configured high availability ha disaster recovery dr solutions production standalone clustered environments always traditional failover clustering windows server failover cluster wtfc database mirroring replication transactional replication log shipping make sure databases always available participating disaster recovery troubleshooting resolving database integrity issues performance issues blocking deadlock issues updating statistics query optimization using performance activity monitor event viewers extended events managing providing end end 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 analyze solve correct issues real time provide endtoend problem resolution hardware software purchases server configuration changes assisting developers queryindex tuning partitioning compression updating statistics enhance speed maximize system performance creating monitoring maintenance plans agent jobs automates backups reorganizerebuild indexes query performance handson database tuning troubleshooting sql server service outages occur including providing call support afterhours weekends providing scheduled maintenance supporting application deployment hardwaresoftware upgrades hours 24 x 7 support review scripts submitted development team working teams like systems analysts developers business analysts project teams perform capacity planning required create maintain databases control establish appropriate database user access control levels provisioning deprovisioning users based upon company policy control access segment databases develop database security guidelines perform audits migrate sql server databases prem azure using data migration assistant develop monitor system application alerts ensure health monitoring performance tuning create maintain azure managed sql instances databases 022018 122019 ms sql server dba texas department criminal justice city state manage infrastructure performance data security make recommendations improvements manage infrastructure performance data security make recommendations improvements assist monitoring review strong analytical planning organizational skills ability manage competing demands involved planning setup implementation new servers across entire enterprise involved ensuring data recovery maintenance data integrity space requirements physical database planned deployed monthly windows sql server patches planning implementation database backuprestore disaster recovery create work high availability ha disaster recovery dr options sql server writing basics tsql scrips stored procedures functions triggers data transformations using bids implementation snapshot isolation ddl triggers migration sql server 2005 servers sql server 2008 stable replication topology installed sql server 2008 advanced servers applied security fixes sql server upgrade performed database migration onpremises sql environment azure database cloud installed configured ms sql server 2008 r2 supported production development servers maintained database response times 24x7 production environments developing sql scripts maintaining administration tasks capacity planning resource allocation monitoring standby databases ensure high availability troubleshoot resolve issues related computer software hardware controlling production equipment application production level support onsite offshore clients support patch management integrated temporal tables 052015 012018 junior ms sql server dba american airlines city state education 122019 122011 sql database administrator database programming resolve highly complex technical escalate support incidents troubleshoot diagnosis issues sql server environment implementation sql logins roles authentication modes part security policies various categories users rebuilding indexes regular intervals better performance large datasets designed implemented comprehensive backup plan disaster recovery strategies involved trouble shooting finetuning databases performance concurrency monitored modified performance using execution plans index tuning deploying new code base release uat production environments perform sql server service pack windows service pack upgrades working customers application rollouts server migrations extensively worked enterprise manager managing database troubleshoot performance problems finetuning databases converting dts packages sql server 2005 integration services migrating sql server 2000 data bases sql server 2005 md chemical natural gas engineering texas university kingsville kingsville tx bachelor science geology university buea cameroon 122014 ms sql server dba tsql empire data system texas