jessica claire montgomery street san francisco ca 94105 555 4321000 resumesampleexamplecom professional summary seasoned ms sql server database administrator 8 years extensive experience designing scripting testing managing database solutions development production environments proficient working diverse technologies tools solarwinds dpa red gate idera sql server management studio azure data studio sql sentry sql server migration assistant etc skilled using business intelligence ssis ssrs power bi tableau data modelling reporting analysis strengths troubleshooting maintaining servers systems support smooth business operations excellent communicator advanced presentation creation delivery skills motivated stay informed latest industry innovations provide users uptodate solutions skills tsql power shell scripting skills automating repetitive tasks database servers hardware software upgrades patches high availability disaster recovery solutions design sql server database security audit compliance sql serve database monitoring performance tuning optimization etl tools power bi tableau data conversion migration relational database management ability create maintain documentation source code application installation processes technical specifications data governance program ability multitask manage multiple simultaneous high priorities ability communicate effectively levels employees management ability work independently team leader system performance business continuity maintenance azure work history 052022 current sql server database administrator contract ntt data services city state install configure maintain sql server 2016 2017 2019 versions databases infrastructure test production environments high availability disaster recovery solutions replication mirroring log shipping availability groups multisubnet cluster environment help company achieved 999 business continuity high availability projections successfully migrated 7tb databases objects premises cloud azure aws 11tb databases including objects 2012 sql server instance 2019 sql server instance using automated tools designed maintained complex tsql queries stored procedures views tables indexes functions triggers multidatabase environment high level performance increased systems database high level performance 100 implemented database security measures control access databases authentication authorization policies performed auditing database usage active users resulted eliminating vulnerabilities data theft breaches 998 implemented etl tools power bi solution framework data warehousing modeling data analysis integration reporting services resulting products massively deployed executing endtoend business intelligence projects using business intelligence tools documented analyzed business reports prompt communication follow customers support leading 97 average customer satisfaction rating assisted application development teams scripts development sql codes reviews schema refinement complex query tuning predeployment testing data integration maintenance ensuring appropriate efficient sql codes deployed production servers resulting seamless production operations excellent outputs followed standard practices migrating changes test production environments provided technology supports meet business requirements crafted implemented exceptionally effective highstandard database solutions provided application production stability reliability security highspeed performance resulted overall revenue growth 125 recommended approval implemented hardware requirements planning storage capacity best practices manage servers systems infrastructure within three months implementation resulted outstanding performance effectiveness surpassing team expectation 14 reduced servers system downtime 999 assembling deploying highly effective rdbms native utilities thirdparty automated tools like red gate fog light solarwind dpa proactively monitoring tuning optimizing system performance instant resolution database issues used critical thinking break problems evaluate solutions make decisions saved company thousands dollars manhours hardware deprecation costs automating routinerepetitive dba tasks like jobs schedules using sql server agent creating mail profile setting alerts events notifications ticketing services designed implemented strategically planned periodic needed mssql softwarehardware upgrades patching using power shell scripts automated scripts seen significant boost query optimization general database servers performance efficiency collaborated team members achieve target results provide 24x7 oncall support rotation critical production systems 012021 032022 server database administrator info sys bpm city state installed configured managed sql server 20082019 versions test production environments using automated processes virtual machine configuration vmware designed managed mirroring replication log shipping availability group multisubnet cluster environment high availability resilience reviewed refined sql codes schema tuned queries optimized indexes support database administration tasks performance tuning system health check etc executed sql server assessments including monitoring servers resources like cpu memory io disk carried performance tuning optimization using query store dynamic management views sql extended events 3rdparty troubleshooting tools resolve bottlenecks deadlocks blocking longrunning queries set automated jobs maintenance plans backups rebuilding indexes disk space check server health alert notifications developed deployed power bi ssrs report etl tools using ssis provided technical support database environments ensuring database security integrity performance availability recoverability servers databases built useful reporting deliverables properly document analysis results provide performance improvement feedback created scripts processes data integration maintenance 072014 122020 server database administrator hallmark trust investment limited city state nigeria installed tested maintained new versions database software patches associated software application changes upgrades using powershell implemented configured troubleshot database instances partitions storage access 500 databases bigger 10tb designed ssrs ssis packages generating weekly monthly quarterly reports required clients business analysis prevented important important users leaktheft saved company 615000 regulators fine data privacy noncompliance proactively performing sql server security monitoring audits necessary maintaining database security privacy protection ended system irregular behindschedule backup restore routines upgrades patching maintenance jobs systems servers monitoring automating sql server routine processes performance issues tracking documentation changes assisted developers code review troubleshooting tuning deployments activities monitored database performance ensure integrity data provide tuning database optimal performance managed database growth data purgingarchiving provided oncall support production issues occurring outside business hours education 062012 certifications bsc computer science adekunle ajasin university akungbaakoko ondo state nigeria microsoft certified solutions associate msca sql 2014 database administration microsoft certified azure fundamentals mta database certification