Schedule - PGConf NYC 2024

Photo of Suyog Sampat Pagare

Suyog Sampat Pagare

Company: Datavail Corporation

Certified Database Administrator with experience as a SQL Database Administrator – DBA with 9 years of experience with in-depth knowledge of Database tools like SQL Enterprise Manager, SSMS, SQL Profiler, Performance Dashboard, and MBSA. Creative, highly organized candidate; expert in the design, development, and delivery of cost-effective, high-performance technology solutions.Extensive qualifications in all facets of project lifecycle development Proven ability to integrate out-of-the-box thinking & problem-solving analysis to improve processes, systems, and methodologies

PostgreSQL DBA with 4+ yrs of experience, and knowledge of AWS, Azure, and GCP PAAS DBMS. Migration of on-premise to AWS\Azure\GCP Cloud RDS databases. Experience in Migration from Oracle to PostgreSQL databases. Experience in Migration from SQL to PostgreSQL databases using Babelfish.

Experience in Migration of on-premises databases to AWS RDS and Aurora PostgreSQL DB. Experience in Upgrading 30 TB PostgreSQL database using Near zero downtime. Knowledge of Terraform and cloud formation for automating infrastructure as code. Experience in migration and setting up high availability(HADR) MSSQL and PostgreSQL databases in AWS\Azure cloud and setting up automatic failover for databases to make fault tolerance. Expertise in encryption - Data at rest and SSL encryption. Expertise in Production Database change support and following ITIL guidelines. Expertise in handling multiple Database projects, Completed many Version upgrades and minor upgrades. Expertise in optimization and Database performance improvement using performance insight. Setup Cloud formation templates for monitoring Cloudwatch metrics.

2x speaker in SQL PASS Summit Seattle.

Sessions