Description :

- Job Title : PostgreSQL Database Administrator

- Education : Any Graduation

- Experience : 8+years

- Location : Bangalore/Mumbai/Hyderabad

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 :

- 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