jessica claire 100 montgomery st 10th floor 555 4321000 resumesampleexamplecom professional summary talented database administrator 7 years diverse experience database design administration data modeling data warehousing enterprise systems architecture business intelligence bi extensive technical skills advanced understanding sql server ssis ssrs ssas administration strong collaborator team player excellent communication skills expertise analytical problem solving skills msbi tsqlsql ssis ssas sql excel ssrs tfs source version control git debugging troubleshooting strong interpersonal communication skills objectoriented programming rdms development sql sql server profiler windows performance monitor database engine tuning advisor ms visio work history sql server dbadeveloper sql developer 032020 current cognizant technology solutions chadds ford pa sql msbi ssis ssrs faa developed tsql scripts create database objects perform dml ddl tasks created databases tables indexes stored procedures views database management policies constraints defaults rules functions triggers cursors dynamic sql queries performance tuning analyzing execution plans creating maintaining indexes rebuildreorganize statistics partitions client server connectivity structure modification analyzing locks blocks dead locks resource utilization handling isolation level concurrency issues analyze deploy scripts packages prodtest environments different developers built deployed ssis packages tsql scripts transformation source data loaded transformed data mart layer tuned performance ssis packages using row transformation block unblock transformation implemented etl packages ssis extract data various sources like oracle file system sql server json file transformed extracted data using ssis task sql stored procedure denormalized form ssas cube ssrs report built top denormalized tables expert deploying ssis packages package deployment model project deployment model debugging failures develop tablix drill drill reports using sql server reporting services ssrs managed 40 team calls per day available 247 technical skills sql ssis ssrs dba tfs sql server dbadeveloper sql developer 032020 122020 higher education services corporation hesc city state dba db2 msbi ssis ssrs developer hesc designed implemented maintained database schema entity relationship diagrams tables constraints indexes created relational dimensional data modeling using er diagram responsible database backup recovery system user databases created users roles managed security permission database created database maintenance plan performance sql server covered database integrity checks update database statistics reindexing provided high availability clustering activepassive mirroring log shipping replication transactional always increased query performance monitoring tuning optimizing indexes using sql server profiler database engine tuning advisor involved collecting business requirements users translated technical specs design docs development designed created various database objects tables functions stored procedures triggers jobs per business requirements enforced business rules filtered bad data system using complex tsql statement implemented various constraints triggers data consistency created deployed etl packages different data sources sql server flat files excel source files xml files etc loaded data destination tables performing different kinds transformations using ssisdts packages involved configuration report server create role security grant permissions different level users sql server reporting services ssrs get best performance ssrs reports applied performance tuning various sql procedures created proper indexes tables support db2 developer using zos backup restore database run script technical skills sql ssis ssrs dba tfs sql server dbadeveloper 072016 022020 kraftheinz inc city state dev dba msbi ssis ssrs developer kraft heinz inc interacted data modelers business analysts onsite team understand requirements impact etl business analyzed requirements designed technical documents 50 members agile scrum team participated daily standup meetings project standup meetings iteration reviews interacted appropriate team followed client process hosting deployment work extract transform load source data respective target tables build required data marts understand user requirements data model defined developed business analysts data architects enhancing deploying ssis packages development server production server created businesscrucial stored procedures staging tables support efficient data storage manipulation filtered data transient stage data warehouse system using complex tsql statements execute sql query task transformations implemented various constraints triggers data consistency preserve data integrity used loop container sequence container script task expressions execute sql task package execution task achieve business needs worked tsql scripts dynamic sql complex stored procedures functions triggers build ssrs report warehouse per need business deploy report server technical skills msbi tsqlsql ssis ssas sql excel ssrs tfs sql server dba 032014 052016 pfizer inc city state sql dev msbi ssis ssrs developer pfizer inc ssis used transformations like slowly changing dimension derived column conditional split aggregate lookup sort merge join union merge data conversion load data target destinations implementation data extraction transformation loading etl processes creating staging database created staging tables temporary processing data loading target database using integration services ssis migrated data different data sources like sql server tables excel text file sql server tables provided data migration support deployment importing sourcetarget tables respective databases using data flow task execute sql task control tasks sql server integration services used transformations like derive column data conversion conditional split aggregate lookup load data data warehouse extensively using joins subqueries complex queries involving multiple tables maintained log information sql table tracking errors expertise enterprise reporting generating reports using basic reports sub reports filters sql server reporting services generated multiple enterprise reports using ssrs sql server database oltp included various reporting features group drilldowns drill reports manage 40 team calls per day technical issue produced highstandard database solutions meet stability reliability performance metrics supported multiple concurrent projects enabling delivery efficiencies technical resolution bs computer science 072004 addis abeba university ethiopia education certifications mcdba microsoft certified database administrator