Associate Database Administrator - PostgreSQL

Job Title: Associate Database Administrator, Education: Any Graduate Experience: 5 to 8years Location: Bengaluru/Hyderabad/Mumbai Key Skills: • PostgreSQL Open Source and EDB PostgreSQL. • AWS, Microsoft Azure and GCP - PostgreSQL. • Pgbadger, PgAdmin, Pgbouncer, BARMAN, pgbackrest, repmgr, Patroni and pg_repack Job Description: • 5+ 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. • 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 on Aurora PostgreSQL. Configured Query Store and Analytics workspace on MS Azure Cloud.