jessica claire resumesampleexamplecom 555 4321000 100 montgomery st 10th floor professional summary 8 years expertise extensive knowledge database administer proficient diverse range development languages including sql server versions 2008 2008r2 2012 2014 2016 2017 2019 professional experience configuring maintaining monitoring administering microsoft sql server databases maintenance performance tuning security various database recovery techniques expertise highlights include installation upgrade configuration migration sql server clustered nonclustered production environments skills systems administration database development relational database management compiling data running backups excellent communication analytical critical thinking decision making education mekele university ethiopia 052006 bachelors information technology completed professional development information technology unity university addis ababa ethiopia 062009 ba accounting certifications microsoft certified mssql server 2012 database administration work history iron mountain sql server dba nashville tn 052019 current installation configuration maintenance administration ms sql server administering sql server high availability disaster recovery strategies experience database administration sql server 2012 2008 r2 2008 expertise tsql writing stored procedures triggers functions troubleshoot performance problems tuning queries index analysis worked troubleshooting production issues raising high availability worked configuring sql server minimum privileged access developed created new database objects including tables views index stored procedures functions advanced queries updated statistics using query analyzer enterprise manager existing servers maintaining referential ferential integrity domain integrity column integrity using available constraints options implemented high availability various servers using replication logshipping mirroring indexes regular intervals better performance rebultos responsible performance tuning optimization databases using tools like sql profiler query analyzer database engine tuning advisor installation upgrade configuration migration sql server clustered nonclustered production environments production managed virtual machine environments linked ms sql databases physical vm ware hypervisor day day support activities resolve system bugs assist business staff questions investigate issues configure support transactional replication publisher subscriber servers working agile team following strict agile principles participating sprint planning story development sprint retrospective daily stand ups created stored procedures parameters data retrieval insert update performance tuning long running sql queries stored procedures using sql profiler query execution plans confer endusers peers senior management define business requirements standards naming convention database objects developed ssis packages scheduling sql agent jobs automate execution developed new reports multiple data sources using ssrs packages work business analysts translate client requirements development projects design create sql server database objects like tables views stored procedures user defined data types functions etc iron mountain sql server dba royersford pa 102017042019 maintaining referential integrity domain integrity column integrity using available options constraints administrated managed sql server 2008r2 2005 production experienced detecting troubleshooting sql server related cpu memory io disk space resource contention created automate maintenance plans jobs achieve maximum performance experience rebuilding reorganizing indexes based index fragmentation levels improve query optimization performance using profiler extended events query stores database tuning advisor experienced trouble shooting database issues like disk issues tempdb deadlocks performance blocking issues involved designing configuring monitoring troubleshooting replication methodologies log shipping mirroring critical databases quickly resolving issues work extensively transformations lookup joiner aggregator filter update strategy sequence generator create several mappings work developers dbas systems support personnel elevating automating successful code production scheduled reports run daily weekly basis report manager maintained referential domain column integrity using available options constrance constraints involved daytoday activities agent jobs backups recovery services index database growth health consistency check data maintenance partitioning archiving purging issue issue problem maintenance management incident management security maintenance maintenance etc designed implemented tsql queries reporting complex solution development created scripts processes data integration maintenance modified existing databases meet unique needs goals determined initial evaluation planning process performed backup using backup compression data compression sql server 2008r2 clustered environment involved scheduling reports run daily weekly basis report manager southwest airlines database admistrator city state 112014 092017 installation configuration apply service packs hot fixes upgrade databases sql server2000 2008r2 line application requirements version support experienced database migration migrated databases ms sql server2008 ms sql server 2012 installed configured sql server reporting services ssrs maintenance reporting servers maintaining integrity performance databases make sure data stored securely roptimally responsible ms sql server 20002005 2008 upgrades servers designed implemented logical physical database design upon requirement along patching critical servers instances experienced creating ssis packages using proper control data flow elements maintained referential domain column integrity using available options constraints involved designing configuring monitoring troubleshooting replication methodologies log shipping mirroring critical databases quickly resolving issues performed backup using backup compression data compression ms sql server 2008r2 clustered environment tsql programming create maintain fine tune ad hoc sql stored procudfviews trigger create etl ssis packages migrate data oltp systems throughout organization centralized data warehouse gather requirements clients developed reports dashboards using power experienced trouble shooting database issues like disk issues tempdb deadlocks performance blocking issues used dbcc utilities maintain consistency integrity database production server additional information experience powershell scripting present company azurecloud presnet company configure install always presnet company sql patches presnet company working sox related database presnet company mentoring lowerlevel dba presnet company