summary jessica claire montgomery street san francisco ca 94105555 4321000 resumesampleexamplecom microsoft certified professional administering sql server 20082008r220122014 2016 8 years experience microsoft sql server database administrator developer manager production nonproduction environment experience core dba tasks like installation migration configuration including designing implementing disaster recovery procedures excellent problem solving ability good team player ability learn new emerging technologies skills installationconfiguration dss pci sql server migration tsql programing maintenance troubleshooting database security index tuning amazon web services aws scommirroring log shipping database design sql profiler ssis packages etl database encryption tde encryption replication always clustering professional sql server dbaproduction support dba experience computer services inc omaha ne 062017 current installed configured administered sql server 2008r220122014 2016 production development environments proactively regularly monitoring cpu disk io memory related bottlenecks deadlock carried similar tasks performed various troubleshooting methodologies identify resolve system user related issues installed configured windows server 2014 2016 failover clustering activepassive configured alwayson high availability disaster recovery dr solutions created jobs alerts notifications system errors insufficient resources fatal database errors hardware errors security breachtechnical guidance task assignment tracking managed database maintenance tasks index fragmentation dbcc operations monitoring performance optimizing queries maximum efficiency designed implemented deployed multitude applications utilizing aws stackincluding ec2 route53 s3 rds dynamo db sqs iam elastic load balancer elb vpc installed maintained monitored production sql servers making sure uptodate latest rollup patch service packs designed implemented log shipping mirroring replication primary site secondary site support mission critical applications offload queries wrote complex tsql script store procedure joins migrated multiple databasesssis packagesssrs reportsssas cubes different sql versions 2008r220122014 2016 inplace sidebyside migration methods implemented transparent data encryption tde used tde encrypted columns data pump perform business analysis write effective documentation specifications created ssis packages integrating data using ole db connection heterogeneous sources excel csv oracle flat file text format data using multiple transformations provided ssis data conversion conditional split bulk insert merge union designed complex reports using cascading parameters drillthrough reports parameterized reports report models adhoc reports using sql server reporting services ssrs based client requirementestablished database backup restore maintenance plans user system databases worked sql store procedure triggers functions views implementation ddl dml worked native third party performance monitoring tools like scom sql secure idera migrated current windows environment awsrahel environment worked script language using aws command line interface cli monitoring managing table spaces data files growth analysing tables schemas collecting system statistics rebuilding indexes worked several existing production users databases jobs packages reports linked server logins computer objects new versions sql server developed automated daily weekly monthly sql server agent jobs database backup integrity checks indexing maintenance update statistics worked performance tuning optimization stored procedures queries automated database refresh production test using custom scripts created databases logins roles granted appropriate permissions identified resolved security threats sql injection user name password masking applying sql credential proxy accounts worked soft ware development life cycle sdlc agile environments handling day day support tickets development production issues 24 x 7 production call support sco database administrator dbadeveloper freddie mac march 2014 city state 022014 052016 install configure administer ms sql server 2012 2014 monitored troubleshoot server performance database activities clients applications configure administer availability groups high availabilityalways multiple databases created complex stored procedures help developers optimize queries triggers database design udfs support efficient data storage manipulation successfully installed configured managed administer traditional sql server failover cluster 2 nodes worked relational database management tools fico debt management system finance created administered various jobs handle different tasks monitor resources various servers email necessary information threshold reached apply sql server patches service packs hotfixes cumulative updates required created documentation tracking implement database optimization performance tuning improvement using dynamic management views functions others design develop implement sql server reporting service extracts data present user friendly formats intensively analyzed existing system regard database management produced inception report describes existing situation pros cons future intervention plan action short midterm longterm administered sql server always high availability disaster recovery solutions including mirroring replication log shipping environment activities honors created linked servers perform distributed queries data transfer establish modality collect information documentation existing system develop proceduresprotocols database planning implementation database security aspects database auditing backup restore modality review current procedure backup restoration introduced differential back system periodic restoration backups applied sql server best practices including software development lifecycle provide support critical databases azure hyperv developers team database design data modeling normalization process extract transform load etl data warehouse flow object migration database maintenance consistency shrink databases worked database assisted developers created ssis packages data run dbcc commands check database participated enhancing end users understanding database systems conducting preimplementation trainingsworkshops different events manage large databases vldbs 1tb using table partitioning backup data compression multiple filegroups responsible designing implementing backup strategy required per requirement production development environments overall followup system user support address issues plan potential problems advance dacabase administrator dba unisys corporation city state 082009 012014 database administrator dba sep 2009 feb 2014 reston virginia environment sql server 2008r2201220142016 db2 oracle windows server 20082012r2 aws backup utilitynet backup quest spotlight sql lite speed ssis ssrs ssas pci dss c tde java script idera technologies like sql secure aws netfico vmware sharepoint master data services mdsextended events