Senior Associate Database Administrator - PostgreSQL DBA

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.