jessica claire 100 montgomery st 10th floor 555 4321000 resumesampleexamplecom professional summary microsoft certified database administrator five years experience administering supporting sql server production development test environments strong interpersonal skills ability work independently well team environment highly skilled problem solving seeking position sql dba rising organization contribute mission foster professional growth skills implementing security measures microsoft visual cnet running backups work history 012019 current sql server dba iron mountain reno nv compiling data database development relational database management responsible providing daytoday activities including backup restore performance tuning security management capacity planning responsible investigating potential problems issues raised customers monitor database events proactively optimize system performance monitor health performance sql os server instances applications using sql server profiler thirdparty tools installed managed sql server 201420162017 databases production preproduction development environments responsibilities include production application support database application servers responsible largescale database migration sql server 2012 sql server 2014 develop database objects like tables views stored procedures ability review author complex stored procedures verify backups error logs servers troubleshoot failures alert problems open tickets necessary work technicians departments create partition tables based upon partition functions partition schemas use powershell execute batch files scripting tasks exporting importing data fromto database like oracle mysql access tofrom sql server moved data flat file excel oracle sql ms access ole db sources sql server involved performance tuning stored procedures user defined functions long running queries documentation processes involved maintaining database future reference managed stored procedures jobs utilize serverside tracing identify performance issues deadlocks locking issues involved installing configuring maintaining clustering alwayson availability groups production servers latest service packs hot fixes database recovery backup disasters implementing pointintime recovery solutions administrating replication log shipping large databases create maintenance plans database backup database integrity checks index maintenance cleanup tasks monitor alerts job notifications scheduling jobs alerts using sql server agent maintenance plans db mail troubleshooting client connections viewing error log applications handling ticketstasks troubleshoot provide resolutions refreshing databases production lower environments deploy codes packages perform tests evaluations regularly ensure data security privacy integrity experience azure sql migrating azure databases onpremise providing 24x7 production support database application issue environment ms sql server 201420162017 windows server 20122016 enterprise edition sql server data tools visual studio 012017 012019 sql server dba iron mountain sharon hill pa installing applying sp service pack configuring upgrading ms sql server 2012 2014 2016 providing sql server implementation changes requested application teams administering ms sql server security enforcing security policy creating user logins appropriate roles monitoring user accounts creation groups granting privileges users groups scheduling full transactional log backups user system databases production environment working recovery models undertaking database recovery based recovery point objective rpo recovery time objective rto ensuring disaster recovery high availability using database mirroring replication sql server clustering installing configuring failover clustering alwayson availability group critical server fixing database corruption rebuilding indexes database maintenances improving performance running index tuning wizard creating rebuilding reorganizing indexes various tables refreshing databases production lower environments automating jobs using sql server agent service scheduling jobs automate different activities monitoring database health disk space job alert index monitoring stats monitoring backup verification monitoring server activity error logs space usage solving problems needed executing different maintenance plan backups index management fragmentation management creating alerts notifications system errors insufficient resources fatal database errors executing different maintenance plan backups index management fragmentation management cleaning history deleting old files environment microsoft sql server 20122014 management studio database engine tuning advisor perfmon dynamic management studio sql profiles dbcc dmv 012016 012017 database administrator accenture contractor jobs fort lauderdale fl installation configuration upgrading microsoft sql server setting new sql servers databases creating logins users schema databases creation databases tables views created logins roles appropriate permissions experience backups restores recovery models establishing database maintenance monitoring sql jobs executing different maintenance plan backups index management fragmentation management cleaning history deleting old files configured managed log shipping mirroring monitoring sql services database connectivity memory settings monitoring cpu usage disk io activity troubleshoot various problems arise daytoday work fix issues monitoring sql server error logs fixing database corruption rebuilding indexes database maintenances automating jobs using sql server agent service monitoring server activity error logs space usage solving problems needed environment ms sql server 201220142016 windows server 20122016 transactsql ssis ssrs ssas education bcs computer science professional certification administering microsoft sql server 20122014 databases