jessica claire 100 montgomery st 10th floor 555 4321000 resumesampleexamplecom professional summary 6 years diverse experience administration relational databases extensive technical skills understanding postgresql ms sql server databases cloud onprem strong collaborator team player excellent communication skills expertise analytical problemsolving key participant daily meetings discuss new database maintenance strategies backups creation installing configuring open source enterprise databases systems experience designing database structures indexes views partitioning installing configuring multiple postgresql utilities eg efm pgbouncer pgpool pgbadger pg backrest pg repack etc installing configuring ms sql server 2017 2019 2021 standard enterprise editions postgresql 10x 11x 12x 13x 14x aws rds ec2 installed configured upgraded migrated necessary maintain several instances troubleshoot replication corruption issues fix appropriate extensive work experience production databases postgresql edb postgres rds postgres ms sql server mysql linuxunix centos debian ubuntu kubernetes skills aws rds s3 ec2 lambda performance insights cloudwatch kms explain analyzed database development relational database management postgresql extensions pg cron pg repack pgbadger pg stat statements etc replication upgrade migration etc pgbouncerpgpoolii efm mtk pg dump greenblue deployment pg upgrade pg hbaconf postgresqlconf etc ansible terraform awx problemsolving multitasking abilities analytical critical thinking dbeaver pgadmin dynatrace psql scripting etc work history cloud database administrator postgresql ms sql 072022 current cognizant technology solutions mckinney tx taking backup postgresql databases running aws rds using pg dump aws lambda awx backup configured ms sql server option group called nativebackuprestore backup ms sql databases running aws rds store s3 bucket working collaboration sre team database monitoring monitored databases using dynatrace performance insights enhanced monitoring cloudwacth dynatrace compared 2 different schemas two different databases find missing tables using pg admin installing configuring postgresql ms sql databases running aws rds onpremises configuration pgbadger analyze results load testings order address database issues stand production database snapshot staging environment shared different aws account modification rds databases enable features like performance insights enhanced monitoring delete protection etc upgraded multiple postgresql databases 10x 12 13x homogenous migration postgreql databases onprem aws rds using pg dump pg restore psql assisting deployment teams running database scripts mdl ddl tcl etc taking backup specific database table recommended jira tickets assisting deployment team issues related backup restore etc worked devops team address database readiness new deployment troubleshooted staging production databases resolved issues corruptions queries database latency checking fragmentations database integrity custom database report memory management thread tasks managements buffer management configuration postgresql ms sql server parameter group address specifics database problem based result investigations proposed dba maintenance plan strategy resolve database issues specially critical production databases configured pg cron automate db maintenance tasks like vacuum analyze reindex cluster resolved issues cache missed bloat temp files deadlocks locks frequent checkpoints index corruption latency due table size full storage extension present rsd allow extensions high cpu usage etc configured pg repack full database vacuum minimum downtime scheduled sql agents resolve issues fragmentation kill sleeping processes ms sql server databases used basics kubernetes commands find information per business requirement providing response systemdatabase issues 24 x 7 schedule responding critical events situations outside normal work hours monitored database index partitioning memory io utilization connect rds ms sql server using ms sql management studio used explain explain analyze identify fine tune sql queries performance improvements switched database production testing testing production prepared technical interview questions interview candidates position database administrator familiarity parameter store route 53 ebs lastpass etc postgresql database administrator 022019 052022 active network remote de create iam user accounts rolebased policies access aws postgres rds ec2 instances compared custom default parameters group defined aws security groups acted virtual firewalls controlled traffic allowed reach one aws ec2 instances manage space storage databases various shell scripts scheduled crontab periodically regular intervals performed database refreshes monitored replication delays highly experienced configuration implementation maintenance log shipping created new cluster upgraded cluster another postgresql sever database secutity row level security search path pg hbaconf postgresqlconf installed configured mtk migration oracle postgresql edb advance server maintained postgresql pgadmin 4 psq created tablespace databases indexes moving data granting necessary privileges posgresql edb advance server 96 12x performed backup restore created databases using pgadmin 4 pg dump pg basebackup pg backrest created tablespaces schemas users profiles implementing various adjustments postgresqlconf file granting users application access pg hbaconf file etc tuning autovacuum parameters ensure date table stats reclaim space consumed dead tuples provided response systemdatabase issues 24 x 7 schedule responding critical events situations outside normal work hours worked development operations teams tune production queries optimal performance proactive managing standby replication methodologies like streaming replication hot standby disaster recovery configuring monitoring tools better performance like pem cloudwatch performance insight postgresql logs proactive updating latest security patches database provided postgresql opensource community configured database installation creating tables schemas monitored database index partitioning memory io utilization configured enterprise failover manager fast database failover integrate pg poolii connection pooling load balancing resolve issues locks deadlocks implemented cascading replication databases running ec2 used explain explain analyze identify fine tune sql queries performance improvements database administrator 022018 012019 cvs pharmacy city state maintained detailed technical documentation database architecture modeling per business requirements provided technical assistance preparation shell scripts tasks automation conducted complete analysis database capacity performance requirements implemented procedures analysis consolidation tuning databases efficiency implemented database replication replication monitoring configured pg bouncer load connection pooling upgraded databases 96 10x 11x using pg upgrade performed database maintenance tasks like vacuum analyze vacuum full reindex cluster create index etc monitored using datadog scheduled jobs using crontab junior database administrator mysql postgresql 012015 112017 trader joes city state responsible configuring integrating maintaining development qa staging production postgresql databases within organization implement configure troubleshoot database instances replication backup partitions storage access set user privileges within outside database environment pg hbaconf migration data reports generated various vendors postgresql databases using postgresql exportimport procedures manage space storage databases various shell scripts scheduled crontab periodically regular intervals migration data reports generated various vendors postgresql databases using postgresql exportimport procedures production hours resolved lockdeadlocks resource contention issues administered supported monitored databases proactively resolving database issues maintaining servers pg dump pg basebackup xtra backup mysql monitored databases using solarwinds created mysql postgresql databases familiarity psql dml ddl dcl etc performed mysql daily maintenance tasks reloadrefresh privilege grants tables started stopped reloaded databases database security row level security search path pg hbaconf postgresqlconf certification postgresql12 certified associate 032022 enterprisedb usa bachelor science computer science 082014 university douala douala cameroon education