jessica claire montgomery street san francisco ca 94105 555 4321000 resumesampleexamplecom professional summary skills professional summary clientfocused database administrator 8 years proactively working toward achieving high client satisfaction professional l much committed maintain cutting edge technical skills uptodate industry knowledge deadlinefocused broad skill range including database design development support ms sql server 201920172016201420122008r2 production nonproduction uat test development cluster server environments strong skill set database administration using windows platform always eager acquire knowledge share colleagues also experience azure much committed maintain cutting edge technical skills part multiple professional groups uptodate industry knowledge participate blogging like pass sql saturday etc sql server databases 201920172016 2014 2012 2008r2 administering installation configuration upgrading migrating patching performance tuning backup recovery high availability disaster recovery technologies microsoft sql server azure plsql tsql net problem management database administration linux operating system performance turning trouble shooting excellent work ethic scripting sql tfs work history sql server database administrator 062018 current netsmart san jose ca designed implemented tsql queries reporting complex solution development maintained complex tsql queries views stored procedures multidatabase environment little supervision produced highstandard database solutions meet stability reliability performance metrics developed custom database objects stored procedures delivered application support created optimal technical solutions user needs research indepth system analysis followed standard practices migrating changes test production environments provided technology support meet business requirements created implemented database designs data models planned implemented security measures safeguard vital business data sco server dba manager nbc universal washington dc installation maintenance sql server 2017201620142012 test 022016 052018 development production environments standalone clustered servers administration maintenance 150 sql server instances hosting 600 databases devuatproddr environments installed patchedupgradedmigrated sql server 2005 2008r2 sql server 2012 2014 multiple devuatproddr servers strong experience working large databases vldb 50 tb oltp strong experience supporting maintaining sql server 20122014 two nodes cluster activepassive activeactive architecture worked closely development team database performance tuning code reviews provided vital inputs terms index optimization schema structures data changes work team 6 dbas designing implementing new sql server 2017 concepts like always availability groups hadr use secondary replica offload critical application read onlyreporting workload hence improving performance primary replica production databases supported daily database task like creating logins users fixed orphan user issues creating new databases disk space check consistency checks looking slowlong running queries hung jobs resolving end users database issues tickets experience designing implementing sql server backup recovery solutions full differential translog backups using sql server native tools also using third party tools backup like veaam sql lite experience implementing maintaining sql server hadr technologies like log shipping mirroring always fci troubleshooting related configurations issues implemented disaster recovery planning testing analyzing continuous update documentation involves change review meetings review analyze effect changes made critical production databases worked upgrading cloning migrating sql databases sql server fog lite sql lite speed nagios jira service desk idera diagnostic expertise experience installing new instances sql server 2008 r2 2012 2014 microsoft windows server2012 r2 following best practices monitored administered sql instances standalone servers cluster environment highly experience handling vldb ranging 500gb 3t different vms added total 50t uatdev prod environments installed administered 2 node cluster microsoft windows server 2012 r2 enterprise edition san storage strong experience database optimization tuning backuprestore troubleshooting data importexport expertise designing implementing processes standards database systems recovery backup checks updated database systems reviewing planning testing installing database security patches service packs expertise troubleshooting sql server agent jobs error logs windows logs resolve failure job component extensive experience monitoring making recommendations performance improvement hosted databases involved index creation index rebuilt index reorg experience cloud databases synapse sco server dba winwire city state installation administration maintenance sql server instances installing sql server setup test dev staging production environments 032013 112015 installing sql server create users assign permissions based level database access user would need security create linked servers sql servers databases oracle access informix security general administration design database backup restoration strategy database backups sql server agent create linked servers sql servers databases oracle access informix design database backup restoration strategy create database backups monitor backups performed regularly time time recover databases specific point time per requests setup highavailability part disaster recovery strategy databases troubleshoot various problems arise daytoday work fix issues monitoring performance tuning physical server level database level database settings options query tuning dts experience using bcp exported imported data data sources like flat files using import export dts ssis responsible monitoring making recommendations performance improvement hosted databases involved index creation index removal index modification file group modifications adding scheduled jobs reindex update statistics databases involved optimization performance tuning sql server using sql profiler performance monitor extended events dmvs activity monitor resource monitor thirdparty tools experience troubleshooting resolving application blocking locking deadlock issues using sp who2 sp active experience detaching attaching cloning sql server database database server dev test developer test codes experience setting sql server jobs monitoring notifications alerts database mail make sure jobs run successfully revert back sql server errors windows event find root cause failed jobs experience administering onpram databases oracle expertise installing configuring sql server reporting services ssrs design develop different reports performance metrics checking database health using dbcc commands dmvs experience cloud databases synapse redshift snowflake big query performed database integrity checks updated database statistics performed reindexing created managed schema objects tables views clusters indexes procedures triggers maintained referential integrity implementation sql logins roles authentication modes part security policies ensure backup recoverability enterprise sql server databases using native sql veaam sql lite backups created databases azure sql server paas iaas setup migrated databases onpremises datacenter azure using different techniques like azure data sync azure database copy bacpac files bcp import export experience writing editing tsql scripts database backup jobs dailyweekly jobs automated process work server infrastructure implemented capacity planning different server database servers revamped company website via deploying responsive design facilitate mobile user increase migrate sql databases data sources relational cloudbased azure platform paas performed data partitioning efficient management database tables indexes maintaining database consistency dbcc regular intervals monitored modified performance using execution plans index tuning working clientserver tools like sql server enterprise manager query analyzer administer sql server experience applying service packs database os level experienced working agile environment using jira also working company security governance team keep cooperated databases sox iso27001 hippa compliance support database disaster recovery efforts coordinate application owners ensure database recovery supports recovery times stipulated contingency plans managed specific systems technical analysis code review implementation 24 x 7production support used tfs source control managing development via tasksbugs design configures modify enhance applications necessary biweekly oncall support production environment handling designing advertisement jobs real estate retails shop fields handling us based project designing advertisement using html xml tag offline project handling xml ebook projects styling tag edit qc handling data processing projects environment sql server 201920172016201201420122008r2 windows 2008 2008 r2 2012 servers azure adonet red gate ms visio microsoft sql server visual studio 20052008 tsql ms business intelligence development studio 2008 big query redshift snowflake native ssms tools experienced work coordination different teams like network team windows admins storage admins application teams well stakeholders customers experienced high availability solution always cluster mirroring log shipping experienced rewriting restructuring store procedures views tsql expertise writing technical reports management production support provided 24x7 production support sql server databases clustered servers sizes ranging 1 2 terabytes achieve maximum performance uptime production environment asana 2008r2 tsql ssis asana redgate lite speed sql profiler performance monitor bcp log shipping mirroring clustering windows server 2012r2 net framework cnet javascript ms tfs msaccess sharepoint 2010 oracle 10g iis 6575 80 solarwinds pal tool education bachelors degree information science university lagos lagos gu 112007