jessica claire 100 montgomery st 10th floor 555 4321000 resumesampleexamplecom summary multitalented database administrator 6 years expertise designing testing coding database solutions various environments highly skilled multiple technologies performance tunning data migrations motivated selfstarter consistently meets deadlines succeeds highpressure environments data conversion migration python continuous process improvement writing queries database analysis safety protocol skills document management index management performance tuning git upgrades amazon web services experience postgresql database consultant 022023 current cognizant technology solutions princeton nj providing technical support guidance clients aspects postgresql database operations including installation configuration optimization backup recovery security spearheaded development implementation business intelligence architecture deliver endtoend bi solutions troubleshooting resolving complex database issues clients timely effective manner using variety diagnostic tools techniques developing maintaining technical documentation including best practices troubleshooting guides operational procedures help clients optimize postgresql database environments collaborating technical teams software development customer support deliver highquality service clients ensure customer satisfaction participating database migration upgrade projects helping clients move postgresql databases newer versions platforms needed staying uptodate latest developments postgresql database technology related tools technologies sharing knowledge insights colleagues clients analyzed database applications made necessary adjustments parameters architecture improve performance postgresql database administrator 092020 012023 cognizant technology solutions redmond wa worked software vendors analyze resolve software installation ongoing support issues solved complex analytical problems using statistical models data supported planning software development purchases coordinated implementation partnered project management teams development scope timelines created data verification testing methods resolve performance issues prevent glitches spearheaded development implementation business intelligence architecture deliver endtoend bi solutions coordinated security compliance audit preparation cyber security team participated evaluation design implementation new major enhancements business applications aligned systems business needs enhance scalability database structures recommend improvements analyzed database applications made necessary adjustments parameters architecture improve performance defined synchronization plan patch management established security controls help protect client systems recommends oversees implementation databaselevel configuration changes optimize performance ensures maintenance physical integrity production databases install configure test monitor upgrade tune new existing postgresql databases tuning auto vacuum parameters ensure uptodate table stats reclaim space consumed dead tuples contributed decreasing need downtime developing improving procedures automated monitoring proactive intervention studied stayed current features functionality postgresql proactive managing standby replication methodologies like streaming replication hot standby disaster recovery scheduling daily pointintime recovery pitr development environment proper product testing proactive updating latest security patches database provided postgresql open source community provisioned azure data lake gen2 data factory azure database postgresql using terraform postgresql database administrator 082018 082020 emw inc norfolk va consulted internal departments identify customer needs include project objectives solved complex analytical problems using statistical models data developed strategies assess applications designed client standards eliminating security risks aligned systems business need enhance scalability database structures recommend improvements analyzed database applications made necessary adjustments parameters architecture improve performance scheduling daily pointintime recovery pitr development environment proper product testing administered postgresql aws aurora ec2 rds spearheaded development implementation business intelligence architecture deliver endtoend bi solutions collaborated stakeholders gather business requirements enhancements change requests used pghero performance tuning tuned sql using explain analyze pg stat activity performed maintenance activities like vacuum vacuum full analysis tuned postgres instances using pg tune pgconfigurator configured pgbouncer connection pooling installedconfigured postgresql version 96 10 11 monitored managed using pgadmin psql implemented sharding host partitioned tables remote servers via postgresqls foreign data wrapper fdw performed backup using pgbackrest pg dump pg basebackup created managed database objects users roles indexes views sequences permissions migrated oracle databases aws aurora postgresql compatibility using schema conversion tool sct data migration service dms tool administered postgresql aws cloud manually converts incompatible codes converted using sct wrote postvalidation scripts validate oracle postgresql objects count migrated oracle postgresql premise using ora2pg performed database patching well version upgrade using logical replication pg upgrade 9 11 configured managed streaming replication master multiple slaves high availability oracle database administrator 052016 072018 hughes network systems llc city state created implemented recovery strategies successfully recovered databases using rman utilized rman utility schedule monitor physical backups cron tab created users groups roles profiles granted privileges according job needs optimized tuned sql queries using sqltrace tkprof explain plan utilities applied security patches patch set critical patch updates patch set updates used transportable tablespace tts quickly move users tablespace across oracle databases implemented data refreshes using rman data pump conventional exportimport oracle 11g 10g installed configured oracle 11201 database linux windows platforms upgraded databases 11g noncdb 12c successfully used materialized views oracle streams oracle 10gr2 perform data replication implemented tablespace level tde security created oracle wallets constantly monitored performance databases viewing alert log trace files managed space capacity planning disaster recovery overall maintained databases responsible rman backups improvement backup incremental back adding block change tracking feature oracle 11gr2 maintaining scheduling cold backups hot backups export dumps maintaining backups archive logs automating cleaning archive logs deploying rman automate backup maintaining scripts recovery catalog performing complete incomplete recovery disasters failures user errors operating system backup cold hot backup full backup incremental cumulative backup implementing backup recovery strategies using rman deployed standby databases using data guard 11g maximum performance created altered database storage structures meet user needs created program backups information recovery systems developed ran autonomous database backups partnered project management teams development scope timelines promoted high customer satisfaction resolving problems knowledgeable friendly service worked successfully diverse group coworkers accomplish goals address issues related products services worked closely team members deliver project requirements develop solutions meet deadlines prioritized organized tasks efficiently accomplish service goals updated inspected database security features protocols managed user accounts support systems within complex oracle database cloud systems bachelor science economics 012012 university yaound ii soa yaounde ii soa english negotiated oracle 12c database administrator oca license aws solution architect ongoing education training languages french negotiated certifications