jessica claire resumesampleexamplecom 555 4321000 100 montgomery st 10th floor summary microsoft certified dba 7 years practical experience database administration large complex databases development test production cloud environments strong interpersonal communication problemsolving skills ability effectively interact technical nontechnical staff levels ability work independently well team environment professional summary 7 years experience working information technology proven track record working fastpaced environment skills technical skills performance monitoring tuning tools database engine tuning advisor sql server profiler extended sessions activity monitor monitor statistics 10time execution plan performance monitor dmv system stored procedures rdms tools ms sql server 201920172016201420122008200 sql loader import export powershell thirdparty tools idera diagnostic manager system center suits scom scsm modulator solarwinds redate spotlight sql sentry apex sql microsoft systems center cente 2012 scom litespeed operating system windows server 2019 20121 2012r220122008r220082003 backup software sql backup lite speed red gate idera backup exec etl tools ssis bi bids ssdt scripting tool powershell virtualization vmware hyperv language tsql begging c power shell aspnet web development good understandin html css json ms sharepoint admin sharepoint 201620132010 source code repository tfs git backup software sql backup lite speed red gate idera backup exec reporting audit tools ssrs repor builder idera sql compliance manager secure cloud computing microsoft azure database modelling tools power bi desktop erwin data modeler sql transactional replications security protocols enterprise information architecture warehouse models san technologies quality analysis deep learning data mining reverse engineering skills microsoft office data data management critical thinking friendly positive attitude team management relationship building training development computer skills problem resolution active listening active lister good work ethic maintenance repair team building team building database analysis microsoft powershell microsoft sql continuous process improvement writing quer queries data conversion migration data testing coding data information systems management database administration document management agile methodology planning organizing ppe use project management amazon web services python programming languages java c n source version control git githul databases oracle mongodb rdms development sql software testing validation continuous integration systems analytical thinking problem solvin data structures algorithms objectoriented programming data storage retrieval software documentation control debugging troubleshooting scripting languages php python javascript performance analytics experience caci international inc sr database engineer 042021 current va installing configuring managing server 2019 2017 2016 2014 production lower environments responsible providing sql server problem resolution provide 24x7 production support server outages create users assign permissions based level database access user would need monitor backups ensuring performed regularly responsible largescale database migration sql server 2008r2 sql server 2014 2016 creating monitoring azure sql server databases configuring maintaining elastic db pools migrating onpremise database azure cloud cloud onpremise using multiple methods writing testing maintaining tsql stored procedures triggers views functions working teams teams change control ticketing systems coordinate changes infrastructure implementing hadr solutions alwayson replication clustering log shipping time time recover databases specific point time per requests troubleshoot various problems arise daytoday work fix issues monitoring sql server error logs checking email alert one configured failed jobs available disc space log sizes developing deploying ssis ssrs monitoring performance tuning physical server level database level database settings options query tuning applying service packs cumulative updates implemented robust backup strategy across production nonproduction environment meet rto rpo document changes made environment includes installations upgrades service packs hotfixes applied new databases added logins roles addedremoved infrastructure changes process improvements created backup jobs different types backups full differential transaction log 4 page 2 citigroup new york united states january 2018 may 2021 sql server dba server dra responsibilities installed configured monitored sql server 2017 2016 2014 2012 versions different editions monitored troubleshoot performance issues database optimized tsql queries stored procedures functions etc managed azure sql database azure managed instance mallage involved daytoday activities agent jobs backups recovery index database growth health consistency check performed various data migration tasks missioncritical databases implemented hadr solutions alwayson replication clustering monitored tuned aspects sql server infrastructure like disk cpu memory sql code etc using perfmon profiler dynamic management views dynamic management function monitored complete server environment resource utilization avoid bottlenecks configured maintained transactional snapshot merge replication created backup jobs different types backups full differential transaction log created jobs database maintenance index fragmentation rebuild database statistics pinnacle technical resources inc sql server dba carlsbad ca 012018 052021 installed configured monitored sql server 2017 2016 2014 2012 versions different editions monitored troubleshoot performance issues database optimized tsql queries stored procedures functions etc managed azure sql database azure managed instance involved daytoday activities agent jobs backups recovery index database growth health consistency check performed various data migration tasks missioncritical databases implemented hadr implemented hadr solutions alwayson replication clustering monitored tuned aspects sql server infrastructure like disk cpu memory sql code etc using perfmon profiler dynamic management views dynamic management function monitored complete server environment resource utilization avoid bottlenecks configured maintained transactional snapshot merge replication created backup jobs different types backups full differential transaction log created jobs database maintenance index fragmentation rebuild database statistics provided support complex issues related software tools applications databases created monitored performance metrics keep databases functioning optimal capacity defined synchronization plan patch management solved complex analytical problems using statistical models data established security controls help protect client systems supported planning software development purchases coordinated implementation collaborated stakeholders gather business requirements enhancements change requests communicated data architects programmers engineers keep projects track developed data models database designs plan projects wrote scripts processes data integration bug fixes defined database design specifications based upon project requirements performed quality assurance processes support data warehouse improvements analyzed developed technical functional specifications databases pinnacle technical resources inc sql server dba tx 122014 112017 installed sql server 201620142012 instances worked change requests permissions requests refresh requests create users assign permissions based level database access user would need configured maintained log shipping always sql clustering create linked servers sql servers databases monitor backups ensuring performed regularly time time recover databases specific point time per requests troubleshoot various problems arise daytoday work fix issues monitoring sql server error logs checking email alert one configured failed jobs available disc space log sizes writing reviewing optimizing adhoc tsql code stored procedures view trigger indexes tables statistics functions monitoring performance tuning physical server level database level database settings options query tuning documenting major changes sql servers applying service packs cumulative updates hotfixes education training university maryland baltimore county baltimore md 122020 master science data science bahir dar university 072013 bachelor science chemical engineering administering microsoft sql server 20122014 databases certification 3 page additional information experience installing configuring managing microsoft sql server 20192017 2016 2014 2012 2008 overproduction lower environments managing sql server databases multiple product lifecycle environments development missioncritical production systems experience writing reviewing optimizing adhoc tsql code stored procedures view trigger indexes tables statistics functions capacity planning analyze past present predict future data growth disk usage trending recommending troubleshooting memory cpu storagerelated issues high availability disaster recovery solutions experience managing hadr including backup recovery replication log shipping database mirroring sql clustering alwayson availability groups performance monitoring tuning backl ability proactively monitor application database environment optimize performance troubleshooting performancerelated issues using builtin sql server thirdparty tools backup recovery implementing robust backup recovery strategy across production nonproduction environment meet rto rpo data security implementing server database level security making sure servers databases highly secured e lever securit implementing server database level encryption solutions including tde always encrypted dynamic data masking database migration experience migrating server databases lower higher versi version onpremises environments premises publicprivate cloud automation automate run regular database maintenance tasks backups integrity checks index rebuild reorganization file purges implementing azure elastic pool handson experience working ssis ssrs ssas serve company needs azure configuring azure services paas iaas laas experience creating monitoring azure sql server databases experience managing monitoring azure virtual machines experience implementing managing azure networking configured maintained elastic db db pools 2 page experience configuring monitoring georeplication synchronizations using hubmember topologies planning implementing storage backup recovery services experience configuring backups restoring database recovery vault configured always availability groups using cloud vms strong experience designing implementing backup disaster recovery strategies per rpo rto values experience migrating onpremise database cloud cloud onpremise using multiple methods experience powershell scripting provide 24 x 7 dedicated oncall support sql server production databases