jessica claire 100 montgomery st 10th floor 555 4321000 resumesampleexamplecom summary clientfocused database administrator 7 years proactively working toward achieving high client satisfaction professional much committed maintain cutting edge technical skills uptodate industry knowledge deadlinefocused broad skill range including database design development support ms sql server 201920172016201420122008r2in production uat test development cluster server environments strong skill set database administration using windows platform always eager acquire knowledge share colleagues part multiple professional groups participate blogging like pass sql saturday sql server central skills guest services inventory control procedures merchandising expertise experience sql server dba 032020 current pinnacle technical resources inc philadelphia pa loss prevention cash register operations product promotions installed configured sql server 20122014 201620172019 production nonproduction servers standalone clustered servers migrated 200 databases sql server 2008 2012 sql server 20172019 part data center migration project troubleshoot related issues reported post migration experienced installing configuring alwayson availability groups aag dr troubleshooting administering sql server high availability disaster recovery strategies log shipping mirroring replication configured implemented alwayson availability groups one primary two secondary replicas hadr manage logins users assign roles auditing applied least privileges tde ensure data security experience knowledgeable designing critical production database backup recovery strategies following customer slas contracts satisfy rtos rpos experience setting full diff trans logs backups scheduling jobs alerts also monitoring jobs troubleshooting case failure experience successfully restorerecovering corrupted database using different backup recovery techniques experience capacity planning sql server databases managing monitoring disk space usage datafile log file usage using native tools thirdparty tools like solarwinds sup gold part team dba task project effective design sql server database following best practice successful come plan patch upgrademigrated 200 database running multiple instances implemented monitored transactional replication dr reporting purposes created database objects tables stored procedures views triggers setup configured alwayson availability groups multiple databases working database backup strategies scheduling jobs working failures redesigned database maintenance plan freed 30 disk space avoiding frequent running dbcc checks adjusting fill factor rebuilding indexes based fragmentation level implemented userdefined server roles sql server 2012 default schemas groups created jobs maintenance plans better performance server jobs include index rebuildreorgs dbcc check update database stats database cleanup ssis packages help data migration created alerts database mail simple mail transfer protocol smtp worked extensively query analyzer profiler tuning queries using variable characteristics query costs setup maintained linked servers implemented transparent data encryption tde protect sensitive data backups used database consistency checks dbcc commands database maintenance created maintenance plans integrity checks resolved issues related modified stored procedures complex tsql queries improve query execution process used sql profiler serverside trace identify performance issues server managing sql server workload using resource governor improved query performance analyzing stats query execution plans system performance system performance analysis used sql profiler optimizing stored procedures monitored sql server databases using solar winds created custom statistics reports users tableau knowledgeable migrating prem databases azure using database migration assistant dma techniques like bacpac back restore azure blob storage installation setup mongodb ops manager mongo atlas supported 247 call rotation database infrastructure willing team player environment sql server 20082012201620172019 windows server 200820122016 ssis solar winds vmware san sql profiler ssms dma azure oracle veeam always log shipping replication mirroring etc sql server dba 022019 032020 pinnacle technical resources inc alpharetta ga sql server installation database setupconfiguration 2012 2014 2016 premise locations different trust levels domains planning implementing sql server patching quarterly basis nonprod prod environments configuring managing sql alwayson high availability environment local clusters geoclusters troubleshooting availability groups issues monitoring sql serverdatabase health checks performance related issues using bmc patrol database mail alerts identify usage old sql servers sql 2000 sql 2005 migrateupgrade databases higher versions based application compatibility planning decommission implement support high availability mirroring log shipping transactional replication managing 200 database instance multiple databases running vms physical machines maintain integrity availability recoverability production data systems planning overall data deployment operational health troubleshooting debugging performance optimization sql server database application related issues conducting database refresh week prod uat dev test environments monitoring sql server error logs disk space growth clustering environment planning applying latest service packs cu different versions sql server worked performance tuning identifying locking blocking long running queries works yearly password renewal activities sql server service accounts password vault monitor server capacity make recommendations hardware upgrades addons eg processors disk space memory accommodate current planned server usage monitoring configuring database backups using third party tools netbackup tool native sql backup maintenance jobs create linked servers sql server oracle server databases refreshing development databases production data per application teams request deploy ssis packages sql servers configured jobs using ssis packages based user requirements using dedicated proxy accounts migrating databases db objects dev qa prod environments using exportimport wizard andor generate scripts back restore methods managing sql server database level security like creating managing logins database users user permissions review performance stats recommend changes database tuning query optimization diagnosing fixing sql performance issues works performance tuning identifying locking blocking long running queries monitoring making recommendations performance improvement hosted databases involved index creation index modification code optimization adding scheduled jobs reindex update statistics databases using sql compliance tool compare migrate database objects schema one server another maintain update sql inventory database growth report regular basis communicating clients ensure enduser discrepancies resolved supported 247 mission critical infrastructure involve call rotation process support business databases application environment ms sql server 201620142008r22005 tsql ssis sql profiler log shipping always mirroring clustering windows server 2012r2 windows server 2008r2 powershell ms dos sharepoint 2010 oracle 10g vmware solarwinds apache san etc data analyst 032017 022019 cushman wakefield glendale ca collected tracked reviewed data evaluate business market trends reviewed business requirements revised implementation strategies resolve data issues education training bachelor science mathematic economics 112007 university benin benin city nigeria