jessica claire 9 resumesampleexamplecom 555 4321000 montgomery street san francisco ca 94105 professional summary microsoft certified sql server dba handson professional experience sql server database administrator dba 5 years progressive professional working experience sql server dba aspects sql server databases 2000 2005 2008 professional working experience managing large databases sin processing environment including backuprecovery performance tuning developing managing reports using sql reporting services ssrs monitoring performance tuning stored procedures triggers functions constraints views etc working experience entails strong knowledge using database third party tools erwin toad data modeler backuprecovery strong knowledge working experience database backup disaster recovery experienced pointintime recovery restored database backup used dbcc check database conditions rebuilding indexes database maintenance purposes well strong working experience creating modifying tables index clusternoncluster constraints uniquecheck views developed different maintenance plans database monitoring monitor server activity solving problem needed core qualifications database admin sql server 200820052000 ms access 2003 2000 database migration sql server 2000 2005 2008r2 oracle microsoft sql server operating system windows server 200820032000 windows xpnt40 msdos vmware vmware programming sql sql join store procedures trigger functions etl tools ssisdts database reporting tool ssrs sql server reporting services crystal report data modeling ssdd sql server database diagram toad sql tools query analyzer profiler query execution plan counter performance monitoring tool profiler execution plan perfmon databasetuning perimor adviser dmv activity monitor networking active directory tcpip hardwarestorage san raid nas 5 years sql server dba professional experience production test development environment installed configured maintained ms sql server 2000 2005 2008 standalone clustered servers activeactive activepassive cluster design applied sp service packs hot fixes performed upgrade sql server 2000 2005 2008 experienced using configuration tools sql server configuration manager sql server surface area configuration managed security used data modeling tool using data modeler toad forward backward enginee engineering experienced database backup recovery disaster recovery procedures worked database high availability solutions worked linked remote servers run queries sql servers data sources using odbc ole db drivers database monitoring performance tuning experienced online indexing query optimization performance tuning database consistency checks using dbcc commands configured maintained sql server reporting services ssrs ssrs experienced creating scheduling ssisdts packages sql server transfer data various dbms files good experience debugging sql server stored procedures oors docum triggers documenting issuesresolution issuesresolutions sql server applications experienced creating alerts schema management database reorganization data loading database maintenance optimization selfmotivated proactive team player able manage projects efficiently ontime delivery education university putra malaysia 2007 bachelor science computer science mcitp microsoft certified professional microsoft certified technology specialist microsoft sql server 2008 implementation maintenance professional experience cox communication microsoft sql server database administrator 022009 current accomplishments responsibilities installed configured managed sql server 2008 r2 2005 2000 development test production environment installed configured sql server 2012 testing different features stability database high availability installed configured maintained failover clustering using sql server 20082005 installed configured maintained database mirroring using automatic failover option sql server 200 server 2008 configured log shipping standby database production database reporting purposes configured maintained replications transactional report development installed configured administered sql server reporting services ssrs developed reports using ssrs deployed reports developed adhoc reports using report builder 30 20 database upgraded development testing production environment sql server 2000 20052008 2005 sql server 2005 sql server 2008 database migrated development testing production environment ms access 2003200097 databases ms sql server 2000 2005 2008 oracle 10g databases sql server 2008 datal mysql 410501 databases sql server 2005 2008 data modeling worked data modeling projects generated er diagram data modeling tools used using toad data modeler sql server data diagram backward forward engineering data modeling tools mentioned patch management applied sp service pack sql server 2000 2005 2008 applied hot fixes sql server 2000 2005 2008 patch windows server 2003 enterprise edition applied patch database monitoringperformance tuning utabase 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 database programming writing tsql trigger storedprocedures assisted database developers optimize sql queries stored procedures disssis 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 backuprecovery strong knowledge working experience database backup disaster recovery experienced pointintime recovery restored database backup used dbcc check database conditions rebuilding indexes database maintenance well purposes strong working experience creating modifying tables index clusternoncluster constraints uniquecheck views developed different maintenance plans database monitoring monitor server activity solving problem needed ibm microsoft sql server database administrator city state 042008 2009 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 pointintime recovery restored database backup database high availability installed configured maintained database mirroring including automatic failover option sql server 2008 server 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 mainte 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 plied patch windows server 2003 2003 r2 database monitoringperformance tuning database monitoring performance tuning strong scheduled jobs automate different activities monitoring database health disk space job alert index monitoring stats monitoring etc database programming tsql trigger storedprocedures assisted database developers optimize sql queries stored procedures dtsssis 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 golden livinghospital health care industry microsoft sql server database administrator city state 072007 042008 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 ssrs deployed deployed reports database upgraded development testing production environment developed reports using ssrs developed adhoc reports using report builder 30 20 sql server 2000 2005 database migrated development testing production environment ms access 2003200097 databases ms sql server 2000 2005 mysql 410501 databases sql server 2005 2009 worked 10 data modeling projects generated er diagram data modeling tools used using erwin visio toad data modeler 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 database monitoring performance tuning strong scheduled jobs automate different database related activities including backup monitoring database health disk space backup verification monitor sql server error log space usage wrote sqltsql 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 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 used dbcc check database conditions rebuilding indexes database maintenance purposes well strong working experience creating modifying tables index clusternoncluster constraints uniquecheck views developed different maintenance plans database monitoring monitor server activity solving problem needed