jessica claire montgomery street san francisco ca 94105 xxx 4321000 resumesampleexamplecom career overview 7 years experience database administration developer large complex databases sql server 2012 sql server 2008 r2 2008 2005 expertise database administration production servers server configuration performance tuning maintenance outstanding troubleshooting capabilities strong technical background along ability perform business analysis write effective documentation specifications expertise tsql writing stored procedures triggers functions administering sql server high availability disaster recovery strategies expert data transformation services like ssis dts bcp bulk insert implemented new sql server 2012 mechanisms like data compressions online indexing contained databases security principals aag worked logical physical data base modeling uml erwin tools experience using dmv dynamic management functions finding long running queries worked extensively clustering server consolidation troubleshooting production issues raising high availability experience disaster recovery planning security management operations proficiency expertise sql server replication backuprecovery disaster recovery planning hands experience dr processes including log shipping database mirroring worked configuring sql server minimum privileged access handled multiple sql instances cluster environment server consolidation projects built san using raid levels troubleshoot performance problems finetuning databases index analysis worked sql server 2012 migration sql server 20082005 experience 64 bit sql server 2012 sql server 2008 r2 systems mscs configurations maintained individual service accounts sql server services cluster different security groups raise security mark experience data center servers handling 14 tb databases handling memory configurations sql server 2012 sql server 2008 windows 2008 experience batch processes import export backup database monitoring tools application support created linked servers sql server 2008 r2 oracle 9i 10g also created dts package data transfer two environments working knowledge analysis servicesssas reporting services ssrs clustering experience supporting large databases vldb troubleshooting problems strong experience mentoring team members writing documentation 24 x 7 production database call support qualifications technical expertise databases ms sql server 2012 2008 ms sql server 2005 programming visual basic 6 visual basic 5 c c sql dba database administration ms sql server 20122008 2005 operating system windows 20082003 advanced server nt windows 9x linux software windows 20082003 advanced server nt windows 9x linux tools backup utility sql litespeed visio network topologies tcpip dns wins dhcp ftp snmp smtp technical skills accomplishments expertise database administration production servers server configuration performance tuning maintenance outstanding troubleshooting capabilities work experience 062009 072013 sql server dba cognizant technology solutions redmond wa responsibilities migrated sql server 2008 sql server 2012 microsoft windows server 2012 enterprise edition installed administered eightnode cluster activepassive microsoft windows server 2012 enterprise edition san environment migrated ssis packages sql server 2008 r2 ssis 2012 extensively worked sql server integration services ssis sql server reporting services ssrs expert using dmvs performance dash board mirroring database snapshots tracking performance counters rebuilding monitoring indexes regular intervals better performance recovering databases backup disasters implementing pointintime recovery solutions involved trouble shooting finetuning databases performance concurrency involved source data analysis analysis designing mappings data extraction also responsible design development ssis packages load data various databases files experience using sql server profiler sql server agent database engine tuning advisordta expert implementing snapshot isolation ddl triggers responsible monitoring making recommendations performance improvement hosted databases involved index creation index removal index modification file group modifications adding scheduled jobs reindex update statistics databases implemented data partitioning error handling trycatchthrow statement common table expression cte performed installation sql enterprise 2012 sp1 cu 5 64bit version windows 2012 sp1 clusters hp servers enterprise data centers environment sql server 20082012 enterprise windows enterprise server 2012 net microsoft visio sftp microsoft reporting services 122007 052009 sql server dba cognizant technology solutions union nj responsibilities perform business analysis technical analysis systems design application software programming prepared dfds entity relationship er diagrams restructuring stored procedure designing coding developing using sql programming transferring data etl data warehouse informatica ssis extensively worked dynamic management views sql server 2005 installed authored managed reports using sql server 2005 reporting services managed migration sql server 2000 databases sql server 2005 monitoring sql server performance using sql profiler find performance dead locks developed deployed monitored ssis packages including upgrading dts ssis performed daily tasks including backup restore using sql server 2005 tools like sql server management studio sql server profiler sql server agent database engine tuning advisor extensively worked data partitioning snapshot isolation sql server 2005 reengineering customer cognos people soft modules sql server 2005 integration services prepared project management technical documentation unit testing ssis packages respect flow performance issues solving bugs reflected testing team rebuilding indexes regular intervals better performance monitored modified performance using execution plans index tuning rebuilding indexes regular intervals better performance managing veritas net backups extensively worked dbcc commands dynamic management objects expertise sql server reporting services sql server analysis services involved trouble shooting finetuning databases performance concurrency complete documentation database recovering databases backup disasters export import data data sources like flat files using importexport dts ssis analyze long running slow queries tune optimize application system performance set sql server configuration settings better server management monitoring servers using idera third party software worked sql server tools like enterprise manager sql query analyzer environment sql server 20082005 oracle 10g91 net framework 20 cnet aspnet20 javascript vss windows 2000 windows 2003 server ms tfs msaccess 102007 122007 database administrator kipp houston public schools houston tx responsibilities database administrator database programming implementation sql logins roles authentication modes part security policies various categories users rebuilding indexes regular intervals better performance designed implemented comprehensive backup plan disaster recovery strategies implemented involved trouble shooting finetuning databases performance concurrency monitored modified performance using execution plans index tuning rebuilding indexes regular intervals better performance deploying new code base release uat production environments perform sql server service pack windows service pack upgrades working customers application rollouts server migrations extensively worked enterprise manager managing database troubleshoot performance problems finetuning databases involved index analysis performance tuning worked different upstream team downloading etl mart data converting dts packages sql server 2005 integration services migrating sql server 2000 data bases sql server 2005 recovering databases backup disasters analyze long running slow queries tune optimize application system performance environment sql server 2005 sql server 2000 windows 20032000 server sql litespeed 45 mse change request visio enterprise manager sql query analyzer sql profiler 072006 092007 midlevel database administrator icf international inc adelphi md responsibilities installing sql server minimum access privileges service account improve security attain high ratings soc audits installed configured sql server 2005 clustering microsoft clustering services mscs hardware inventory test environment involved analyzing upgrading sql server 2000 test servers sql server 2005 experience san raid levels building sql cluster servers san environments perform sql server service pack windows service pack upgrades designed implemented comprehensive backup plan using sql litespeed resolved tweaked memory pressures caused product release worked customers application rollouts server migrations troubleshoot performance problems finetuning databases expertise designing databases capacity planning rebuilding indexes regular intervals better performance designed implemented comprehensive backup plan disaster recovery strategies implemented provide 24x7 production support sql server databases clustered servers sizes ranging 1 2 terabytes achieve maximum performance uptime production environment worked extensively query analyzer profiler tuning queries using variable characteristics query costs monitored modified performance using execution plans index tuning transferring data etl data ware house sql server 2005 integration services rebuilding indexes regular intervals better performance involved trouble shooting finetuning databases performance concurrency designed implemented comprehensive backup plan disaster recovery strategies implemented scheduled replication process updating parallel servers designed created databases tables views store procedures triggers environment sql server 2005 sql server 2000 windows 20032000 server sql litespeed 45 mse vss password updater 032005 072006 junior sql server dba hartford life insurance city state responsibilities monitoring server high availability servers solving request raised user support participate implementation new releases production facilitates application deployment joint effort deployments meet sla service level agreement established daytoday administration live sql servers designed implemented security policy sql servers used stored procedures dts packages bcp updating servers designed implemented comprehensive backup plan disaster recovery strategies implemented scheduled replication process updating parallel servers automated messaging services server failures task completion success execute procedures accomplish shortterm business goals deploying administration tools like sql db access performance monitor backup utility deploying monitoring tools like sitescope spot light table partitioning improve io access enforce database security managing user privileges efficient resource management assigning profiles users using database level triggers code database consistency integrity security tested implemented procedures detect poor database performance collecting required information root cause analysis environmentsql server 200070 iis windows 20032000 server sql db access performance monitor backup utility mom mse sitescope education training bachelors electronics communication engineering university madras madras tamil nadu bachelors electronics communication engineering university madras india masters springfield computers information systems universty illinois masters computers information systems universty illinois springfieldus certifications cts cte skills database microsoft windows ms sql server sql sql server databases integration integrator net database engine microsoft sql server reporting services sql server 2008 sql server reporting services san storage area network visio sql server 2000 windows 2003 data analysis data extraction ddl file marketing analysis microsoft sql server integration services microsoft ssrs microsoft visio microsoft windows server 2012 r2 sap secure file transfer protocol sftp solutions sql server 2008 r2 sql server 2012 sql server integration services ssrs statistics windows server 2012 access analyzer etl extract transform load sql server 2005 vss disaster recovery security replication net framework 20 analysis services application software asp backups business analysis c coda coding cognos data sources data warehouse documentation ibm cognos importexport informatica javascript microsoft sql server analysis services ms net oracle oracle 10g people soft project management reengineering restructuring software programming sql server analysis services stored procedure systems design technical documentation testing unit testing veritas windows 2000 database administrator migrations application deployment bcp deployment lis internet information services root cause analysis service level agreement stored procedures audits capacity planning clustering inventory production environment raid service account soc switch capacity terabytes accounts application support backuprecovery c data center data transformation database administration dhcp disaster recovery planning dns erwin ftp linux maintenance mentoring ms sql server 2005 ms sql server 2012 operations recovery planning shipping smtp snmp tcp tcpip tsql uml visual basic vldb wins authentication performance tuning security policies uat communication engineering