jessica claire 9 resumesampleexamplecom 555 4321000 montgomery street san francisco ca 94105 career overview principal support engineer oracle usa database performance team since 2009 till database performance tuning database optimization expert oracle 12c 11g earlier versions troubleshoots resolves database performance issues custom cots applications including oracle ebusiness suite people tools goldgate rac exadata multidbmsmultiplatform dba experience 18 years oracle 10 years db2 2 years sql server solid data architecture background data warehousing data profiling experience major previous employers bristolmyers squib oracle dba dba manager database data architect ibm db2 dba qualifications oracle database performance tuning expert 12c 11g data warehouse design optimization data quality metadata analysis oracle usa principal support engineer top accountshighest severity database data architect pharmaceutical research environment database contents performance metrics capacity planning computation complexity scalability algorithms industry independent certifications oracle 11g ocp 11g certified tuning expert speaker conferences oracle open world san francisco 102006 presentation s281237 13201 transparent application tuning using sql profiles practical lesso lessons tips techniques oracle life sciences user group boston 42006 metadata profiling aspects oracle 10g snowflake hybrid schema optimization multiple oracle internal courses area database performance tuning education training university warsaw warsaw 1981 msc mathematics numerical methods applied mathematics numerical methods computational complexity algorithms accomplishments resolved hundreds database performance issues oracle customers prevented large number database performance issues evaluating results preproduction testing recommending appropriate patches andor database changes resolved lots problems related upgrades oracle databases 12c 11 oracle applications latest point releases resolved numerous issues oracle workload repository maintenance enterprise manager real application testing etc filed multiple new defects oneoff patch requests 12c 11g based external internal test cases consistently ranked among top 1020 database performance support engineers us lists available request work experience atos principal engineer oracle customer database performance support boca raton fl 012009 current supports oracle top platinum accounts severity 124x7 service requests us overseas area critical database performance related issues given day typically works 56 cases including 23 brand new cases responsible initial high level triage real application cluster rac exadata performance problems within database performance team participates oracle performance tuning automation initiative modern technology solutions inc data architect bms global data architecture oklahoma city ok 032007 112008 customer address data remediation dataflux parsing profiling enrichment profiled customer address data assessed data quality via metrics score cards drilldowns source data designed remediation process rational rose defined created staging database allfusion oracle developed data architect enrichment jobs dataflux wrote tested implemented reports update scripts verify addresses usps database apply approved changes matching records master database based difference classification scheme product hub profiled material data rawsubstances api intermediate drug products packaging materials erp bpics sap rd regulatory submissions repositories using dataflux architect jobs profiled bom data extracted sap using sql serverback office oracle queries dataflux architect jobs profiled single item master data dataflux architect jobs reversed engineered sap identity reference rules boms help formulate validate integrity sourcetotarget mapping requirements maintained phub logical physical models participated design phub logical physical data model allfusion 72x synchronized phub physical model oracle database objects development test environments participated defining requirements creating test cases testing phub reference data maintenance jobs cold chain management biologics participated requirements reviews bms biologics cold chain management project protecting integrity temperaturesensitive products storage transportation created cold chain logical data model integrate sensitechs cold chain solution temptale4 bio supply chain reference models sap focused drug substanceproduct life cycle events relationship readings temperature monitoring equipment trip data analysis ensure shipment maintained specified temperature limits met stringent fda regulations shipment exceeded preprogrammed thresholds established particular product included aggregated ambient temperature durations entire life cycle drug products data quality assessment methodology authored documents data architects developers defining data profiling deliverables data profiling best practices guidelines data techniques processes model mart administration created extensions data browser facilitate global analysis object classes properties cross library model subject area integration developed customized used reports entities attributes low level version control reports troubleshot documented model mart performance problems bugs interfaced ca technical support regarding software upgrades patches continuous improvements suggestions submitted well documented proposals use allfusion erwin logical metadata data mart active search b extend dataflux metadata repository supplement dataflux scorecards adding metadata metrics metadata searches cuse metadata metrics logical physical models assessment sharp decisions database architect scientific computing services scs global core technologies gct remote new hyde park ny 102005 032007 main areas responsibility included physical database design optimization scs data warehouses evaluation implementation new technologies grid control business activity monitoring soa supported drug discovery exdi bioinformatics applied genomics databases dba 40 databases including two multitb data warehouses cellomics resolver administrator pri em grid control repositories bristolmyers squibb managertechnical team lead oracle database administration scs gct city state 022000 102005 managed dba team supported 200 drug discovery exdi bioinformatics applied genomics production uat test development databases supervised coordinated work 35 oracle database administrators supervised system application dba tasks including software installations upgrades patches backup recovery performance monitoring tuning disaster recovery capacity planning planning responsible resource capacity planning performance partnerships annual development summaries dba staff assisted development teams aspects physical database design various enterprise endeavor pro endeavor projects provided high low level consulting services challenging database projects drug discovery exdi divisions pri smartidea clrs oscar hts etc dramatically improved performance smartidea forms builder applications via application transparent physical database redesign underlying central database repository cdr based thorough analysis access patterns indepth profiling data metadata good understanding oracle 10g features key elements physical database design partitioning subpartitioning clustering materialized views histograms predicated aligned top 10 bms focus disease areas overall performance suite ca 400 sql test queries cdr improved 10 times version 31 measured elapsed cpu times top 10x improvement version 21 accomplished mostly generic hints various types dynamic sql performed troubleshooting performance tuning support multiple databases upgrades oracle 9i 10g configured oracle monitoring tools oem third party tools qco quest software proactively monitor production databases submitted 20 functionality improvement suggestions quest software related monitoring optimization tools participated tools evaluations information integrator ibm axio evoke qco foglight shareplex quest software oracle timesten inmemory database oracle business activity monitoring oracle bam designed implemented prototype meta data profiling tool oracle assess data distributions histograms developed library data metadata profiling scripts aimed rapid evaluation various aspects logical physical database design data correlations contextual key analysis surrogate key translation etc bristolmyers squibb senior oracle database administrator worldwide medicines group city state 011996 022000 special award ca 50x performance improvement esprit reporting functions manual implementation materialized views supported multiple sap centric data warehouses data marts gateway esprit ardm sprd dm dme participated physical database design implementation number data marts wmg mras report viewer one component discover data warehouse qbar provided database support number software packages plateau ezreq expert evolution advisor home grown applications gss clipr uk us member dba team sales marketing data warehouse project based intelligent warehouse product hp made numerous performance improvement recommendations physical database level cost based optimization bitmap indexes star queries partition elimination sql level implemented production provided dba support olap software sparsity analysis holos crystal info provided db2 consulting services new mainframe projects common customer multiple legacy applications including cops responsible db2 databases disaster recovery support supported platinum database administration tools developed data profiling scripts db2 supported entire suite quest software administrative monitoring tools provided training mentoring dbas american express db2 dba consultant city state 091995011996 supported hr applications tessaract running db2ibm 390 8 environments extensive use platinum database administration tools tuned dynamic sql pershingdlj senior db2 database administrator city state 051994 091995 designed bachman implemented db2 v3 databases two data marts manager view pershing correspondents brokers credit view internal used advanced db2 features including partitioning data sharing mentored fellow dbas areas sql optimization performance monitoring tuning supported bmc database administrative tools including software installation configuration ibmpathmark db2 dba data architect city state 081988 051994 logical design adw physical database design db2 v 23 pathmark advertising sales warehouse applications supported implementations worldwide chain stores system package wcss ibm clients customized ddl introduced partitioning improved physical database design data compression indexing optimized wcss sql db2 v 23 ibm 390 based thorough data metadata analysis performed sql code reviews supported applications became expert platinum database administration tools ibm employee 1992 pathmark outsourced department ibm kvl systems programmer city state 101987 081988 mainframe cobol assembler programmer cicsidms environments consulting assignments mp chemicals dun bradstreet sandoz new jersey informatics data center software engineer city state usa 051980 101987 member development team implemented subset sql network dbms idms rodan coded nested loop merge joins well group clauses aggregate functions presented paper join optimization budapest hungary 1983 designed implemented set operations union intersect minus database consulting engagement kuwait oil company ahmadi kuwait 198485 skills performance tuning expert oracle 12c 11g earlier versions extensive data base management data modeling data warehouse design skills efficient customer call web conference management large audiences including customer engineers managers executives good interpersonal communication skills resulting frequent customer requests additional service personalized performance training excellent troubleshooting root cause analysis problem solving skills based thorough knowledge internal traces 1004610053 system state dumps hang analyze output sqlt sqlhc utilities sql tuning advisor sql access advisor addm awr ash reports etc indepth familiarity oracle performance tuning methodology starting issue clarification verification cause determination justification proposed solution justification detailed action plans throughout case life cycle ending internal knowledge management content creation andor updates includes filing new bugs oneoff back port requests patches good understanding awr repository model root cause analysis rca phase using appropriate standard adhoc drill downs historical snapshots solid 11g 12c real application testing rat background indepth familiarity adaptive sql management adaptive execution plans optimizer statistics management 12c