Associate Database Administrator

Experience:

• 7+ years of relevant PostgreSQL DBA 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.

Originally posted on Himalayas