jessica claire 100 montgomery st 10th floor 555 4321000 resumesampleexamplecom summary accomplished qualified professional diverse extensive onpremises azure cloud database administration experiences effective team member including work senior microsoft sql dba database design system administration using microsoft sql server 2012201420162017 2019 experienced msazure cloud environment design administering azure sql databases key strengths include problemsolving skills attention detail multitasking ability build effective business relationships even times high stress deployments extensive project management experience process oriented deeply experienced providing solutions performance issues equipped excellent work ethic possesses strong sense responsibility teamwork track record dependability possess excellent verbal written presentation skills mssql server experiences microsoft sql server dba 9 years experience designing coding testing supporting nextgeneration database solutions sql server environment possess strong communication problemsolving skills developed variety projects offer proven ability team work proactive system support experience installing configuring administration maintenance mission critical client databases sql server 2012 2014 2016 2017 2019 versions good experience configuring sql server aws relational database management system ec2 extensive experience upgrading sql server place side side upgrade based application compatibility fixing orphan users experience implementing sql server security object permissions like creation users granting permissions assigning roles users deployment administration operational support production development test environments utilizing proper change management itil best practices using ticketing tool good experience implementing troubleshooting high availability database servers using replication log shipping database mirroring failover clustering always ag strong experience understanding creating server level database level roles per business requirement experience configuring scheduling sql server agent jobs alerts operators maintenance plans database mail configuration facets transparent data encryption extensive experience monitoring performance tuning analyzing db performance issues strong experience designing implementing backup disaster recovery strategies per rpo rto values skills windows server os sql server tsql awsrds aws ec2 idera sql diagnostic manager sql safe 60 redgate sql compare 10 data compare 10 dataedo erwin ssdt azure ssis ssrs ssms dta jira raid mysql litespeed azure vm azure managed instance mulesoft salesforce api experience azuresql server database administrator 062019 current cgi group inc sterling va azure cloud professional strong experience migrating resources azure azure adminstration azure infrastructure operations end end project managment produced highstandard database solutions meet stability reliability bash powershell migrate sqlserver databases microsoft azure hosted dbs managed instances performed database migration onpremises sql environment azure database cloud managed database security users active directory ensure database integrity setup maintenance plans via sql agent managed servers database level security implementing triple aaa authentication authorization auditing users authenticated various security protocols participate oncall support rotation provide nonstandard work hour support provides database support business users restores functionality database processes failed documents resolutions creates maintains troubleshooting documentation employs general sql microsoft tsql stored procedures date transformation services dts scripts sql server integration services ssis manage database systems automate data migration processing designs develops implements database tables views triggers indexes stored procedures ensure data integrity custom applications communicates management peers regarding database solutions potential enhancements designs develops tests documents implements scripts automate data importing exporting reporting analysis ensure data confidentiality availability integrity installing configuring administering securing production nonproduction servers clustered nonclustered upgrading sql server 2016 sql server 2019 experience implementing windows cluster across multiple availability zones implemented sql server 2016 always availability group aws managed sql server logins database users roles involved daily user maintenance created database maintenance jobs perform full transaction log backups scheduled sql server agent job scheduler monitor database growth activities troubleshoot transaction log issue created configured mirroring disaster recovery providing weekly status information projects project manager wrote debugged stored procedures ddl dml triggers functions per client requirements logical physical design database projects basis user requirements using erwin reporting weekly basis project manager extensively worked troubleshooting finetuning databases optimal performance worked performance tuningquery tuning execution plans trace flags sql profiler installation service packs environments environment sql server 20122019 awsrds awsec2 idera sql diagnostic manager sql safe 60 redgate sql compare 10 data compare 10 visio 2010 dataedo erwin sql server database administrator 022016 052019 cgi group inc strongsville oh installed configured various editions versions sql server standalone clustered nodes installed configured sql server failover cluster sql server 20014 2016 applied service packs hotfixes cumulative updates upgraded sql server 2012 r2 database sql server 2014 2016 created maintained logins users roles managed security database implemented disaster recovery plan performing routine backups restore taking full differential transactional log backups setting automated jobs migrated data using importexport bulk backuprestore dts ssis detachattach performed data extracting transforming loading etl different data sources rebuilding reorganize indexes reduce fragmentation enhance sql server performance created triggers views stored procedures implemented database maintenance plans scheduled automated sql server jobs created alerts operators notifications configured database mail hands experience monitoring performance tuning using tuning advisor sql server profiler activity monitor windows performance monitor dbcc dmvs stored procedures working resource governor control allocate cpu memory resources depending priority applications configured managed database high availability replication database mirroring log shipping failover clustering always availability group scheduled reports using ssrs generate daily weekly monthly quarterly reports worked team integrated developers cab change approval board disaster recovery planning team experience contacting microsoft vendors product technical support providing resolution assigned tickets jira team track service desk per severity meet deadline sla due experience agile projects solid foundation software development lifecycle sdlc environment sql server 2008 2014 idera sql diagnostic redgate sql compare 10 data compare 10 visio 2010 ssdt sql server database administrator 092014 022016 mastercard city state database high availability installed configured maintained alwayson high availability group using sql server 2012installed configured maintained failover clustering using sql server 2008 installed configured maintained database mirroring using automatic failover option sql server 2012 configured log shipping standby database production database reporting purposes configured maintained replications database upgrade sql server sql server 2008 r2 sql server 2012 database migration migrated ms access 2012 r2 2014 database ms sql server migrated oracle 10g mysql ms sql server 2012 data modeling worked 10 data modeling projects generated er diagrams data modeling tools used using sql server data diagram database monitoringperformance tuning strong database monitoring performance tuning scheduled jobs automate different database related activities including backup monitoring database health disk space backup verification monitor sql server error log space usage database programming wrote tsql trigger storedprocedures assisted database developers optimize sql queries stored procedures etl tools used etl tools like dts ssis importexport bcp bulk copy import export data flat files excel ms sql server databases export import data oracle sql server excel setup performed etl data load oracle flat files like text excel csv files backuprecovery proficient database backup disaster recovery experienced pointintime recovery restored database backup report development installed configured administered sql server reporting services developed reports using ssrs deployed reports developed adhoc reports using report builder 30 20 used dbcc check database conditions rebuilding indexes database maintenance purposes well environment sql server 2012 2014 sql server 2012 ssms profiler extended events perfmon raid education training bachelor science computer science 082009 unity university certifications certificate mcdba administering microsoft sql server 20122014 70462