jessica claire montgomery street san francisco ca 94105 555 4321000 resumesampleexamplecom professional summary talented database administrator six years expertise extensive knowledge relational database management system including database monitoring installation configuration upgrade management high availability disaster recovery log shipping clustering alerts operators agent jobs well experienced performance tuning security proficient diverse range development languages including tsql excellent communicator advanced presentation creation delivery skills recognized consistently performance excellence contributions success financial health industry microsoft certified sql server database administrator sql server 20122014 2016 skills reporting documentation systems administration running backups relational database management work history 072018 current sql server database administrator jacobs engineering group inc skowhegan implementing security measures microsoft net framework data audits installed upgraded configured tuned sql server 20122014 2016 systems associated middleware windows environments performed deployment testing staging production servers different team worked performance enhancement running index tuning wizard creating rebuilding reorganizing indexes various tables monitored performance fine tuned stored procedures sql queries user defined functions optimize performance reliability built databases tables various database objects per business requirement following sql server database modeler er studio data architecture methodology wrote maintained technical functional specifications document database intentions requirements monitored daily backup jobs automation daily restores development databases using red gate idera native backups modified existing databases meet unique needs goals determined initial evaluation planning process worked performance enhancement running index tuning wizard creating rebuilding reorganizing indexes various tables monitored troubleshoot server performance database activities users using sql profiler performance monitor extended event trace flags activity monitors store procedures dbcc dmvs tested programs databases identify issues make necessary modifications designed implemented tsql queries reporting complex solution development monitored user accounts created groups granted necessary privileges users groups created various server databases alerts helps take actions proactively created different sql server agent jobs part database automation supported multiple concurrent projects enabling delivery efficiencies technical resolution followed standard practices migrating changes test production environments provided technology support meet business requirements 072016 062018 database admin developer centene corporation buffalo ny evaluated designed implemented modified databases database applications designed reviewed created database objects like views indexes stored procedures functions triggers based logical physical design models user requirements administered ms sql server security access control mechanisms like creating accounts roles providing privilege maintained proper security procedures dropping locking unnecessary logins authored coded logical physical database descriptions collected reviewed database performance metrics proactively address performance concerns configured monitored log shipping database mirroring disaster recovery servers evaluate cpu disk io memory related bottlenecks using performance monitor improved sql server performance rebuild clustered nonclustered indexes part performance tuning delivered complex business requirements without issues leveraging strong troubleshooting skills extensive oversight planned implemented security measures safeguard vital business data identified issues within databases performed troubleshooting implemented effective solutions created technical documentation database technologies providing updates needed coordinated project management staff database development timelines project scope 072016 072017 sql database administrator secure24 west allis wi designed implemented tsql queries reporting complex solution development developed produced highstandard database solutions meet stability reliability performance metrics participated support service level agreement sla operational performance monitoring reporting participated root cause analysis problem management activities participated coordinate project production integration led incident resolution efforts participated incident management activities engaged appropriate resources complete corrective actions enhanced performance running index tuning wizard creating rebuilding reorganizing indexes various tables set controlled user profiles access levels database segment protect important data 032014 072016 sql server database consultant epic systems inc city state participated implementing database architecture strategies defining standards database environment administered maintained developed implemented policies procedures ensuring security integrity sql server databases implemented disaster recovery strategy developing maintaining standards documentation database security audit compliance explained data results clearly discussed utilized support project objectives contributed internal activities overall process improvements efficiencies innovation respond production incidents address service level agreement sla framework undertook performance tuning optimization pto using native monitoring troubleshooting tools dmvs translated logical data models physical database designs developed physical databases addressed ad hoc analytics requests facilitated data acquisitions support internal projects special projects investigations performed oncall duties required education 062017 master arts american university washington dc 2008 certifications associate arts law alemaya universsity harar ethiopia microsoft certified sql server database administrator