jessica claire montgomery street san francisco ca 94105 555 4321000 resumesampleexamplecom professional profile oracle certified database administrator dba 7 years experience information technology possess extensive knowledge proficiency database design monitoring tuning security implementation risk analysis well backup recovery windows unix attention detail ability maximize system resources areas exhibit quickly easily adaptability fit new work environment strong ability quickly grasp translate technical issues ability work extended hours toward tight deadline great team player fast learning curve work perfectly stressful conditions speed accuracy necessary mission critical databases possess decent work ethic dynamic detail oriented excellent communication troubleshooting skills well cohesive team member oracle 10g 11gr2 12c database administration summary skills 247 production development support oracle ms sql server administration software development life cycle sdls sql server mysql big data hadoop administration creating databases managing user securities oracle sql server database security data access profiles per stig rules rdbms installation creating managing oltp olap database patching cpu psu oracle software upgrade 10g11g 12c migration flashback technology log miner addm implementation backups using rman datapump backup policy using rman vnb veritas net backup perform upgrades oracle dbms software heterogeneous platforms implementation high availability solutions oracle 11g rac physical standby database data guard recovery media failure block corruptions user errors sql server mysql big data hadoop administration database security data access profiles per stig rules patching cpu psu oracle software upgrade 10g11g 12c migration backups using rman datapump backup policy using rman vnb veritas net backup implementation high availability solutions oracle 11g rac physical standby database data guard performance tuning using statspack tkprof explain plan sql trace awr addm experience stored procedures functions database triggers disaster recovery plans implementing 10g11g oracle rac data guard switchover failover asm rac non rac configuration data pump schema refresh database object migration proficient sql plsql unix shell scripting analyzed batch programs administration management database links oracle golden gate data replication technical skills databases oracle 12c 11g10g mysql ms sql server 20052008 20122016 ms access rac golden gate aws rds operating systems unix linux red hat sun solaris25268910 hpux 10x11x aix 51525361 rhel 213x4x5xwindows xp 200020032008 peoplesoft fnhr 91 ms office suite 20032016 languages sql plsql unix shell scripting perl html xml rdbms utilities sqlplus oracle enterprise manager real application cluster asm transportable tablespaces sqlloader rman datapump utilities expdpimpdp adrci emcli management studio word bench tools tkprof explain plan statspack awr addm toad putty nx client winscp remote desktop connection vnc team viewer logmein cisco vpn client sql developer db artisan education training oca oracle certified associate sql fundamentals certified oracle university database management southern new hampshire university diploma electronics computer telecommunication technology tesst college technology beltsville md electronics computer telecommunication technology experience oracle database administrator 012013 current cognizant technology solutions cheverly md installed configured software oracle 10g 11g 12c windows unix platforms using ofa supported daily administration proactive monitoring tuning troubleshooting single instance unixlinux windows server 2003 2008 databases sizes range 10gb 23tb collaborate system administrator configure software hardware requirements function oracle database capacity planning developers development test production growth potential implemented backup strategy following company sla implementation backup schedule logical physical backup using rman datapump utilities respectively consult provide guidance database users client groups often recommending tactical strategic solutions created documentation project planning project execution project maintenance phases participated change management board meetings new release change implementations removal retirement decommissioned old services knowledge normalizationdenormalization techniques oltp olap environments migration database objects across platforms flexibility adapt willingness learn new technologies responsible setup implementation 2 node rac linux platform 10g 11g r2 implemented data guard creating logical physical standby databases 10g 11g rac environment production database experienced design implementation generating documentation oracle 10g 11g data guard physicallogical standby databases high availability mode optimizing performance databases periodic basis using awr addm reports providing recommendations implemented asm rac standalone databases managing disks disk groups asm done migration non asm database asm database scheduling maintaining level 0 level 1 rman recovery manager backups managing monitoring optimizing performance databases periodic basis using awr addm reports providing recommendations planned performed daily weekly monthly backups tested implemented restore procedures complete incomplete recovery using rman sql tuning application performance monitoring resolving issues related network congestion memory sga pga cpu io capacity planning oltp environment allocating system planning future storage requirements existing new databases involved installation configuration oracle 10g 11g rac using oracle clusterware asm implemented data guard physical standby database 10g 11g rac environment production databases active passive cluster creating managing database structures storage allocation tableindex segments constraints database access roles privileges performance tuning queries maintaining aggregates compression partition indexing use hints stored outlines statistics provided database related services development qa environments database refreshcloning object migration performed policies data confidentiality integrity availability auditability based access controls access data database level extensively implemented datapump conventional exportimport oracle 11g 10g migration logical backup database strong skills applying security patches patch set critical patch updates cpu patch set updates psu oneoff patch using runinstaller perl based utility opatch worked closely developers better performance applications writing packages triggers materialized views indexes tables used secure scp sftp extensively file transfers machines remote server experienced documentation excellent writing skills provided documentation database design analysis modifications creating schemas etc develop automation python perform tasks related data migration security database performance optimization automation duties assigned oracle database administrator 112010 122013 cognizant technology solutions clinton nc installation maintenance oracle 10g11g linux os installed upgraded patched oracle installations capacity planning supported 3 tier architectures planning tables indexes tablespaces databases allow growth potential analyze data growth trends capacity resource consult provide guidance database users client groups often recommending tactical strategic solutions worked closely system administrators developers technology stack team server tech teams implemented security basic advanced security techniques like applying recent patches upgrades appropriate user grants permissions profile management automated tasks operating system level using crontab database level using sql scripts plsql procedures schema refreshes using exportimport expimp oracle data pump expdpimpdp creating users administering user privileges sql tuning database performance tuning reports generated sql trace tkprof statspack explain plan monitor database performance daily basis responsible optimizing queries application tuning provided support application database administrators designing database implemented rman backups hot cold full incremental per backup policy automated nightly rman backups production development test databases using crontab recovered full pointintime databases needed rman backups cloning database using scripts well rman management schema objects partitioning tables creating indexes performed hot cold backup recovery using rman unix scripts monitored database sql performance using stats pack oem explain plan tuned problem areas enhance performance worked application database security data access passwords network etc handled daily production problemschange requests oracle performed daily database administration tasks user management space monitoring performance monitoring tuning alert log monitoring backup monitoring performed physical backup hot cold well logical backup exportimport proactively managed databases set alarms managing exceptions day day management databases preempted prevented issues disasters happening monitoring table space issues management user accounts involved session management monitoring critical wait events blocking sessions database implemented data guard oracle 11g high availability performance configurations participated data guard fail tests using oracle data pump utility making faster exportsimports large databases monitoring several databases varying terra byte sizes using oracle enterprise manager grid control worked extensively monitoring grid control database configuration error notifications installing listeners adding listeners grid control export import database objects one database another database investigating suspicious database activity using auditing involved query optimization using rule based optimizers cost based optimizers experience working oracle support open srs per company sla supported production databases 247 call rotation shared responsibly fellow dbas 247 oncall support documented work progress updated work road map project status administrative managerial assessment constantly monitor performance v dynamic performance views peak load databases viewing alert log files trace files detecting correcting instance performance problemslocating tuning sql statements demonstrated effective oral written communication skills ability communicate technical information nontechnical personnel reconciled functional technical problems interaction client researching identifying defined issue fully testing confirming workable solutions problem database administration upgrades performance tuning production support installation encrypting securing monitoring migration rac configuration backup recovery cloning refresh space management security database conversion pluggable database 12c database security transparent data encryption data pump rman encryption user account management involved query optimization using rulebased optimizers costbased optimizers