Qureos

FIND_THE_RIGHTJOB.

Senior Associate Database Administrator - PostgreSQL DBA

JOB_REQUIREMENTS

Hires in

Not specified

Employment Type

Not specified

Company Location

Not specified

Salary

Not specified

Job Title: Senior Associate Database Administrator - PostgreSQL DBA

Education: Any Graduate

Experience: 6+years

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:

  • 6+ 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.

© 2025 Qureos. All rights reserved.