jessica claire 100 montgomery st 10th floor 555 4321000 resumesampleexamplecom professional summary summery microsoft certified sql server database administrator 9 years diverse extensive experience azure cloud onpremises progressive project management experience process oriented deeply experienced providing solutions performance issues equipped excellent work ethic possesses strong sense responsibility excellent communication skills great team player skills high availability disaster recovery database securityencryption work history 012021 current sql server dba pinnacle technical resources inc bothell wa troubleshootingperformance optimization data warehousingssisssrsssas achieved progressive work experience sql database analysis design development test deployment installation configuration administration sql server 200520082008r220122014201620172019 applies patches service packs cumulative updates cu hotfixes experience continuous improvement continuous delivery cicd database projects extensive migration experience onpremises sql databases azure aws environments managing providing end end support problem resolution sql server databases multiple product lifecycle environments development testing missioncritical production systems administering server database level security based company policy microsoft best practice extensive experience implementing hadr solutions across multiple zones including windows cluster always availability group replication log shipping strong experience designing implementing backup disaster recovery strategies per rpo rto business requirement extensively working troubleshooting monitoring databases optimal performance proactive tracking database performance metrics conducting root cause analysis rca repeated incidents expertise creating monitoring index fragmentation performing index rebuild reorganize regular intervals depending fragmentation level expertise data modeling conversion normalization validation designing building enterprise database systems includes security quality recoverability defining relationship tables enforced referential integrity constraints highly proficient designing developing implementing database tables views triggers indexes stored procedures ensure data integrity custom applications proficiently developing etl tasks using ssis ssrs manage database systems automate etl processes restores functionality database processes failed documents resolutions creates maintains troubleshooting documentation communicate management peers resolve problems applications database systems potential enhancements maintained detailed documentation solution designs business requirements provide support 247 oncall support data load business rotational basis experience agile projects solid foundation software development lifecycle sdlc consistently met deadlines requirements production deployments successful databases migration older version ms sql server newer ones created configured azure subscriptions resources groups deploy resources azure sql databases virtual machines azure storages virtual networks analyzed evaluated azure pricing availability options reliability security azure resources deployment azure adviser administrating production nonproduction snowflake database including controlling permission privileges snowflake database objects extensively working business continuity plan bcp projects testing ensure high availability critical production databases implementing hadr solutions meet business requirements always availability group replication log shipping maintaining backup strategies based company rto rpo automating routine database maintenance operations index maintenance database consistency check update statistics tasks monitoring database growth activities troubleshoot transaction log issues regularly creating reviewing tsql scripts verify meets standards performance tuning error handling according dba standards implementing utilizing supported features sql server transparent data encryption tde change data capture temporal system versioned tables policy based management resource governor performed tasks query optimization troubleshooting clientserver connectivity issues performance tuning reviewed optimized sql queries improve performance monitored troubleshooter database server performance systemwide scale effectively identify network databases memory cpu disk space io related bottlenecks creating sql server integration services ssis manage database systems automate data transformation process delivering ssrs reports provide valuable business insight providing resolution assigned tickets jira team track service desk per priority meet agreed service level agreements slas uptime servers collaborate scrum teams attend team meetings contribute leadership report ensure database work meets standards well delivered technical documentation reporting weekly basis project manager work closely crossfunctional teams providing weekly status information projects project manager 012018 122020 sql server dba pinnacle technical resources inc bowie md installed configured administered sql server 20082008r2201220142016 servers production non production environments performed upgrades applied service packs cumulative updates cu hotfixes good experience configuring sql server aws rds ec2 worked closely system administrators development teams administer upgrades migrated troubleshoot production nonproduction servers physical virtual machine environments administered maintained developed implemented policies procedures ensure security integrity sql server databases administered user privileges monitored security audit following company microsoft best practices implemented backup recovery strategies following companys recovery point objective rpo recovery time objective rto retention policy implemented hadr solutions always availability group replication log shipping based company sla worked creating statistics reorganizing rebuilding indexes database space management performance monitoring alert management effectively worked capacity planning ensure sufficient underlying resources available database servers increased size files reviewed optimized tsql queries improve performance scheduled jobs automate database related activities including backup meet production service delivery monitoring database health disk space backup verification monitored sql server error log space usage used dbcc check database conditions rebuild reorganize indexes needed responded production incidents addressed within service level agreement sla framework used ssis bcp utility bulk copy program importexport data various sources flat files ms excel ms sql server databases worked 10 data modeling projects generated er diagrams performed logical physical design databases projects basis user requirements using erwin 032013 122017 sql server dba pinnacle technical resources inc bristow va education designed built sql servers following microsoft best practice organizational standards managed administered development qa stagingproduction environments include process change management build process new development product releases maintained schema data changes large scale environment administered user privileges monitoring security audit issues set security groups logins roles users databases database level server level windows level extensively experienced performing administrative tasks database files management backuprestore security management database mirroring log shipping data integration synchronization verified backups error logs servers troubleshoot failures alert problems open tickets necessary work technicians departments defined enforced database standards policies security documentation worked performance tuning query tuning execution plans trace flags sql profiler performed etl extract transform load multiple data sources ms access ms excel csv files using ms sql integration services ssis bcp bulk insert implemented event handlers error handling ssis packages created ssis package refreshes type one type two dimension tables using slowly changing dimensions transformation wrote designed developed debugged tsql queries common table expressions cte views triggers functions indexes stored procedures ensure data integrity custom applications designed developed tested scripts automate data importing exporting reporting analysis ensure data confidentiality availability integrity migrated ms access 200320052008 r2 databases ms sql server oracle 10g mysql ms sql server 2012 exported imported data oracle sql server ms excel csv files performed etl data load installed configured administered developed reports using sql server reporting services ssrs ad hoc reports using report builder 30 20 created technical documentation database technologies providing updates needed 2013 bachelor science computer science mekelle university mekelle ethiopia certifications microsoft certified azure fundamentals 2022 microsoft certified professional administering microsoft sql server 20122014