professional summary jessica claire resumesampleexamplecom profile summary oracle database administrator postgresql dba mysql aws dataguard goldengate rac rman mvcc repmgrpgbackrest pgbouncer pgbadger streaming rep oem 13cjenkins liquibase nexus exadata certified database administrator 7 years experiences handson experience overseeing design development maintenance various database systems well production databases believe skills perfectly suit needs excellent communication documentation skills well strong aptitude analyzing resolve problems enjoy solving large complex data problems enjoy process building determining solution good experience performance tuning backup recovery upgrades patching advanced security database monitoring using oem toad sql developer shell scripts rman ive also used pg sta activity pg top pg activity postgresql 4 years installing configuring high availability solution including always mirroring replication clustering data guard data protection disaster recovery golden gate streeming replication real time replication high availability rac scalability high performance availability exceptional worker always motivated able see impact work people requirements skills listed job description closely match background future career goals skills dba skills databases oracle 10g11g 12c 18c 19cpostgresql 9101112 mysql community 5780 112019 current work history oracle postgresql database administrator zoom phoenix az configured pgbouncer connection pooling pgbadger stats reports installed mysql 57 80 version encrypted mysql 57 community edition innodbengine clonned mysql databases restored participated 24 x 7 production development database support administration configured monitored streaming replication primary target ran maintenance auto vacuum jobs customized vacuum certain tables championed database migration oracle postgresql premises aws using migration tool kit ora2pg dms sct rewrote implemented backup strategy following company sla execution backup schedule physical using pg base backup pg backrest pg dumpall pg dump logical backups deployed database security policy installation using passwords privileges user profiles enabled encryption databases cloned databases using creation templates pg dump testing purposes performed plpgsql errors fixes application issues tuning sql statements optimize stored procedures analyze query plans write advanced plpgsql performed patching upgrades databases using aws minor versions upgrades pg upgrade pg dumpall logical replication participated weekly call rotation run packages peak hours installed configured pg versions 97107 114 supported daily administration monitoring tuning troubleshooting clusters single instances unixlinux aws console monitored cpu utilization memory database connections storage space daily using pg stat activity pem pg view aws cloudwatch alarms also use customs shell scripts deployed crontab monitor performance resources revised logs unusual events performance issues took appropriate action implemented table index partitioning improve query speed participated capacity planning meetings meet demands dynamic aspects storage memory databases worked data pump take logical backups databases experienced performing point time recovery using rman used oracle configuration assistants like dbca database configuration assistant creating databases dbua database upgrade assistant upgrading databases netca network configuration assistant creating clientserver environment using listener tns names etc extensively used awr addm explain plan periodic performance tuning awr addm ash toad oracle grid cloud monitoring configured oracle data guard oracle disaster recovery applying upgrade patch maintenance interim opatch patches databases implemented flashback technology oracle 12c 11g 10g along recycle bin faster recovery databases database objects performed full incremental backup cumulative differential using rman implemented recovery strategies refreshedcloned databases using rman utility made optimal use oracle support resolving srs configure goldengate downstream mining integrated component active passive active replication installedconfigured maintained upgraded patched oem 12c13c worked exadata installing upgrading patching tuning monitoring troubleshooting databases dacabase administrator emw inc norfolk va 012016 102019 perform maintenance activities like checking auto vacuum jobs customized vacuum certain tables supported oracle db backups onlineoffline logical backups unix scripts created clone databases performed dba daytoday activities implemented shellscripts automation daytoday activities monitor database systems provide technical support database system issues application performance enhancementimprovement using oem client oracle 10g database control sql plus well predeveloped unix shell scripts applied critical patch updates cpu patch set updates psu oracle databases interim patches various bugfixes database products backed recoveredclonedmigrated databases using rman traditional datapump export import utilities oracle 10gr2 11g used run scripts check status databases growing table sizes extent allocation free space used space fragmentation etc created physical standby databases performed failover switchover using data guard broker manually required involved oracle golden gate installation configuration monitoring implemented oracle database 12c rac databases using oracle clusterware achieving high availability oracle installation configuration migration upgrades patches server versions ranged oracle 10g 19c disaster recovery planning emergency recoveries ensuring recoverability databases experience working poc 12c new features like redaction policy adaptive query optimization multiple indexes single column restore table rman implementation administration users database permissions creation technical documents transportable tablespace user managed backup concept database system security database backup using crontab shell scripting restore recovery using rman rtorpo optimization work deployment team members plan review deploy databases database updates applications database peoplesoft tools creation cold hot usermanaged backups verify sql database backup jobs run successfully according defined schedules provide periodic reports performance capacity availability database database patches management duplication migration tuning configure install new sql servers experience interfacing oracle support providing trouble shooting offering consultation developers teams clients sql database disk layout allocating channels disks configuring parallelism coordinated team members setup documentation standards proactively monitor database performance tuning database improvement efficiency meeting business needs monitoring ticketing system bmc remedy delivering high quality services timely manner applying patches create configure oracle security policies using oracle enterprise manager experience assessing evaluating oracle rac environment documenting failover switchover high availability maximum performance protection awr addm ash toad oracle grid cloud monitoring create configure oracle advance security policies using oracle cloud control enterprise manager installed configured grid control multitenant pluggable database cluster database assess evaluate existing oracle environments documenting recommending life cycle replacement options installed cluster rac database grid control applied psu patches oracle container pluggable database cluster environments evaluate oracle features oracle related products participated cross platform migrations oracle postgresql documented assisted data migration oracle databases postgresql database premises aws cloud involved installingconfiguring postgresql version 96 12 manage monitor databases using pgadmin using pghero performance tuning well sql tuning using explain analyze pg stat activity performing basic tasks objects creating roles granting privileges creating tables implementing use indexes primary foreign key constraints required providing production support based ticketing system assisted defining implementing maintainance plan database systems performing maintenance activities like vacuum vacuum full analyze etc configured pgbouncer connection pooling pgbadger generating statistic reports experienced tuning postgresql server settings troubleshooting performance issues managing users tablespaces postgresql servers using customized scripts monitor database growth table growth automated backups using cronjobs checking auto vacuum jobs customized vacuum certain tables columns experienced handling logical physical database backups assisted developing implementing best practices disaster recovery backups used restoration techniques like pg restore pitr point time recovery performing backups restore compressed gzip backups database schema refreshes configuring streaming replication including cascading replication configured replication primary target monitored ongoing replication ofacle database administrator allianz city state oracle production support database administrator 032014 112015 successfully installed configured oracle 11107 oracle 10205 databases aix platforms administered monitored 150 databases 10g11g prodtestdev environments migrated databases filesystem automatic storage management asm involved migrating applications solaris 10g11g linux 11203 using transportable tablespace rman convert upgradation single instance databases 10204 11203 installed 12c grid control used oracle enterprise manager grid control 11g12c monitoring databases programming shell create shell scripts automate database backups maintenance installed set high availability oracle golden gate ogg systems oracle 11g 12c environments upgraded oracle golden gate ogg systems 11g 12c implemented two types standby databases supported data guard logical standby physical standby databases 11gr2 two node rac hands experience hotcold backup recovery cloning databases using rman education bsc hons economics statistics kyambogo university aws solutions architect certified database 12c sql fundamentals oracle database 12c administration oracle cloud infrastructure architect associate oracle autonomous database cloud specialist comptia security ce may 2013