jessica claire sql server database administrator 100 montgomery st 10th floor 555 4321000 resumesampleexamplecom professional summary result oriented database administrator 8 years experience proven knowledge backoffice operations confidential correspondence data entry aiming leverage skills successfully fill sql server database administrator role company database professional 7 years experience managing critical databases prem cloud azure substantial expertise performance tuning maintenance high availability disaster recovery hadr strategies hands experience setting troubleshooting always clustering database mirroring log shipping including replication snapshot transactional merge peer peer database backup restorerecovery query optimization security sql server installation configuration standalone clustered environments migrationupgrade applying service packs routineemergency dba operations like database health check index optimization updating statistics clientserver connectivity capacity planning responsible securing sql server user management assigning permissions roles using query store extended events database engine tuning advisor dta sql profiler scripts thirdparty tools resolve bottlenecks deadlocks slow running queries database security configuring dynamic data masking experienced active directory ad objects user permissions skills sql server versions sql server 2012 2014 2016 2017 2019 sql server tools sql server management studio sql profiler performance monitor sqlcmd database tuning wizard sql server upgrade advisor dta dmvs dbcc dr configuration log shipping mirroring clustering transactional replications data integration work history 032019 current operating systems windows server 2008 r2 2012 2016 ticketing tools remedy 80 essential software microsoft office word excel database support administering databases snr sql server database administrator rr donnelley sons chamblee ga developed custom database objects stored procedures delivered application support followed standard practices migrating changes test production environments provided technology support meet business requirements managing 3000 databases vldb across multiple data centers involved technical decisions business requirement interaction business analysts client team development team capacity planning upgrading sql servers migrated sql data onpremises azure sql database responsible setting maintaining high availability disaster recovery solutions largescale database migrations sql server 2008r2 sql server 2019 performed physical logical data modelling databases varied sizes including vldbs responsible providing 24x7 dba production support 180 sql server databases production clustered servers involved assisting sql server prime customers configuration administration implementation troubleshooting business workflow log shipping mechanism configured dr solution transaction replication distribution server multiple updatable subscriptions perform database refresh tasks production development staging servers perform scheduled backups restore operations create respect standards logins users groups roles jobs alerts mails confirmation upon tasks perform database consistency checks dbcc defrag index tuning monitored error logs provide oncall support mission critical environments expertise disaster recovery mechanisms resolve sql server problems conformance slas involves indepth knowledge sql server architecture connectivity replication backuprestore security continuous improvement maintain two different databases readonly reporting database disaster recovery database perform security tasks like grant revoke permissions security tasks involved auditing performing transactions database resolve issues perfmon sql profiler used netmon monitoring performing network throughput issues 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 managed workload independently collaborated colleagues complete larger scale tasks distributed team environment 062017 032019 sql server database administrator synovus bank city state ms sql server design development administration using sql server 20052017 database environments monitoring sql health checks identifying issues fixing used sql indexes improving query performance lower storage maintenance cost used optimization tools like sql profiler dynamic management views dmvs windows performance monitor monitoring tuning sql server performance implemented installation configuration upgrading sql server good experience user management maintaining databases automation administrative tasks like creating jobs schedules alerts using sql server agent monitoring troubleshooting jobs event notifications using database mail maintained server security assigning logins server database roles server permissions implemented disaster prevention recovery strategies supported high availability features like clustering always log shipping database mirroring replication maintained database response times 24x7 production environment proactively generated reports planned implemented database backuprestore disaster recovery implemented log shipping primary standby servers created maintained sql objects like tables views stored procedure constraints user defined functions used tools like sql profiler fog light red gate solarwinds sql sentry monitoring environment responsible installing maintaining ssis ssrs power bi produced highstandard database solutions meet stability reliability performance metrics 062013 052016 jnr sql server database administrator rtsi global inc city state setup troubleshoot activepassive clustering sql 2012 built useful reporting deliverables properly document analysis results provide performance improvement feedback involved controlling cocoordinating installations security patches service packs system performance predeployment production expert using dmvs performance dash board mirroring database snapshot involved assisting sql server prime customers configuration administration implementation troubleshooting business work flow log shipping mechanism setup snapshot merge transactional replication servers troubleshoot monitor publishers distributors subscribers involved installation sql server multiple instances latest sps hot fixes performed database refresh tasks production development staging servers involved auditingperforming transactions database resolve issues perfmon sql profiler performance monitor memory processor disk io finetuning disk usage cachehit ratio transaction ps fine tuned stored procedures better performance also maintaining data integrity sql server written stored procedures application developers involved solving high critical throughput mission critical problems tuned application queries generated reports development teams using statspack reports explain plan session trace giving hints parallel index tkprof etc used process explorer maintenance stuck process release handles files monitored tuned server databases using dbcc server configuration options like sp configure database option sp dboption involved creation databases writing queries monitoring execution plan tracing execution flow critical throughput environment sql server 2008 r2 windows nt20032008 bmc patrol veritas net backup education 092016 062005 post graduate diploma maritime technology university lagos lagos nigeria bachelor science applied science maritime academy nigeria akwa ibom nigeria medcerts livonia mi certifications comptia security certification comptia network certification az104 microsoft certified azure administrator associate microsoft certified azure fundamentals microsoft certified solution associate mcsa sql database administration 2016 server dp300 microsoft certified azure database administration associate