summary skills jessica claire 100 montgomery st 10th floor555 4321000 resumesampleexamplecom skilled database administrator bringing seven years experience design administration databases well key skills managing monitoring optimizing troubleshooting maintain integrity security availability databases hands experience migration premis azure extensive experience sql server features log shipping replication mirroring always ssis ssrs teamoriented firstrate oral written communication complex problemsolving decisionmaking abilities adept managing concurrent objectives promote efficiency outcomes operating system windows server 20082010201520172019 databases ms sql server 20192016201420122008r22008 tools sql server management studio ssms sscm ssdt ssis ssrs sql profiler extended events activity monitor database engine tuning advisor query analyzer windows performance monitor dmvs dmfs languages tsql html xml power shell thirdparty tools redgate sql back foglight service performance tuning db upgrade migration azure managing hadr features maintaining security encryptions ssrs ssis power bi proper documentation planning executing project time experience sql dbassis developer education training 062021 current northstar financial services group llc melville ny defined database design specifications based upon project requirements specified user access levels database segment protect database integrity company information created proper backup maintenance plan production reporting database wrote scripts processes data integration bug fixes created reporting database setup tableau connection reporting developed ssis etl process automated packages write sql queries join multiple tables tableau reporting implemented hippa compliance using rubric dacabase administrator accenture contractor jobs arlington va 112018 052021 created configured automated sql server agent jobs limited database backups integrity checks indexing maintenance update statistics maintained integrity security availability ms sql server databases ensured databases backed way meets businesss rpo rto established plan migration well applying service packs hot fix cumulative updates development test production environment configured supported high availability ha disaster recovery dr strategies including clustering alwayson availability groups monitored tuned troubleshoot resolved issues including limited sql server performance database integrity locks deadlocks connectivity security native monitoring tools well third party tools established hardware requirements devised storage capacity solutions maintained db integrity limiting redundancy using system user defined integrity worked application developers deliver data design stored procedures functions views performed security assessments secure database environment tde always encryption created roles provided proper access based need approval took charge installation upgrade configuration migration ms sql server clustered nonclustered production environments managed ssis ssrs packages involved designing configuring monitoring troubleshooting replication methodologies performed sql server database refresh setup transactional replication synchronize subset tables multiple subscribers realtime reporting purpose clear understanding practice hippa regulations partnered project management teams development scope timelines assessed customer needs goals communication system evaluations modify existing databases personalized customization established hardware requirements devised storage capacity solutions oltp db defined database design specifications based upon project requirements mentored newly hired employees offering insight job duties company policies easier transition job position maintained proper documentation major changes updates fixes 022017 092018 sco database administrator accenture contractor jobs hartford ct installed configured administered transactional replication configures always ag critical databases managed server databases level tde well always encryption executed migration projects timely manner proper documentation performed execution plans analysis resourceintensive sql queries stored procedures views optimized better performance maintaining high levels performance availability sustainability security implementing managing high availability ha disaster recovery dr options sql server replication mirroring clustering alwayson performed 24x 7 scheduled emergency technical support making sure standard backup policies implemented across servers implemented tested point time recovery production databases responsible monitoring making recommendations performance improvement exported imported data files source flat files row files using dts sql server integration services sco database administrator johns hopkins university city state 082015 122016 managed database migration ms sql servers 2008r2 sql server 2014 performed product upgradesinstalled services packs created granted monitored user access rights privileges roles profiles supported multiple databases production development test staging purposes sun solaris windows environments utilized monitoring tools query execution plans maintain increase query efficiency performed root cause analysis query performance issues worked application developers design tuning indexing tables helped improve performance queries analyzing execution plans monitoring resource utilization database engine tuning tool identify indexesstatistics help performance tuning wrote scripts processes data integration bug fixes developed data models database designs plan projects bachelor science computer science 052011 mount ida college newton center