Talent.com
This job offer is not available in your country.
Datavail Infotech - Database Administrator - PostgreSQL

Datavail Infotech - Database Administrator - PostgreSQL

DatavailMumbai
8 days ago
Job 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_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.

    • (ref : hirist.tech)

    Create a job alert for this search

    Database Administrator • Mumbai