Database Administrator Incident Management
Resume:
Tinga fru
Database Administrator
*********@*****.***
A Database Administrator with over 5 years of experience managing postgres databases both on-prem and on the cloud including managing databases running ec2 machines, RDS Postgres and Aurora Postgres.
Managed postgres databases on different OS such as Linux and Windows.
Experienced in change and Incident management, troubleshooting and Performance Tuning using tools such as Explain, analyze, vacuum, planner path, configuration files. I am skilled in different database installations, design, creation, configuration, backup and Recovery using various strategies and tools such as pg_dump/pg_dumpall, psql/pg_restore, pg_basebackup, BARMAN and Manual Scripts, SQL or shell scripts. I have developed expertise in database maintenance, monitoring, data migration on-premises and cloud.
I have Sound knowledge in High Availability and data replication technologies such postgres streaming and logical replication. I am also skilled in different database security implementations including roles, privileges, auditing as well as upgrading, applying latest security patches to databases and database components.
In addition, I am motivational, possess great leadership skills, proactive, bilingual, a team player, a good communicator and always ready to learn. I also pay attention to detail and am good at documenting.
Bachelor’s in computer science
National polytechnic bamanda
AT&T- Dallas, Tx
May 2021 – Present
Postgres Database Administrator
Installed, Configured, Setup, Maintained and Supported postgres 12, 13 Physical and Logical Standby database for Test, Development and Production for various home-developed applications
Installing creating and managing PostgreSQL Database on Unix(linux)
Perform physical backup using pg_base backup and BARMAN
Performe logical backups and restore using pg_dump/pg_dumpall/psql/pg_restore a
Perfom major using migration technic with pg_dump/pg_restore utility as well as in place upgrade using pg_upgrade
Patch postgres with the minor release versions for bug fixes
Proactively identifying, troubleshooting and tuning live databases Performance
Migrate Postgres databases from on-prem(Windows servers) to OCI Linux VMs
Migrate oracle databases to PostgreSQL running on On-prem servers and cloud instances such as EC2 and RDS.
Manage AWS PostgreSQL RDS databases, PostgreSQL Aurora and postgreSQL databases running in EC2 instances
Create RDS read replicas to offload heavy Queries from the Primary database
Backup, tunePostgres Databases running in EC2 instances
Identify and resolved incidents, change requests and address to user problems/concerns.
Create and assign appropriate roles and attributes/permissions to roles depending on the user/application activity.
Perform on-call management of database in a rotatry schedule
Setup notifications (various levels for Cluster activities, tablespace utilizations, alerts) and monitored maintenance activities to achieve optimum database uptime.
Set up a monitoring system to gather performance metrics, tune postgres adding, removing or updating different configuration in the configuration files.
Review and tune SQLs to be run in Prod environment for maximium performance
Monitor postgres database using scripts and datadog
Performing minor and major level upgrades using minimal down by prior testing in test boxes with accurate time notifications.
M&T Bank- Buffalo, New York
April 2019 – April 2021
Database Administrator
Installed and managed Postgres Database on windows
Installed Postgres database on unix(linux) and migrated postgresQSL database from Windows to Unix(linux) server
Managed migrated PostgreSQL database in Unix
Responsible for all backup, recovery testing, and upgrading of all of the PostgreSQL databases. Monitoring databases to optimize database performance and diagnosing any issues.
Responsible for setting up Logical Replication and streaming replication
Daily log analysis using pgbadger tool and query tuning.
Maintained custom vacuum strategies at table and db level. Identifying and fixing the issues on pgdump and pg_restore.
Controlled database security by setting up pg_hba.conf, granting least privileges on object. Knowledge in database designs and user attributes
Responsible for monitoring environments using monitoring tool such datadog, cloudwatcg, performance inside, custom scripts and other supporting tools like pgBadger.
Setup backup and recovery strategies and testing recovery
Monitored the bloat report on every table and performed maintenance with minimal downtime.
Identified and resolved incidents and provide solution to user problems/concerns
Contact this candidate