jessica claire montgomery street san francisco ca 94105 555 4321000 resumesampleexamplecom summary jessica claire certified sql dbadeveloper 5 years experience database administration using ms sql server 200820122014 1 years experience using elastic search altreyx experience analysis design development implementation testing maintenance application systems internetintranet client server environments 2 years experience sql server dbaetl developer good experience installation configuration maintenance sql server experience data modeling logical physical design databases normalization building referential integrity constraints excellent backend skills creating sql objects like tables stored procedures views indexes triggers rules defaults user defined data types functions good tsql programming skills experience query optimization performance tuning used sql profiler execution plan performance monitor dbcc commands experience database backup disaster recovery procedures experience replication snapshot merge transactional good experience complete etl cycle including data analysis database design data mapping conversion data load worked oltp olap environment includes production 24x7 extensively worked activeactive activepassive clustering strong background disciplined software development life cycle sdlc process excellent analytical programming problem solving skills ability work fast paced environment good team player work independently helped database developers technical issues migration experience multiple databasesservers sql 2008r2 sql 2012 sql 2014 monitoring sql server error logs disk space growth clustering environment monitoring indexes performance related issues experience knowledge hadr like log shippingmirroringclustering replication extensive experience implementing clustering mirroring physical virtual machines experience creating roles managing user permissions jobs alerts sql mail agent using performance monitor profiler resolving deadlocks technical skills database maintenance plans scheduling alerts expert 4 backuprecovery expert 4 clustering alwayson clustering expert 4 devices databases logs design creation expert 4 updating disaster recovery 4 expert documentation policies procedures expert elasticsearch 4 intermediate 1 altreyx intermediate 1 performance tuning optimization expert 4 reporting services ssrs expert 4 ssis expert 4 sql tsql accomplishments expert 4 designed implemented elascticsearch client created data indexes using elasticsearchnosql fast accessing data implemented altryx create packages upgraded 20 sql servers latest version 3month period improved vital processing jobs reducing process duration 60 enrolled users maintained system security controlled monitored user access database operating 247 4050 concurrent users given time eliminated months production server issues systematically troubleshooting resolving problem downtime employee year 2013 cognizant technology solutions experience sql server developerdba 062016 current iron mountain denver co provides ongoing support ms sql server database servers systems include creation configuration maintenance upgrade installed configured ms sql server standalone failover cluster designed implemented sql servers migrations 2008r2 20121416 configured managed high availability disaster recovery solutions always replication clustering critical production servers configured managed always availability mirror groups replica databases upgrading existing servers service packs patches hotfixes created maintained databases users logins tables indexes stored procedures roles permissions schema objects perform database troubleshooting management backup restore routine maintenance dbcc reindex database table indexes database performance tuning managed users roles principals securable administration access databases various levels provide better security sql server windows authentication modes monitored database status including cpu memory io space dead lock using sql server utilities developed ssis ssas packages sql server using business intelligence studio created jobs schedule ssis ssas packages sql scheduler migrated ssis ssas packages development test production environments using ssis configuration files deployment wizard sql server dba 012013 052014 cognizant technologies manulife financial city state canada worked terabytes data 500 databases installed recommended service packs security patches production test development servers sql 2008r2 set database partitioning improve query performance introduced implemented features like data maintain security respectively ompression transparent data encryption reduce io utilized resource governor handle two applications server supported learned complicated replication system hundreds sybase sql servers tuning queries database performance using tools sql server tuning advisor sql server profiler perfmon best practice analyzer experience shell scripting perl power shell expertise using third party tools like db artisan commvault monitoring troubleshooting jobs backups restore database policies worked application developers design databases tables support development activities achieve optimal efficiency thorough understanding standard sops slas change control management process generating reports per requirement using ssrs 20052008 coordinated physical changes performance monitoring two replicated production servers two development servers develop ssis packages transform data excelaccess file sql server database environment sql server 20082012 windows nt20082003 advanced server tsql ssis ssrs plsql unix aix servers sql server dbadeveloper 2012 012013 cognizant technology solutions city state technologies involved application include sql server 2000 2005 replication microsoft analysis services microsoft dts etl responsible installations configurations sql server 2008 applying service packs installed configured sql server 2008 clustering services worked ssis packages using sql server 2008 worked extensively creation databases objects stored procedures triggers security dts ie import export bcp transactsql backups recovery sql server agent sql server profiler using sql server implemented high availability solutions including clustering database mirroring replication log shipping worked extensively data modeling creation new data models add existing tables data models creation new tables used replication transactional merge replication move databases sql server 2000 sql server 2005 extensively worked sharepoint projects applications terra bytes databases good knowledge experience team foundation servertfs experienced configuring implementing maintaining database mirroring extensive experience configuration implementation maintenance using log shipping transactional merge replication sql server20002005 performance tuning increase speed performance website tuning hardware software requirements sql 2008r2 set database partitioning improve query performance introduced implemented features like data backup compression transparent data encryption reduce io maintain security respectively environment sql server 20052008r2 windows nt2008r220082003 ibm lombardi bpm 75 tsql ssis ssrs etl education training master science information systems 2016 marist college poughkeepsie ny information systems 34 bachelors technology computer science 2011 jawaharlal nehru university hyderabad computer science 35 certifications microsoft certified professional mcp mcsa sql server 20122014 itil v3 foundation certified oracle certified java programmerocjp salesforce certified cloud developer