Datavail Infotech

Description : - Job Title : PostgreSQL Database Administrator- Education : Any Graduation- Experience : 8+years- Location : Skills : - PostgreSQL Open Source and EDB PostgreSQL- AWS, Microsoft Azure and GCP PostgreSQL- Pgbadger, PgAdmin, Pgbouncer, BARMAN, pgbackrest, repmgr, Patroni and pg_repackJob Description : - 7+ years of relevant Experience- Good knowledge of PostgreSQL Database Architecture- Installing, configuring PostgreSQL using source code, RPM, one-click installation on-prem and Cloud Technologies- Strong experience in handling Database Logical and Physical Backups- Hands on experience on restoration techniques on PostgreSQL like pg_restore and Point in time recovery (PITR)- Expertise in Applying database patches from lower version to higher version- Major and Minor upgrade of PostgreSQL DB's on multiple platforms (pg_dump/pg_restore & pg_upgrade)- Implemented PostgreSQL DR servers and PostgreSQL load balancing using pgpool- Expertise in Streaming Replication (Including Cascading Replication)- Configuring pgbouncer for connection pooling- Configuring pgbadger for generating statistic report on the basis PostgreSQL log file- Handling Database corruption issues- Have done Oracle to PostgreSQL Migration for multiple clients- Strong knowledge on PostgreSQL configuration parameter for tuning the DB health- Managed Users and Tablespace on PostgreSQL Servers- Configuring Heterogeneous DB connections between Oracle, PostgreSQL- Expertise in Shell scripts for performing Online Backup and maintenance activity- Strong experience in setting up RDS & Aurora Cluster- Strong experience in Query Tuning and performance improvement- Tuning parameter group and configuring Aurora cluster for Read Replica- Configuring RDS & Aurora PostgreSQL Logs to push to S3 Bucket- Experience on Reviewing performance Metrics and query tuning on Aurora PostgreSQL- Configured Query Store and Analytics workspace on MS Azure Cloud (ref:hirist.tech)