professional summary jessica claire 100 montgomery st 10th floor 555 4321000 resumesampleexamplecom passionate microsoft sql server database administrator 4 years practical experience solving performance problems query tuning optimization strong working knowledge versions sql server back 2008 r2 experience managing large enterprise level databases 1 tb mission critical environment experience capacity planning performing routine health checks assessments indepth product reviews product upgrade migration assessments systems performance reviews post operational review product implementations experience working closely programmersdevelopers provide optimum business solutions resultoriented team player strong analytical effective learning skills excellent communication skills also selfstarter versatile database technologies across multiple platforms keeps current technology skills database administration database design modeling sql server tsqlscripting backup disaster recovery solution bcp ssisetl processes data integrity security capacity planning communication documentation skills infrastructureteam support sql server monitoring performance tuning troubleshooting encryption management work history senior sql server database admin engineer contractor 042021 current high quality care nursing laurel md lead role efforts involve multiterabyte data managementmigrations create support ha tier 1 production servers using alwayson availability groups replication excellent backend skills creating sql objects like tablesstored proceduresviewsindexes constraints user defined data types responsible monitoring customer facing databases ensuring 24x7x365 uptime within internal sla 9999 call responsibility troubleshoot performance anomalies respond high priority issues developed oracle database backups recovery strategies created high availability processes using windows clustering database replication technologies recommending implementing data security creating users assigning permissions based minimum level database access user would need tools like always encrypted transparent data encryption tde dynamic data masking ddm secure clients sensitive data performed administrative activities like database maintenance indexing large databases database tuning query optimization database backup recovery developed automated daily weekly monthly system maintenance tasks database backup database integrity verification indexing develop managed slas including rto rpo server instances 50 perform patching database upgrades migration multiple versions sql server ensure instances date latest security fixes microsoft implementation sql logins roles authentication modes part security policies various categories users creating users assigning permissions based minimum level database access provide 24x7 support critical production database systems managed identification protection use data assets planned installed upgrades database management system software enhance database performance gathered defined refined requirements led project design oversaw implementation developed database architectural strategies modeling design implementation stages address business industry requirements collaborated system architects design analysts others understand business industry requirements communicate corporate customers via telephone written correspondence electronic service regarding problems identified microsoft sql server software provided microsoft sql server performance monitoring establish baselines adjust resources andor database settings achieve higher performance installed configured microsoft sql server instances high availability disaster recovery remote locations provide daytoday maintenance administration microsoft sql server databases supporting clientfacing backoffice production applications performed daily dba management tasks including troubleshooting performance tuning database monitoring backup recovery supervised daily dba operations implemented infrastructure processes support 500 databases across enterprise sql server database administratoranalyst 012019 042021 evangel christian child care beltsville md troubleshooting performance tuning standalone clustered environments managed sql server databases multiple product lifecycle environments development missioncritical production systems review scripts submitted development team working team like system analyst developers business analyst project teams perform capacity planning required create maintain databases installed multiple versions sql server performed regular updates applied services packs contributed disaster recovery business continuity plans exercises worked assisted software application development groups provide database setup regularly refreshed lower environments configuration optimization modification support assisted development efficiency improvements implementation database policies procedures data security integrity leveraging uses inbuilt software ssms sql server profiler performance monitor extended events dmvs database integrity checks ensure database integrity stability system availability thirdparty software like idera solarwinds database performance analyzer monitor system health security 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 managed workload independently collaborated colleagues complete larger scale tasks distributed team environment managed systems infrastructures defining hardware requirements planning storage capacity projects implement targeted scheduled healthcheck reporting windows serverlevel provide additional monitoring sql server availability installed administered 3node activeactivepassive cluster microsoft windows server 2012 handed aspects upgrading sql server 2005 sql server 2008 r2 microsoft windows server 2008 r2 enterprise edition installed configured administered ms sql server windows servers updated hot fixes latest service packs migrated sql server 2008 sql server 2012 microsoft windows server 2012 enterprise edition windows 2008r2 sp2 enterprise editions created custom tsql stored procedures triggers improve performance preserve referential integrity provide additional application functionality developed different applications using tsql analysed functional requirements developed software programs specifications developed tsql stored procedures maintaining data existing systems newly developed applications supported development effort providing tsql statement tuning optimising data loading processes performed tsql data modifications resolve issues performed customer account maintenance provided mentoring lessexperienced dba application support team members handled primary dba roles responsibility multiple applications sql server database administratoretl developer 112017 012019 kba academy beltsville md implemented troubleshooting sql server performance issues using sql server profiler trace index tuning wizard database engine tuning advisor dta monitored database performance implement changes apply new patches versions required performed tests evaluations regularly ensure data security privacy integrity provided proactive reactive data management support training users provided technical support troubleshooting assistance application development teams thirdparty software providers utilizing sql server platform implemented support administration tasks backup recovery procedures database utilities database log shipping technologies prod nonprod environments provided 24x7 support critical production database systems administered supported monitored databases proactively resolving database issues maintaining servers tested programs databases identify issues make necessary modifications created optimal technical solutions user needs research indepth system analysis implemented high availability disaster recovery database mirroring clustering production servers configured maintained backup restore strategies production server development servers per requirement monitored audited enterprise data management activities including operational monitoring daily etl monitoring report distribution performance tuning involved business analysis technical design sessions business technical staff develop requirements document etl design specifications developed technical infrastructure designs project documentation database objects data mappings related etl procedures implement additional etl processes would benefit data generation configuration inventory management identified implemented solution correct system design limitations overnight reporting etl batch process sql server database administratorspecialist 012016 112017 kebetkache women development port port harcourt nigeria ensured database backups routinely captured stored accordance retention policy ensured backup recovery plans identified agreed upon technical support group documented completely accurately accordance company procedure provided expert database administration support sql server 2008r2 implemented support administration tasks monitoring collecting database utilities baseline production test dev environments managed job activity schedules promote optimal performance maximum availability minimize data latency data load durations performed threshold forecasting sizing capacity planning trend analysis performed sql server installations database migrations deployments upgrades routinely applied sql server patches performed routine database tuning index optimization implanted backup recovery plans provided 24x7 support critical production database systems configured managed high availability disaster recovery solutions always replication clustering critical production servers worked database administration production servers server configuration performance tuning maintenance outstanding troubleshooting capabilities coordinated physical changes current space utilization performance monitoring two replicated production servers two development servers education bachelor arts communications technology 102015 university benin nigeria certifications microsoft certified solutions associate mcsa 20122014 certified 2021