jessica claire resumesampleexamplecom 555 4321000 montgomery street san francisco ca 94105 professional summary senior oracle database administrator oracle dba experience oracle products multiple platforms environments spanning banking communication tech sectors experience call 24x7 production dba support applicationdevelopment dba extensive knowledge database administration oracle 9i 10g 11g 12c experience largescale database environment mission critical large oltp olap systems experienced oracle installations upgrades migration configuring logicalphysical architecture sql tuning database access security auditing deep understanding exadata specified features smart scan hcc hybrid columnar compression flash cache etc involved patching exadata components infiniband cellnode db node skills guest services inventory control procedures merchandising expertise loss prevention cash register operations product promotions education university houston dec 2013 master science management information systems management information systems gpa 34 griet hyderabad june 2012 bachelor technology gpa 36 certifications cma certified management accountant conferred institute management accountants ima member institute logistics transport milt certified protection officer cpo work history aar corporation sr oracle database administrator patrick space force base psfb 042016 011 planning configuring near zero downtime database migration upgradation oracle databases nonexadata exadata servers design implement active active active passive goldengate replication also upgraded goldengate 12102 lower versions implemented advanced security using tde transparent data encryption managed cross platform migration 15tb heavy transactional oracle database solaris 11107 linux 12c using oracle goldengate install configure administer oem13c migrated 70 oracle databases different datacentres nonexadata exadata machines using goldengate active dataguard transportable tablespaces rman expdp impor impdp upgraded 11204 databases 12c using manual upgrade dbua coming configuration implementation dataguard physical logical standby databases automating monitoring resolving gap lagging issues performed tuning oracle wait eventslatchesenqueuesmemory structures using automatic shared memory management asmm ash buffer cache advisors fabricated multiple cloning databases using manual method rman utility backup recovery procedures using rman created scripts rman incremental backups also full database backups using datapumps involved process improvement oracle server installationsupgradespatches space management capacity planning backup recovery disaster recovery database performance tuning memory tuning application tuning security administration data warehousing data guard oracle advanced replication real application clusters oracle standby services environment oracle 11g12c exadata x3x4x5 oracle enterprise manager 12c13c goldengate 11g12c oracle rac goldengate veridata tde active dataguard rman backup recovery expdpimpdp dbua apex systems oracle dba altamonte springs fl 092015 042016 installed configured maintained oracle 11gr2 4 node rac exadata x52 full rack assisted management database administration oracle database applications exadata x3 x5 platforms installed configured maintained oracle database 12c deploy 12c agents target servers add target configuration items monitor plugin installations target servers extend functionality oem configure oracle advanced security implement transparent data encryption table space table column levels levels also configured redaction using oems policy expression builder setup physical standbys dataguard several databases via oem well implemented dbfs exadata troubleshooting exadata smart scanoffloading issues monitoring infiniband switchesports hca ports dbcell nodes ib topology migrating databases exadata setting monitoring exadata using oem12c maintaining troubleshooting exadata cellstorage dbcompute node performance issues implemented goldengate unidirectionalbidirectional replication rac using acfs file system configured dataguard broker primary standby databases perform switchover failover monitor dataguard status storage migrations solely responsible migrating prodtestdev databases netapp hnas also block level storage migrating databases nonasm asm backuprestore recover databases using rman flashback database procedures database installation upgrades patching upgrade binaries applying patch set interim patches using opatch opatch auto capacity planning projects owned environment effective production support hour support support handover offshore coordination environment oracle 12c11g10g unixwindows oracle exadata x5 x2 golden gate oracle 11g sun sparc t41t31 red hat linux 58 aix 6 oem 12c rac oracle advanced security data guard including dg broker setup rman partitioning compression dbfs asm performance tuning opatch auto toad oracle 121116 storage migrations apex systems oracle dba arden hills mn 012014 082015 migrated oracle databases using oracle 11g goldengate migrating databases oracle exadata database machine different clients worked upgrading oracle databases 11g 12c installed oracle 12c database cloud control 12103 linux 64bit server implemented oem cloud control 12c agent installations plugins installations adding targets oem monitoring databases using oem 12c cloud control worked troubleshooting 2node 4node rac implemented 11g new asm features extensively worked setting physical standby database using data guard implemented new 11g feature active dataguard snapshot standby database implemented switching primary database standby standby primary regular maintenances catalog databases dr databases configure oem 12c monitoring customized templates email alerts configured asm handled issues suggested feasible workarounds asm metadata corruption extensively worked asmcmd managing asm performed dr drill activity applying patch set interim patches using opatch upgrading binaries provided instance level performance monitoring tuning event waits sessions physical logical io memory usage sql query tuning using tools like explain plan sqltrace tkprof sql tuning advisory installed sqltxplain sqlt tool helps diagnose sql statements performing poorly used oracle 11g12c awr addm monitor database activities performance tuning performed range partitioning cause improve performance database proactive performance monitoring capacity planning future database server growth using oem applied inecessary patches installation also upgradation databases oracle 11g database versions extensive experience change control management database changes performed cross platform migration using transportable table spaces rman data refresh production development test environments using data pump export import involvement space management rectification lock problems user management supporting application developers various performance connectivity security related issues various projects scheduled jobs backups using 12c oem crontab experience backups recovery using rman shell scripts involved 24x7 production support oncall pager environment oracle 12c 11gr2 hpux redhat linux sun solaris ibm aix oel 58 oem12c rac golden gate oracle exadata oracle fail safe 3x rman expdpimpdp partitioning asm dbfs data guard including dgmgrl performance tuning opatch utility toad db artisan sql developer shell scripting skills ibm aix aix 6 aix 5x asm backup c capacity planning catalog cpu encryption clients database administration databases database data warehousing debugging disaster recovery editing email erwin etl features flash gui hpux linux managing memory access windows 3x windows xp migration mysql enterprise operating systems oracle 9 oracle oracle enterprise manager oracle database db developer plsql postgresql 80 process improvement redhat linux red hat linux 58 red hat scheduling servers scripting scripts shell scripting shell scripts sun solaris sun solaris 58 solaris sql sql server sql loader sun sparc switches toad troubleshooting 2 troubleshooting unix hp unix unix shell scripts unix shells upgrades upgrading upgrade utilities