jessica claire 100 montgomery st 10th floor 555 4321000 resumesampleexamplecom summary senior database administrator 7 years experience strong team worker experience working team members developers thirdparty service providers successfully complete technical duties professionalism passion solid working experience managing large databases backuprecovery configuring managing hadr solutions database security performance tuning data migration ssis ssrs working experience entails strong knowledge using sql server database inbuilt well third party tools enhance performance environment strong business technical vision effective people skills ability manage multiple complex projects innovative creative problem solver results oriented aptitude learning maximize resources possessing sense urgency ability work minimal supervision fastchanging environment bilingual english french skills windows 8 10 ms sql server 201920172016 2014 2012 2008 ms products outlook excel access visio ms project management sql server management studio mssms sql ttransact database tuning advisor query analyzer sql profiler extend event activity monitor etl tools ssis data transformation services bulk copy program importexport data solarwinds redgate sentry one database performance analyzer sql server sdlc agile jira servicenow availability log shipping traditional failover clustering always replication hyperv vms tsql databases activity monitor sql profile task manager event viewer window performance monitor ssms configuration manager transparent data encryption tde dynamic data masking ddm always encrypted high experience ms sql database administrator 022017 current 022017 current smartronix city state responsible network infrastructure upgrade project around 4 billion dollars collected documented project requirements got approval directors project execution collaborated team members thirdparty providers project implementation cut activities installed configured sql server servers applied level security fixes performed sql server post configuration upgraded related applications maintained 80 production servers different domains 55 dev test servers configured high availability solution alwayson availability group database mirroring log shipping clustering created maintained provided documentation current configurations changes designed created migrated databases different instances servers refresh databases per business needs installed tested maintained changes database management systems accordance approved change management process used ttransact gui perform ddl dml dql dcl operations performed troubleshooting using rca root cause analysis problems managed production development test database environments configured maintain ssrs ssis ssas instances provided support improve database monitoring performance reporting collaborated team members resolved tickets slow running queries created maintained indexes speed data retrieval resolve performance designed implemented disaster recovery plan aligned companys sla rpo rto requirements experienced using normalization oltp denormalization olap resolve database performance issues deployed databases onprem azure using different methods like backup restore replication database migration assistant dma monitored proactively managed disk space usage capacity planning knowledgeable troubleshooting slow running queries concurrency dead locks analyzed produced resource trends reports recommended appropriate solutions meet resource requirements produced distributed database performance reports periodically archives reviewed analyzed system logs proactively set preventive actions ensured databases adhere corporate standards policies including database auditing used data encryption technologies like transparent data encryption always encrypted data security provided production level support onsite call 247 environment internship student help desk technician 022016 012022 072022 orange telecom city state planned developed frequently windows sql server patches creating modifying tables stored procedures views indexes userdefined functions triggers required sql server environments involved planning setup implementation new servers across entire enterprise involved ensuring data recovery maintenance data integrity space requirements physical database planning implementation database backuprestore disaster recovery system monitoring production level support onsite offshore clients troubleshooting client connectivity lock resolution performance baselining sql server performance dashboard reports monitoring manage indexes improve performance schedule automate jobs indexes backups using sql agent improve performance availability develop routine jobs data integrity check creating managing database objects including tables views stored procedures etc managing server database security identity 917 pm 9212022 eric internship student help desk technician 022016 072017 mtn communications yaound cameroon involved ensuring data recovery maintenance data integrity space requirements physical database creating modifying tables stored procedures views indexes userdefined functions triggers etc requirement sql server environments involved planning setup implementation new servers across entire enterprise planned deployed monthly windows sql server patches planning implementation database backuprestore disaster recovery troubleshooting client connectivity lock resolution performance baselining sql server performance dashboard reports monitoring manage indexes improve performance schedule jobs using sql server agent developed routine jobs data integrity check code deployment production tables design views stored procedures function etc managing server database security identity task automation indexes maintenance sql server profiler extended events query store database engine tuning advisor dta performance stable replication topology installed sql server 2008 advanced servers applied security fixes sql server upgrade place side side upgrade older newer versions sql2008 2012 2014 2016 database migration different versions sql server 2008 201220142016 installed configured ms sql server 2012 supported production development servers maintained database response times 24x7 production environments junior database administrator 032022 042022 magellan health city state planned developed frequently windows sql server patches creating modifying tables stored procedures views indexes userdefined functions triggers required sql server environments involved planning setup implementation new servers across entire enterprise involved ensuring data recovery maintenance data integrity space requirements physical database planning implementation database backuprestore disaster recovery system monitoring production level support onsite offshore clients troubleshooting client connectivity lock resolution performance baselining sql server performance dashboard reports monitoring manage indexes improve performance schedule automate jobs indexes backups using sql agent improve performance availability develop routine jobs data integrity check creating managing database objects including tables views stored procedures etc managing server database security identity database administrator 05201022017 012022 032022 american airlines city state involved ensuring data recovery maintenance data integrity space requirements physical database creating modifying tables stored procedures views indexes userdefined functions triggers etc requirement sql server environments involved planning setup implementation new servers across entire enterprise planned deployed monthly windows sql server patches planning implementation database backuprestore disaster recovery production level support onsite offshore clients system monitoring troubleshooting client connectivity lock resolution performance baselining sql server performance dashboard reports monitoring manage indexes improve performance managing server database security identity developed routine jobs data integrity check tables design views stored procedures function etc schedule automate jobs indexes backups using sql agent education training bachelor science computer information sciences 062015 university buea buea cameroon bachelor science accounting business management lamar university beaumont tx english negotiated languages french negotiated