Datavail Infotech - Database Administrator - PostgreSQL

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 :

- 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.