professional summary accomplishments skills jessica claire 100 montgomery st 10th floor 555 4321000 resumesampleexamplecom detailoriented database administrator 7 years experience managing sql server databases production environments maintained servers systems ensure smooth business operations passionate contributor team success track record empowering teams selfstarter versatile database technologies always motivated learn grow stay current automated processes reduce workflow creating maintainance plan runs daily reorganize rebuild update statistics backup cleanup task environment migrated sql databases onprem azure configure georeplication high availability manage database elastic pools manage instances setup manage alwayson high availability hadr high availability disaster recovery setup manage log shipping automate synchronize backups restore secondary servers disaster recovery addition security mission critical databases environment create data models new modernized legacy databases implement database design following best recommendations maximize performance reduce data redundancy inconsistencies understand need business requirement document outlines business needs conceptual logical good strategy physical model design like normalization oltp vs olap maintain database security consistency sql server databases running database validation checks database consistency checks proactively resolve data corruption inconsistencies installed sql standaloneclustered database migration microsoft azure log shipping alwayson high availability traditional failover mirroring replication performance monitoring tuning data modeling application design azure network storage disaster recovery managed instances elastic pools azure vms managed azure compute services oncall 247 rotation production support etl pentaho data integration ssis proffesional backgrown experience senior sql serverazure database administrator adt security services inc oldsmar fl 052019 current produced highstandard database solutions meet stability reliability performance metrics administered sql server databases production environments ranging 2012 2019 versions install configure sql server database standalonecluster environment availability groups set controlled user profiles access levels database segment protect essential data creating granting monitoring user access rights privileges roles profiles involved administering servers creating user logins appropriate roles logins monitoring user accounts creation groups granting privileges users groups configured sql server 2016 always availability groups involved analyzing upgrading sql server 2008 sql server 2016 performed database migration sql server databases microsoft azure hosted dbs managed instances comprehensive knowledge sql server deployment migration patching troubleshooting optimization maintenance modelling highavailability ha disaster recovery dr configured high availability solution clustering alwayson database mirroring log shipping manage database security users active directory ensure database integrity setup maintenance plans via sql agent involved planning setup implementation new servers across entire enterprise sco server database administrator adt security services inc brooklyn park mn 092018 082019 oncall 247 sql server production database administration support monitoring proactive problem resolution involved planning setup implementation new servers across entire enterprise minimized downtime optimizing monitoring high availability sql server applying database mirroring log shipping traditional failover clustering alwayson cluster methods performance monitoring sql profiler optimize queries enhance database server performance provide dba support technical expertise multiple applications development test production sql server 20162017 environment responsible working 2008 2012 2014 2016 versions sql involved building new secondary data center servers configuring sql 200820122016 dr strategy performed log shipping replication mirroring implemented high availability techniques setting automaticforced fail production servers auditing database logins users transactions database activities resolving orphan users troubleshoot blocking deadlocking issues making appropriate changes transaction isolation levels types locks held avoid keeping transactions open long durations breaking large transactions smaller ones scheduling monitoring sql agent jobs designed developed script refresh selective data production development implementing support business needs deadlines work serversan team diagnose io latency occurring several vms configured hadr techniques log shipping alwayson sco server database administrator pike solutions city state 062015 042018 worked migrating sql server sql server 2012 sql server 20142016 design implement appropriate database maintenance database systems index maintenance update statistics backup strategies work application teams tuning queries causes extended blocking deadlock locking developed automated tasks daily weekly monthly database maintenance database backup database integrity verification indexing using controlm agent sql server agent developed complex tsql script stored procedure improve performance preserve referential integrity provide application functionality worked linked server run distributed queries sql server oracle databases periodically apply required service packs cumulative updates database servers configured transparent data encryption tde backuprestore strategies encrypted databases followed standard practices migrating changes test production environments developed custom database objects stored procedures delivered application support created updated database designs data models set controlled user profiles access levels database segment protect important data maintained complex tsql queries views stored procedures multidatabase environment little supervision designed implemented tsql queries reporting complex solution development built databases table structures web applications implemented system enhancements design develop solutions address problem reports administered supported monitored databases proactively resolving database issues maintaining servers worked staff develop implement procedures prevent data loss maximize system availability determined database structural requirements working business stakeholders identify optimal database specifications implemented bi solution framework business intelligence projects education bachelor science training jawaharlal nehru technological university hyderabad india certifications microsoft certified azure administrator associate az104 microsoft certified azure database administrator associate dp300 042015