Senior Consultant
CurrentHandled Database size ranging from 50 GB to 6+ TB. Maintaining the database server software, using utilities such as pg_ctl or psql to restart services or manually restarting them if necessary.Performing regular scheduled maintenance on the database server, such as vacuum analysis on large tables to remove bloat data.Managing disaster recovery procedures to ensure that data is safe in case of a physical disaster such as fire or flood.Responsible for regular backups and recovery of databases.Assist in planning and performing PostgreSQL database upgrades and migrations.Managing streaming replication.Configuration DR databases for disaster recovery.Scheduled scripts for daily backups and mails.Configured incremental backup and PITR through BARMAN tool. Created DB links in postgres for remote database access.