Mannu Sharma

About Mannu Sharma

Having 12.5 Years of total experience and 10+ years as Database Admin under…

Experience

1. Postgresql Aws- Technical Lead

   Coforge

   Jun 2024 — Present · Noida, IN

   Configured PostgreSQL for different environments- Performed database upgrades using AWS, pg_upgrade- Used pgAdmin for database management- Migrated Oracle databases to PostgreSQL on-premises and AWS using Ora2pg- Set up and monitor master-slave replication- Implemented streaming replication slots for reporting- Tuned SQL and PostgreSQL performance- Skilled in performing routine database maintenance tasks such as VACUUM, VACUUM FULL, ANALYZE, and REINDEX to improve database performance on AWS RDS instances- Executed core DBA tasks, including role and privilege management- Performed maintenance tasks like vacuum and analyze- Tuned server settings and resolved performance issues- Configured pgBadger for report generation- Managed connection pooling with PgBouncer- Automated monitoring and backups with custom scripts and cronjobs- Managed logical and physical backups using pg_dump and pg_BaseBackUp- Experienced in restoration techniques like pg_restore and Point in Time Recovery (PITR)- Configured and managed cross-region read replicas for PostgreSQL RDS, providing fault tolerance and improved read performance for globally distributed applications- Implemented and automated backup strategies using AWS RDS automated backups and manual snapshots, ensuring quick recovery and minimal data loss in case of failures.