| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
Database AdministratorPHONE NUMBER AVAILABLEEMAIL AVAILABLEA 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.Bachelors in computer scienceNational polytechnic bamandaAT&T- Dallas, TxMay 2021 PresentPostgres Database AdministratorInstalled, Configured, Setup, Maintained and Supported postgres 12, 13 Physical and Logical Standby database for Test, Development and Production for various home-developed applicationsInstalling creating and managing PostgreSQL Database on Unix(linux)Perform physical backup using pg_base backup and BARMANPerforme logical backups and restore using pg_dump/pg_dumpall/psql/pg_restore aPerfom major using migration technic with pg_dump/pg_restore utility as well as in place upgrade using pg_upgradePatch postgres with the minor release versions for bug fixesProactively identifying, troubleshooting and tuning live databases PerformanceMigrate Postgres databases from on-prem(Windows servers) to OCI Linux VMsMigrate 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 instancesCreate RDS read replicas to offload heavy Queries from the Primary databaseBackup, tunePostgres Databases running in EC2 instancesIdentify 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 scheduleSetup 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 performanceMonitor postgres database using scripts and datadogPerforming minor and major level upgrades using minimal down by prior testing in test boxes with accurate time notifications.M&T Bank- Buffalo, New YorkApril 2019 April 2021Database AdministratorInstalled and managed Postgres Database on windowsInstalled Postgres database on unix(linux) and migrated postgresQSL database from Windows to Unix(linux) serverManaged migrated PostgreSQL database in UnixResponsible 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 replicationDaily 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 attributesResponsible 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 recoveryMonitored the bloat report on every table and performed maintenance with minimal downtime.Identified and resolved incidents and provide solution to user problems/concerns |
