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.