jessica claire montgomery street san francisco ca 94105 555 4321000 resumesampleexamplecom professional summary accomplished database administrator dba 7 years experience working 11g12c19c databases vastly experienced oracle software installations database normalization design creation standalone containers database administration maintenance database tuning rman backup recovery automatic storage management asm real application cluster rac data guard physical patching upgrade opatchopatchauto security management performance tuning unixlinux windows operating systems seeking position dynamic technologically diverse environment skills rdbms postgresql 95x 11x oracle 11g 12c 19c languages bash shell scripting sql plpgsql performance tuning capacity monitoring standbyfailover administration data security backup recovery high availability installationadministration migration upgrades work history database administrator 012020 current foot locker metairie la responsibilities monitoring db growth every month dwh databases planning implement table partitioning better performance monitoring bloat reports every table performing maintenance minimal downtime performing minor major level upgrades using minimal prior testing test boxes accurate time notifications data migration upgrading database versions removing index bloat concurrently improve performance oraclepostgresql dba 112015 122019 gemphire therapeutics inc city state oracle responsibilities experienced oracle db 3tier architecture oracle database system development life cycle sdlc planning performed installation configuration upgrade patching oracle rdbms applications work different versions databases oem cloud control maintain database effectively monitored production databases using oracle enterprise manager oem provided maximum uptime routinely performance tuning queries maintaining aggregates compressions partitions indexing use hints stored outlines statistics gathering proficient plsql sql unix shell scripting implement unix scripts using cronjob daily activities windows task scheduler executed plsql sql tuning oracle contention monitor production database using automatic workload repository awr automatic session history ash automatic database diagnostic monitor addm sql tuning database performance tuning done based reports generated sql trace tkprof explain plan awr addm monitored database performance daily basis extensively implemented data pump conventional exportimport oracle 11g 12c migration logical backup database applied patch set critical patch updates cpu patch set updates psu oneoff patches using opatchauto runinstaller intermittently carried rman backups hot backups logical backups containerdb ocassionally tested proof concept switchover standby database switchback production database using dg broker utility postgresql responsibilities developed project plans implementing database environments provided input technical projects oversaw tactical aspects database related tasks designed implemented administration postgresql databases ensure accurate effective use data including database definition structure capacity planing documentation evaluated database design integration systems made recommendations regarding enhancements improvements responsible configuring integrating maintaining development qa staging production postgresql databases installed monitored postgresql databases using standard monitoring tools like nagios pgadmin installed configured ha connection pooling tools like pgbouncer pgpool haproxy installed configured tested monitored upgraded tuned new existing postgresql databases automated postgres deployments aws ec2 terraform ansible supported daily administration monitoring tuning troubleshooting clusters linux aws console database sizes range 100gb 2tb proactive updating latest security patches database provided postgresql global development group pgdg set maintained security integrity controls creation roles granting privileges executed quality control audits ensure accuracy completeness proper usage data tables various support tools database dictionaries provided appropriate interfacing consulting standards associated database management monitored transaction activity utilization diagnosed resolved implemented preventive measures guarantee availability performance recovery supported database environments configured log analysis tools like pghero pgbadger daily log analysis using pgbadger tool query tuning tuned autovacuum parameters ensure current table stats reclaim space consumed dead tuples maintained custom vacuum strategies table db level scheduled maintenance activities vacuum analyze improve query response time ability proactively identify troubleshoot resolve live database systems issues experienced code migration database change management various stages development life cycle contributed decreasing need downtime developing improving procedures automated monitoring proactive intervention studied stayed current features functionality postgresql knowledge disaster recovery principles practices including planning testing backuprestore handson experience database administration backup recovery troubleshooting responsible backups recovery upgrading postgresql databases performed weekly pointintime recovery pitr development environment proper failure testing implemented monitored replication high availability disaster recovery scenarios proactively managed standby replication procedures like streaming replication hot standby disaster recovery provided responses database issues 24 x 7 schedule responding critical events situations outside normal work hours ability thrive fastpaced deadlinesensitive environment participated daily stand ups discuss new database design modeling creation experienced mtk migrating databases oracle postgresql education bachelor science business administration 052015 wayne state university detroit mi associate arts general studies 042010 macomb community college warren mi certifications oracle 12c sql fundamentals