jessica claire montgomery street san francisco ca 94105 555 4321000 resumesampleexamplecom professional overview microsoft certified sql server database administrator dba five years progressive professional working experience aspects sql server databases 2000 2005 2008 200812 2012 including installation configurations database high availability solutions mirroring log shipping replication failover cluster proven ability managing large databases 247 processing environment including backuprecovery performance tuning developing managing reports using sql reporting services ssrs creating ssis packages monitoring performance tuning stored procedures triggers functions constraints views etc prior experience database third party tools erwin toad data modeler strong knowledge database backup disaster recovery pointintime recovery backup database restoration proficient using dbcc check database conditions rebuilding indexes perform database maintenance functions additional proficiency creating modifying tables indexes clusternoncluster constraints uniquecheck views well developing maintenance plans monitoring server activity resolving troubleshooting questions needed qualifications database sql server 20122008r2200820052000 ms access 2003 2000 experience production test development environments proficiency following sql tools query analyzer profiler query execution plan installation configuration maintenance ms sql server 2000 counter reports developmentmanagement ssrs sql server reporting services ms access excel data modeling toad data modeler erwin ssdd sql server database diagram 2005 2008 2012 standalone clustered servers activeactive activepassive cluster design applied sp service packs hot fixes upgrades sql server 2000 2005 2008 2012 configuration tools sql server configuration manager programming sql tsql join store procedures trigger sql server surface area configuration functions security management operating system windows server 20122008r2 2003r2 data modeling tools data modeler toad 2000 vware hardwarestorage san raid performance monitoring tool profiler execution plan perfmon database tuning advisor dmv activity monitor forward backward engineering database backup recovery disaster recovery procedures database high availability solutions linked remote servers run queries sql servers data sources using odbc ole db drivers database monitoring performance tuning online indexing query optimization database consistency checks using dbcc commands sql server reporting services ssrs creating scheduling ssisdts packages sql server transfer data various dbms files ability debug sql server stored procedures triggers ability create perform alerts schema management database reorganization data loading database maintenance optimization professional experience sql dbadatabase administrator 072011 current citi group city state installs configures manages sql server 2005 2000 development test production environments installs configures sql server 2008 testing different features stability backuprecovery performs database backup disaster recovery using pointintime restoration performs database high availability installs configures maintains database mirroring including automatic failover option sql server 2008 configures log shipping standby database production database reporting purposes performs clustering using sql server 20082005 configures maintains replication uses dbcc check database conditions fix database corruption rebuild indexes database maintenance functions development installs configures administers sql server reporting services ssrs developed reports different purposes like dba reports user reports using ssrs report builder 30 well deploying reports managing security report server exporting importing data flat file csv file tofrom sql server database using dts ssis exporting importing data fromto databases like oracle mysql access tofrom sql performing server database upgrades like sql server 2000 200520082008 r2 sql server 2005 sql server 20082008 r2 performs database migration like ms access 9720002003 databases ms sql server 2000 2005 2008 oracle databases sql server 2008 r2 mysql databases sql server 20052008 r2 conducts data modeling conceptual logical physical data models works data modeling projects start finish includes generating scripts objects developing relationships tables creating er diagrams performs backward forward engineering logical physical data models respectively utilization tools erwin ssd creation management objects schemas indexes constraints application sp service pack sql server 2000 2005 2008 2008 r2 application patch windows server 2003 2003 r2 conducts database monitoringperformance tuningscheduled jobs automate different activities monitoring database health disk space job alert index monitoring etc assists database developers optimize sql queries stored procedures tsql triggers work environment includes windows server 2008 r2 2003 r2 iis 75 65 sql server 2008 r2 2005 aspnet php ad active directory sql dbadatabase administrato 022008 072011 ibm city state responsibilities installed configured managed sql server 2008 2005 2000 development test production environment installed configured sql server 2008 testing different features stability backuprecovery strong knowledge working experience database backup disaster recovery experienced pointin time recovery restored database backup database high availability installed configured maintained database mirroring including automatic failover option sql server 2008 configured log shipping standby database production database reporting purposes maintained failover clustering using sql server 20082005 configured maintained replications dbcc used dbcc check database conditions fix database corruption rebuild indexes database maintenance purposes well report development installed configured administered sql server reporting services ssrs developed reports different purposes like dba reports user reports using ssrs report builder 30 20 deployed reports managed security report server including folder level database upgrade sql server 2000 200520082008 r2 sql server 2005 sql server 20082008 r2 database migration ms access 2003200097 databases ms sql server 2000 2005 2008 oracle 10gr211gr2 databases sql server 2008 r2 mysql 4105015 databases sql server 2005 2008 r2 data modeling worked data modeling projects generated scripts er diagram backward forward engineering logical physical model respectively data modeling tools used using erwin toad data modeler created managed indexes constraints patch management applied sp service pack sql server 2000 2005 2008 2008 r2 applied patch windows server 2003 2003 r2 microsoft sql server database administrator 052007 012008 golden living hospital health care industry city state installed configured managed sql server 2005 2000 development test production environment installed configured sql server 2008 testing different features stability installed configured maintained failover clustering using sql server 2005 installed configured maintained database mirroring using automatic failover option sql server 2005 configured log shipping standby database production database reporting purposes configured maintained replications transactional installed configured administered sql server reporting services ssrsdeveloped reports using ssrs developed adhoc reports using report builder 30 20 upgraded database development testing production environment sql server 2000 2005 migrated database development testing production environment ms access 2003200097 databases ms sql server 2000 2005 mysql 410501 databases sql server 2005 worked 10 data modeling projects generated er diagram data modeling tools used using erwin sql server data diagram backward forward engineering data modeling tools mentioned applied sp service pack sql server 2000 2005 applied hot fixes sql server 2000 2005 applied patch windows server 2003 enterprise edition strong database monitoring performance tuning scheduled jobs automate different database related activities including backup monitoring database health disk space backup verification monitor sql server error log space usage wrote tsql trigger storedprocedures assisted database developers optimize sql queries stored procedures export import data flat file csv file tofrom sql server database using dts ssis bcp export import data fromto databases like oracle mysql access tofrom sql server strong knowledge working experience database backup disaster recovery experienced pointintime recovery restored database backup education training bachelor computer science computer science 2006 kabul university kabul microsoft certified professional 2012 microsoft certified technology specialist microsoft sql server 2008r2 implementation maintenance skills active directory automation backup clustering hardware data modeling dts database administration disaster recoveryiis iis 75 access ms access ms access 2000 microsoft office windows operating systems 2000 2003 2008 2008r2 2012 windows xp vista 7 8 migration optimization tsql raid san upgrade web applications web server additional information citizenship us citizen