SUMMARY:

• PostgreSQL DBA with 5+ years of experience, having knowledge and ability to perform all teh databases management skills of data administration and developing PostgreSQL databases for high - traffic, high-availability environments.
• Proven ability to optimize database performance, troubleshoot issues, ensure data security, databases analysis, and backup and recovery.
• Installed, configured, and managed PostgreSQL servers, PostgreSQL Version, SQL Server 2012, 2016
• PostgreSQL Security, roles, group roles and row level security, privileges,
• High Availability (always on, log shipping, clustering), Backup(full/log/diff) & restore (using SSMS), Automating Alerts, using SQL to set thresholds and triggers.
• Scripting & Automation, Data warehousing (ETL, SSRS, SSIR)
• HA solution, Streaming Replication, Setup logical Replication, configure Repmgr, pgBadger, pgbouncer, pg basebackup, pgBackRest, pg dump, pg dumpall, pgAdmin 4.

PROFESSIONAL EXPERIENCE:

Confidential - TX

PostgreSQL Database Administrator

Responsibilities:

• Managed and supported a large PostgreSQL database including backups, restores, monitoring, and performance tuning.
• Managed PostgreSQL servers both on-prem and cloud in staging, development, and production environments and recently worked with PostgreSQL Version 9.6, 10, 11, and 12 Community and Enterprise editions.
• Experience in upgrading and migrating various versions of PostgreSQL to higher versions.
• Troubleshooting applications SQLs and database performance tuning, table partitioning, used EXPLAIN PLAN utilities for optimizing and tuning SQL queries.
• Using Customized scripts to monitor database growth, table growth, automated backups using cronjobs.
• Experienced in writing Unix/Shell Scripts for reports and custom jobs.
• Migrated on-prem Postgres to AWS RDS
• Experience in managing Postgres servers in AWS RDS cloud environment
• Worked extensively on performance tuning of PostgreSQL server, queries by maintaining aggregate, compression, partition, indexing hints.
• Experienced in handling logical and physical database Backups. Assisted in implementing best used restoration techniques like (PITR) Point in Time Recovery
• High availability solutions configuring streaming replication and EFM to monitor and automate failover as needed, experienced in using logical replication.
• Used automated scripts to backup teh database nightly and restore it in case of failure or migration to new hardware.
• Proactive monitoring of databases with teh use of custom script to monitor database growth, table growth and fix any performance issues to teh best of my abilities.
• Troubleshoots problems related to teh database software or hardware and provided solutions dat improved overall reliability of teh database infrastructure.
• Tuning autovacuum parameters to ensure up to date table stats and reclaim space consumed by dead tuples.
• Documented every operation, configuration, or strategy of troubleshooting in confluence
• Contributed to decreasing need for downtime by developing and improving procedures for automated monitoring and proactive intervention.
• Ensure night cron jobs for backups, re-indexing, vacuuming, & materialized views are properly executed.
• Interfaced with IT department members to optimize system availability and proactively address emergent concerns. Found bottlenecking queries dat impeded application performance and was able to fine-tune them.
• Provided response for all system/database issues on 24 x 7 schedule responding to critical events and situations outside normal work hours. Worked with development and operations teams to tune production queries for optimal performance
• Monitor space utilization on pg wal
• SQL reports dat meet client expectations for teh application (used by custom application).
• Scheduling database refresh to teh lower environments for proper product testing.
• Configuring log analyzation tools like pgbadger
• Proactive in updating teh latest security patches to database.
• Refreshing Dev and Test instances with data from production on a regular basis.
• Collaborate with development architecture, and release teams, for TEMPeffective PostgreSQL transition to production operation.
• Installing and configuring PEM for monitoring PostgreSQL instances TEMPeffectively.

Confidential - Woonsocket, RI

PostgreSQL Database Administrator

Responsibilities:

• Implementation of database level configuration changes to optimize performance, ensures maintenance of physical integrity of all production database.
• Check teh bloat on tables to adjust my table clean-up strategy.
• Performed routine Postgres database and cluster wide maintenance activities like vacuum/vacuum full, analyse, and reindexing.
• Resolved, and implemented preventive measures to prevent problems for availability, recoverability, and performance of all supported database related tasks.
• Migrated on-prem Postgres to AWS RDS
• Experience in managing Postgres servers in AWS RDS cloud environment
• Managed PostgreSQL servers both on-prem and cloud in staging, development, and production environments and recently worked with PostgreSQL Version 9.6, 10, 11, and 12 Community and Enterprise editions.
• Implemented automated backup system to ensure data was secure and readily available for recovery.
• Experienced with PostgreSQL server settings & troubleshooting performance issues.
• Conducting regular performance reviews of databases, identifying inefficiencies, and proactively resolving issues before they become a problem.
• Proactively managing standby replication methodologies like streaming replication and hot standby for disaster recovery.
• Managed users and tablespaces on PostgreSQL servers.
• Performed daily (PITR) to teh development environment.
• Proactive in updating teh lates security patches to databases which are provided by PostgreSQL open-source community.
• Troubleshoot and resolved database integrity issues, blocking and deadlocking issues
• Implemented database level configuration changes to optimize performance.
• Set up high availability by enabling physical replication for redundancy between a primary server replicating to standby and managed teh replication and automated failover using Enterprise Failover Manager
• Documented every operation, configuration, or strategy of troubleshooting in confluence.