PostgreSQL database expert

PROFESSIONAL SUMMARY:
● Having 8 Years of PostgreSQL DBA (open source, AWS RDS, AZURE , GCP CLOUD)
Database Administration in Production and Non-Production Environments.
● Expertise in Installing, initialization, configuring, backup, restore and High Availability
Solutions (Replication)
● Upgraded PostgreSQL versions & aws rds (postgresql), azure postgresql from 11,12
to 12.4,13,14,15 using pg_upgrade and pg_dumpall & ( aws rds & azure
postgresql patch)
● Experience in setup, configuring and maintaining Rep Manager and Hot standby open
source, (aws rds postgresql & azure postgresql) HA/DR solutions.
● Experience in working with production (24 x 7) and QA/DEV/SIT/UAT/PREPROD/Test
environments.
● Able to configure cron jobs for routine activities and troubleshooting them in case of
failures.
● Familiar with implementation strategies, backup/recovery strategies.
● Creating database users, controlling access and making sure right people get access to
right data and looking after the security issues.
● Troubleshooting space issues and performing Capacity Planning for Production
Database servers.
● Database performance analysing and tuning when required as per application and
business requirements.
● Performing Database Refresh from Production to QA/SIT/DEV/UAT/Test environment as
per Application team request.
● Flexibility working in 24*7 environments.
● Administrating PostgreSQL Servers monitoring, troubleshooting, organizational standards,
and assessment planning and implementation.
● Experience in session management like, checking blocking on the database, killing or
canceling the sessions upon the confirmation from the application team.
● Good knowledge on PITR like table recovery, recovery of the cluster to a certain point of
time.
● Experience in Replication sync issues, troubleshoot the underlying issues and fix them.
Rebuild the standby if required.
● Good understanding of PostgreSQL Architecture.
● Proficient in creating and implementing infrastructure solutions on cloud platforms.
● Performed advanced engineering in configuration,management and deployment of
AWS/Azure cloud environments.
● Experience in provisioning and maintaining services in AWS infrastructure for deploying
cloud applications.
● Managing and Tracking Costs for the resources in AWS and Azure Cloud.
● Implementing and performing in both AWS RDS Database for PostgreSQL & Azure
Database for PostgreSQL flexible servers in Azure.

Attachments (Click to Preview)