Contractor Postgres DBA

Job Title: Technical Specialist
Education: MCA/B.E/ Graduation
Experience: 8years
Location: Bangalore/Mumbai/Hyderabad

Key Skills:

• PostgreSQL Open Source and EDB PostgreSQL.

• AWS Microsoft Azure and GCP - PostgreSQL.

• Pgbadger PgAdmin Pgbouncer BARMAN pgbackrest repmgr Patroni and pgrepack

Job Description:

• 7 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 pgrestore and Point in time recovery (PITR).

• Expertise in Applying database patches from lower version to higher version.

• Major and Minor upgrade of PostgreSQL DBs on multiple platforms (pgdump/pgrestore & pgupgrade).

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