jessica claire montgomery street san francisco ca 94105 555 4321000 resumesampleexamplecom summary seasoned professional expertise database administration providing various dba roles across linux solaris unix windows platforms various rdbms software versions oracle 10g 11g 12c18c postgresql9x 10x 11x 12x microsoft sql server 20122016i hands experience oracles multitenant architecture12c postgresql cluster sql server management studio performing installations configurations maintenance technologies golden gate heterogeneous homogenous platforms realtime replication data guard disaster recovery proficient migrations backup recovery strategies upgrades patching performance tuning scripting great team player great written oral communication skills enthusiastic learning new technologies skill summary expert performance tuning monitoring oracle databases unixlinux platform using database tuning tkprof explain plan awr addm reports advisors sql tuning sql advice undo segment mttr memory created indexes facilitate easy user interface implementation tuning experience 12c oem grid monitoring custom scripts troubleshooting oracle databases using sql trace utilities adept installation oem database control oem grid control deploying agents performed rman backups full incremental cumulative complete recovery incomplete recovery disaster recovery using standby database data guard excellent knowledge flashback recovery hotcold backup cloningrefresh databases using rman extensively worked importexport data pump importexport tools indepth knowledge understanding oracle database features rman backup recovery materialized views exportimport data pump data guard working knowledge auditing database security database security using oracle security features roles privileges auditing transparent data encryption dbms crypto skills oracle dba 10g 19c data guard oracle goldengate performance tuning backup recovery troubleshooting security rac linux solaris windows awr addm sqlplsql shell scripting installed configured managed postgresql servers postgresql version 10x11x12x 13x experience 092020 current database administrator spencer gifts llc egg harbor township nj postgresql security roles group roles row level security privileges ansible ha solution streaming replication setup logical replication configure repmgr pgbadger pgbouncer teradata pg basebackup pgbackrest pg dump pg dumpall pgadmin 4 loading data flat files database using sqlloader external tables extensively used awr addm explain plan periodic performance tuning end end exadata maintenance troubleshooting hardware issues exadata implementing datapump conventional exportimport utility oracle 10g11g 12c amd used importexport utilities cloningmigration small sized databases datapump importexport move data 10g 11g 12c 18c 19c environments involved construction dr sites configuring dataguard enterprise failover manager production environments participated scheduled switch tests performed database refresh production qa uat development databases implemented managed optimum database design databasesschemastables tablespaces data files extents redo logs archive logs assessed database capacity monitoring online storage growth file system space provided instance level performance monitoring tuning event waits sessions physical logical io memory usage extensive experience rman recovery testing successfully implemented backup recovery using rman includes hot backups cold backups rac standalone database created clone database using rman remote server used srvctl commands real application cluster rac databases installed configured oracle 12c 18c 19c database knowledge oracle data warehouse dba skills relating administration management olap environments oracle oltp experience writing unixshell scripts providing reports installed configured oracle 11g 12c 18c 19c databases test server using oracle standard procedures ofa performance testing future 19c production implementation goldengate setup parameterization scaling log dump utility extract files maintain enterprise databases scheduling installations upgrades patches version 12c 11g 10g accordance established policies procedures experience application development full knowledge sdlc postgres responsibilities installed configured managed postgresql servers worked recently postgresql version 10x 11x 12x community enterprise editions participated 3months migration project oracle postgresql premise aws cloud using tools mtk ora2pg aws dms sct migrate datadatabases use postgres native tools like pgbadger pgpoolpgbouncer pem well aws feature like aws performance insight tune postgres databases running onprem cloud backup postgresql databases using tools like pg basebackup physical backups pgbackrest incremental differential backups well pg dump pg dumpall logical backups refreshes setup enterprisedb failover manager efm postgresql server monitor streaming replication setup ha solution streaming replication including cascading replication master two slaves postgresql server disaster recovery high availability load balancing pg stat activity pg view aws cloud watch alarm salso use customs shell scripts deployed crontab monitor performance resources performed complete pit recovery postgresql cluster used aws management console configured managed postgresql database instances amazon rds vacuumvacuum full analyze reindexing monitor space utilization pg walpg xlog use clientside applications like pgadmin psql connect manage postgresql databases onpremise cloud create security groups control incoming outgoing traffic postgresql database instances aws cloud create read replicas amazon rds postgres read scalability automate daily full backup manual snapshot backups postgresq1 advanced server databases running cloud optimize postgres instances aws cloud using native tool aws performance insight setup logical replication postgresql cluster replicate specific tables schemas using publication subscription upgraded postgresql database servers version 10x 11x 11x 12x using pg dump pg restore pg upgrade use pgcrypto encrypt data rest secure socket layer ssl data transit served rds database administrator oracle postgres experience launching postgresql database aws rds ec2 instances console clicreated used aws identity access management iam maintain user accounts iam assigned restricted policies users groups needed use aws data migration service dms schema conversion tool sct migrate database schemas schema objects local datacenters rds aws cloud well migration database oracle rds postgresql running ec2 instance aws cloud configure manage aws glacier move old data archives based retention policy databases applications aws glacier vaults monitor resources applications using aws cloud watch performance insight enhanced monitoring including creating alarms monitor metrics ebs ec2 elb rds s3 hands experience deploying configuring aws vpcs iam roles s3 buckets jenkins ansible cloudformation services 062018 082020 database administrator spencer gifts llc los angeles ca maintained 247 availability implementing standard processes troubleshooting live issues within defined tight sla times supported maintained productiondevelopment databases various servers installed monitored postgresql database using standard monitoring tools like nagios etc extensive experience warm standby postgresql 8x earlier hot standby postgresql 9x greater data migration upgrading database versions ranging 96 10x 11x installed configured connection pooling tools like pgbouncer pgpool installed configured object level replication like slony setup maintenance postgres masterslave clusters utilizing streaming replicationcrossdatacenter disaster recovery backup architecture performed incremental backups using recovery manager rman created recovery catalog performed complete incomplete recovery using rman performed consistent inconsistent rman backups monitored various database activities backup error logs space object performance user session monitoring ensure proper capacity availability monitored different databases application servers using oracle enterprise manager oem 12c 134 cloud control developed custom scripts implemented standard procedures troubleshoot live production issues leveraging oracle ash awr addm data expertise plsql sql unix shell scripting implemented unix scripts using cronjob dayto day activities windows task scheduler wrote shell scripts purging trace files alert log network log files linux boxes used standard script across databases performance tuning database sql tuning used tuning utilities like statspack tkprof explain plan awr addm tuning sga distribution disk io sizing tables indexes monitoring availability system listener database alter log file trace file 032015 052018 oracle database administrator edward jones crossville tn automated monitoring databases performance parameters backup recovery activities running cron jobs customized various unix shell scripts sending email ora errors reports quick monitoring check qmc automate routine dba tasks taking backups exports space usage monitoring move archive logs different mount point archive destination full resync rman catalog worked team installation maintenance oracle 10g rac asm database high availability performed database replication production testdevelopment environment using rman data pump utilities manually installed oracle grid software standalone servers asm file system constantly monitor performance v dynamic performance views peak load databases viewing alert log files trace files run sql plsql scripts check status databases growing table sizes extent allocation free space used space fragmentation etc performed space management capacity planning disaster recovery overall maintenance databases created physical standby databases using rman zero downtime performed failover switchover using data guard broker manually required successfully performed data replication using materialized views oracle streams oracle 10gr2 strong experience sql server configuration optimization design troubleshooting support postgres responsibilty installing configuring postgresql source packages linux machines experience designing database structures indexes views partitioning implementing backup recovery logical online controlling migrations programs data base changes reference data changes menu changes development life cycle setup maintenance postgres masterslave clusters utilizing streaming replication crossdatacenter disaster recovery backup architecture performing schema management database sizing maintaining privileges data migration upgrading database versions ranging 82 95 extensive experience warm standby postgresql 8x earlier hot standby postgresql 9x greater scheduled maintenance activities vacuum analyze improve query response time pg stat activity pg view aws cloud watch alarms also use customs shell scripts deployed crontab monitor performance resources education training 072010 bachelor science human resource management certifications covenant university nigeria oracle certified associate 12c oca oracle cloud infrastructure 2019 architect associate oci