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/recoverystrategies.
● 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.