professional summary jessica claire 100 montgomery st 10th floor 555 4321000 resumesampleexamplecom experienced sql server database administrator around 10 years expertise 247365 production environments posses extensive knowledge sql server installations configurations db backups pointintime database recovery procedures database tuning migrations sql transaction snapshot replication windows clustering database mirroring always standby databases setup database encryptionsecurity application data warehousing support ssisssrsssas along working hybrid cloud based environments tuning sql servers cloud platforms excellent communicator advanced presentation creation delivery skills technical skills architecture designdevelopment enterprise level database administration business analysiscapacity planning implementationconfiguration data backup retrieval database upgrademigrationsconversions high availability disaster recovery training documentation power shell scripting work history senior sql server dba safelite autoglass burnsville mn database securityencryption bigdata nosql technologies troubleshootingperformance optimization data warehousingssisssrsssas virtualizationcloudssaspaas azureawsvmware technical team leadership excellent problem solving abilities excellent communication skills 092021 current installed configured maintained premises sql server 20122014201620172019 clustered standalone environment migrated premises sql databases azureaws designed databases support business applications ensuring system scalability security performance reliability configured maintained always failover clustered highavailability environment sql server 2014 worked refreshing oracle data prod non prod environments migrated team server foundation sql server azure devops extensively provided etl application support ssis package administration deployment troubleshooting performed ssrs server migration sql 2012 sql 2016 performed sql server database migrations sql 2012 sql 2019 configured transparent data encryption tde backuprestore strategies encrypted databases designed developed scripts refresh selective data production development qa production support environments engaged security auditssql patching disaster recovery measures interact developers network virtualization storage systems operations teams resolve problems applications database systems worked backup strategies index maintenance database consistency checks part database maintenance administered monitored 247 applications systems developing automated alerts warn failures maintained detailed documentation solution designs business requirements environment ms sql server 2008r220122014201620172019 windows 2008r220122016 ssis ssas ssrs power bicrystal reports ms access oracle 11g vmware solarwinds dpa visual studio 2017azure devops server secior sql server database administrator geico insurance carbondale il 092013 082021 installed configured maintained premises sql server 201220142016 clustered standalone environment extensively provided sql support sql auditing patching etl packages ssrsssas encryption backup strategies extensively worked ha dr solutions meet customer requirements various state agencies configured alwayson synchronous asynchronous secondary replicas 2 node cluster worked applying service pack upgrade sql 2012 sp3 sql 2012 sp4 2 node always cluster consistently met deadlines requirements production deployments worked cdc change data capture automated cdc process data warehousing needs provided continued database maintenance support applied sql patchesbug fixes existing database servers service pack upgrade project installed r sql server 2017 data analytics extensively worked deploying ssis packages deploying ssas cubes part data warehousing needs extensively worked server level query level tuning effective performance extensively worked configuring ssrs various agencies docetfdoadot sql server 2016 installed ssl encrypted certificate worked configuring snapshot transnational replication sql 20142016 servers worked creating crystal reports using ssrs power bi creating datasets data sources sending automated reports worked deployingdeveloping sql ssis packages validating errors deploying resolving required various versions sql servers sql 20122014 2016 installed ssl encrypted certificate windows cluster use sql server force encryption incoming sql server connections database servers created house monitoring system using power shell scripts getting backup reports various sql server alerts migrated ssrs reports native ssrs reports latest sql power bi reports extensively worked automating manual process like backuprestores automating sql server build processes creating templates sql 201220142016 versions environment ms sql server 2008r22012201420162017 windows 2008r220122016 ssisssas ssrs power bicrystal reports ms access vmware commvault idera sql diagnostic manager windows clusteringaws azure secior sql database administrator 102012 092013 freddie mac irvine ca installed configured maintained premises sql server 20082008r220122014 clustered standalone environment extensively worked sql server database design development implementing support business needs deadlines designed developed scripts refresh selective data production development qa production support environments consult service owners managers senior project managers order prioritize scope technical needs advanced technology high impact projects involved lead effort setting ssas tabular model server user security part data warehousing project interface crossfunctional teams departments access understand business needs implemented company policies technical procedures standards preserving integrity security data reports access extensively used sql server db snapshot backuprestore strategy part quarterly application upgrade evaluate test new versions features sql server 2012 worked capacity planning providing strategies ongoing increase data storage data maintenance utilized red gate tools sql compare sql data compare promoting modified objects development acceptance productions work serversan team diagnose io latency occurring several vms suffering io taking longer 15 seconds configured hadr techniques log shipping always extensively worked data migration physical virtual virtual virtual across various versions sql server manage hierarchical security access control permissions encryption keys certificates databases ensure data integrity using templates schemas per sarbanesoxley actsox hippa rules engage security audits database encryption disaster recovery measures create serverdatabase level sql auditing ddl trigger change data capture cdc troubleshoot connectivity dns security firewall issues work domain admins create appropriate service principle name spn implementing kerberos authentication sql servers work change control process deploying changes production servers environment ms sql server 200520082008r220122014 windows 2008 2008r22012ssis ssrs ssas redgate tool belt spotlight power bicrystal reports ms access vmware aws education bachelor science southern illinois university carbondale carbondale il 052011