Datavail

Associate Database Administrator

Datavail

full-time

Posted on:

Location Type: Hybrid

Location: Hyderabad • India

Visit company website

Explore more

✨ AI Apply
Apply

Tech Stack

AzureCloudOraclePostgres

About the role

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

Requirements

  • 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.
Benefits
  • Your Certifications would be on us.
  • Future Opportunity for permanent deputation on H1B to work in US.
  • Leverage the DV Training program to upscale the technical skills.
Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools
PostgreSQL Database ArchitectureDatabase Logical BackupsDatabase Physical Backupspg_restorePoint in time recovery (PITR)Database patchespg_dumppg_upgradeStreaming ReplicationShell scripts