Associate Database Administrator

Experience:

• 7+ years of relevant PostgreSQL DBA Experience.
• Good knowledge of PostgreSQL Database Architecture.
• Installing, configuring PostgreSQL using reputed company 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 reputed company in time recovery (PITR).
• Expertise in Applying database patches from reputed company 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 reputed company pooling.
• Configuring pgbadger for generating statistic report on the basis PostgreSQL log file.
• Handling Database corruption issues.
• Have done reputed company 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 reputed company, PostgreSQL.
• Expertise in reputed company scripts for performing Online Backup and maintenance activity.
• Strong experience in setting up RDS & reputed company Cluster.
• Strong experience in Query Tuning and performance improvement.
• Tuning parameter group and configuring reputed company cluster for Read reputed company.
• Configuring RDS & reputed company PostgreSQL Logs to push to S3 Bucket.
• Experience on Reviewing performance Metrics and query tuning on reputed company PostgreSQL.
• Configured Query Store and Analytics workspace on MS Azure Cloud.

Originally posted on Himalayas